PREVIEW / etf_5min / 2008-05-01

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-05-01.parquet
  size:    510 KB
  rows:    22,564

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-05-01 05:20:00	SPY	ETF	138.69	138.69	138.69	138.69	1000.0
2008-05-01 06:00:00	SPY	ETF	138.8	138.8	138.8	138.8	1000.0
2008-05-01 06:10:00	SPY	ETF	138.8	138.8	138.8	138.8	2000.0
2008-05-01 06:15:00	SPY	ETF	138.78	138.78	138.76	138.76	74000.0
2008-05-01 06:20:00	SPY	ETF	138.78	138.8	138.78	138.8	1800.0
2008-05-01 06:30:00	SPY	ETF	138.8	138.8	138.8	138.8	24300.0
2008-05-01 06:35:00	SPY	ETF	138.85	138.85	138.85	138.85	200.0
2008-05-01 06:40:00	SPY	ETF	138.85	138.9	138.85	138.9	29900.0
2008-05-01 06:45:00	SPY	ETF	138.88	138.88	138.88	138.88	12000.0
2008-05-01 06:50:00	SPY	ETF	138.89	138.9	138.89	138.9	11000.0
2008-05-01 06:55:00	SPY	ETF	138.8	138.85	138.8	138.85	2100.0
2008-05-01 07:00:00	SPY	ETF	138.9	138.9	138.86	138.86	4500.0
2008-05-01 07:05:00	SPY	ETF	138.85	138.85	138.8	138.8	6100.0
2008-05-01 07:10:00	SPY	ETF	138.86	138.89	138.86	138.89	31000.0
2008-05-01 07:15:00	SPY	ETF	138.89	138.92	138.89	138.9	124784.0
2008-05-01 07:20:00	SPY	ETF	138.9	138.9	138.9	138.9	49016.0
2008-05-01 07:25:00	SPY	ETF	138.9	138.9	138.85	138.88	1284.0
2008-05-01 07:30:00	SPY	ETF	138.89	138.89	138.8	138.82	129800.0
2008-05-01 07:35:00	SPY	ETF	138.83	138.87	138.8	138.87	233891.0
2008-05-01 07:40:00	SPY	ETF	138.87	138.89	138.87	138.88	56220.0
2008-05-01 07:45:00	SPY	ETF	138.88	138.88	138.82	138.82	17566.0
2008-05-01 07:50:00	SPY	ETF	138.88	138.88	138.88	138.88	41000.0
2008-05-01 07:55:00	SPY	ETF	138.88	138.91	138.88	138.91	52470.0
2008-05-01 08:00:00	SPY	ETF	138.88	138.88	138.65	138.69	510445.0
2008-05-01 08:05:00	SPY	ETF	138.72	138.72	138.65	138.65	73900.0
2008-05-01 08:10:00	SPY	ETF	138.67	138.74	138.66	138.72	79425.0
2008-05-01 08:15:00	SPY	ETF	138.72	138.78	138.71	138.78	126200.0
2008-05-01 08:20:00	SPY	ETF	138.75	138.78	138.72	138.77	212339.0
2008-05-01 08:25:00	SPY	ETF	138.75	138.91	138.74	138.79	206546.0
2008-05-01 08:30:00	SPY	ETF	138.66	138.88	138.42	138.62	968660.0
2008-05-01 08:35:00	SPY	ETF	138.63	138.72	138.62	138.63	399474.0
2008-05-01 08:40:00	SPY	ETF	138.62	138.62	138.5	138.54	500540.0
2008-05-01 08:45:00	SPY	ETF	138.53	138.57	138.5	138.5	121254.0
2008-05-01 08:50:00	SPY	ETF	138.51	138.55	138.26	138.53	28609.0
2008-05-01 08:55:00	SPY	ETF	138.53	138.54	138.26	138.46	47565.0
2008-05-01 09:00:00	SPY	ETF	138.46	138.5	138.45	138.46	187378.0
2008-05-01 09:05:00	SPY	ETF	138.45	138.47	138.31	138.36	463858.0
2008-05-01 09:10:00	SPY	ETF	138.35	138.41	138.34	138.38	165523.0
2008-05-01 09:15:00	SPY	ETF	138.37	138.37	138.31	138.32	195258.0
2008-05-01 09:20:00	SPY	ETF	138.34	138.36	138.3	138.33	77853.0
2008-05-01 09:25:00	SPY	ETF	138.33	138.43	138.32	138.39	164099.0
2008-05-01 09:30:00	SPY	ETF	138.39	138.58	138.35	138.44	2426037.0
2008-05-01 09:35:00	SPY	ETF	138.45	138.5799	138.3	138.35	1750330.0
2008-05-01 09:40:00	SPY	ETF	138.35	138.6	138.27	138.58	2365356.0
2008-05-01 09:45:00	SPY	ETF	138.59	138.75	138.56	138.64	3526268.0
2008-05-01 09:50:00	SPY	ETF	138.63	138.85	138.5775	138.82	2003975.0
2008-05-01 09:55:00	SPY	ETF	138.81	138.95	138.68	138.75	3103354.0
2008-05-01 10:00:00	SPY	ETF	138.75	139.15	138.68	139.08	6333101.0
2008-05-01 10:05:00	SPY	ETF	139.08	139.1	138.87	138.99	2804586.0
2008-05-01 10:10:00	SPY	ETF	138.99	139.1	138.86	138.92	1649742.0

> showing 50 of 22,564 rows — these rows as CSV

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