PREVIEW / etf_5min / 2008-07-01

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-07-01.parquet
  size:    554 KB
  rows:    25,244

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2008-07-01 04:45:00	SPY	ETF	127.8	127.8	127.8	127.8	100.0
2008-07-01 04:50:00	SPY	ETF	127.5	127.5	127.5	127.5	100.0
2008-07-01 05:00:00	SPY	ETF	127.34	127.34	127.34	127.34	100.0
2008-07-01 05:25:00	SPY	ETF	127.0	127.0	127.0	127.0	600.0
2008-07-01 05:30:00	SPY	ETF	126.86	126.86	126.85	126.85	1200.0
2008-07-01 05:45:00	SPY	ETF	126.72	126.72	126.72	126.72	1000.0
2008-07-01 05:50:00	SPY	ETF	126.68	126.68	126.68	126.68	1000.0
2008-07-01 06:15:00	SPY	ETF	126.67	126.7	126.65	126.65	8800.0
2008-07-01 06:20:00	SPY	ETF	126.6	126.61	126.6	126.61	600.0
2008-07-01 06:25:00	SPY	ETF	126.64	126.7	126.64	126.7	104000.0
2008-07-01 06:30:00	SPY	ETF	126.7	126.7	126.7	126.7	1100.0
2008-07-01 06:35:00	SPY	ETF	126.7	126.79	126.7	126.79	49100.0
2008-07-01 06:40:00	SPY	ETF	126.79	126.8	126.79	126.8	27500.0
2008-07-01 06:45:00	SPY	ETF	126.66	126.69	126.6	126.6	223000.0
2008-07-01 06:50:00	SPY	ETF	126.6	126.6	126.45	126.45	114800.0
2008-07-01 06:55:00	SPY	ETF	126.6	126.6	126.6	126.6	26800.0
2008-07-01 07:00:00	SPY	ETF	126.6	126.6	126.5	126.58	158493.0
2008-07-01 07:05:00	SPY	ETF	126.6	126.66	126.6	126.6	184441.0
2008-07-01 07:10:00	SPY	ETF	126.62	126.64	126.58	126.58	237701.0
2008-07-01 07:15:00	SPY	ETF	126.62	126.73	126.55	126.57	689063.0
2008-07-01 07:20:00	SPY	ETF	126.55	126.57	126.53	126.56	480346.0
2008-07-01 07:25:00	SPY	ETF	126.54	126.63	126.5	126.55	162200.0
2008-07-01 07:30:00	SPY	ETF	126.55	126.77	126.55	126.75	164526.0
2008-07-01 07:35:00	SPY	ETF	126.71	126.84	126.71	126.79	101406.0
2008-07-01 07:40:00	SPY	ETF	126.8	126.8	126.64	126.64	53793.0
2008-07-01 07:45:00	SPY	ETF	126.64	126.72	126.53	126.53	57250.0
2008-07-01 07:50:00	SPY	ETF	126.56	126.64	126.55	126.55	84912.0
2008-07-01 07:55:00	SPY	ETF	126.56	126.66	126.53	126.65	196604.0
2008-07-01 08:00:00	SPY	ETF	126.65	126.83	126.51	126.7	756695.0
2008-07-01 08:05:00	SPY	ETF	126.69	126.69	126.58	126.61	85056.0
2008-07-01 08:10:00	SPY	ETF	126.61	126.8	126.6	126.76	237462.0
2008-07-01 08:15:00	SPY	ETF	126.77	126.81	126.73	126.79	477428.0
2008-07-01 08:20:00	SPY	ETF	126.78	126.81	126.71	126.74	452125.0
2008-07-01 08:25:00	SPY	ETF	126.72	127.34	126.69	126.7	178764.0
2008-07-01 08:30:00	SPY	ETF	126.71	126.76	126.59	126.68	529002.0
2008-07-01 08:35:00	SPY	ETF	126.67	126.68	126.58	126.58	56071.0
2008-07-01 08:40:00	SPY	ETF	126.59	126.64	126.53	126.64	352478.0
2008-07-01 08:45:00	SPY	ETF	126.63	126.63	126.6	126.6	245006.0
2008-07-01 08:50:00	SPY	ETF	126.62	126.67	126.57	126.65	187284.0
2008-07-01 08:55:00	SPY	ETF	126.66	126.67	126.58	126.62	162029.0
2008-07-01 09:00:00	SPY	ETF	126.62	126.64	126.51	126.58	179116.0
2008-07-01 09:05:00	SPY	ETF	126.56	127.98	126.47	126.57	283201.0
2008-07-01 09:10:00	SPY	ETF	126.56	127.98	126.36	126.36	578815.0
2008-07-01 09:15:00	SPY	ETF	126.35	126.46	126.34	126.42	1090716.0
2008-07-01 09:20:00	SPY	ETF	126.42	126.55	126.41	126.45	833188.0
2008-07-01 09:25:00	SPY	ETF	126.47	127.98	126.39	126.52	648827.0
2008-07-01 09:30:00	SPY	ETF	126.52	126.8	126.48	126.77	4241758.0
2008-07-01 09:35:00	SPY	ETF	126.77	126.85	126.52	126.68	5606391.0
2008-07-01 09:40:00	SPY	ETF	126.68	126.83	126.6	126.64	4049712.0
2008-07-01 09:45:00	SPY	ETF	126.64	126.99	126.63	126.9	3349354.0

> showing 50 of 25,244 rows — these rows as CSV

> unlock the full archive -- $79 one-time