PREVIEW / etf_5min / 2008-09-09

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-09-09.parquet
  size:    564 KB
  rows:    25,696

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-09-09 04:20:00	SPY	ETF	127.58	127.58	127.58	127.58	100.0
2008-09-09 04:30:00	SPY	ETF	127.5	127.5	127.5	127.5	200.0
2008-09-09 05:55:00	SPY	ETF	127.44	127.44	127.44	127.44	3000.0
2008-09-09 06:10:00	SPY	ETF	127.68	127.68	127.68	127.68	100.0
2008-09-09 06:15:00	SPY	ETF	127.73	127.73	127.73	127.73	2000.0
2008-09-09 06:25:00	SPY	ETF	127.63	127.63	127.63	127.63	100.0
2008-09-09 06:30:00	SPY	ETF	127.68	127.75	127.68	127.68	116000.0
2008-09-09 06:35:00	SPY	ETF	127.74	127.74	127.74	127.74	500.0
2008-09-09 06:40:00	SPY	ETF	127.7	127.7	127.7	127.7	500.0
2008-09-09 06:45:00	SPY	ETF	127.71	127.73	127.68	127.68	38000.0
2008-09-09 06:50:00	SPY	ETF	127.66	127.66	127.58	127.58	15000.0
2008-09-09 06:55:00	SPY	ETF	127.6	127.6	127.49	127.54	9800.0
2008-09-09 07:00:00	SPY	ETF	127.51	127.56	127.51	127.56	11035.0
2008-09-09 07:05:00	SPY	ETF	127.6	127.73	127.6	127.66	315480.0
2008-09-09 07:10:00	SPY	ETF	127.68	127.75	127.67	127.75	58887.0
2008-09-09 07:15:00	SPY	ETF	127.74	127.88	127.7	127.87	200800.0
2008-09-09 07:20:00	SPY	ETF	127.86	127.92	127.77	127.82	70900.0
2008-09-09 07:25:00	SPY	ETF	127.82	127.82	127.75	127.77	55383.0
2008-09-09 07:30:00	SPY	ETF	127.76	127.76	127.65	127.7	58000.0
2008-09-09 07:35:00	SPY	ETF	127.69	127.75	127.69	127.73	27117.0
2008-09-09 07:40:00	SPY	ETF	127.73	127.73	127.67	127.67	17220.0
2008-09-09 07:45:00	SPY	ETF	127.68	127.7	127.67	127.7	22400.0
2008-09-09 07:50:00	SPY	ETF	127.7	127.75	127.7	127.75	38700.0
2008-09-09 07:55:00	SPY	ETF	127.76	127.83	127.76	127.76	163592.0
2008-09-09 08:00:00	SPY	ETF	127.77	127.82	126.72	127.76	789522.0
2008-09-09 08:05:00	SPY	ETF	127.76	127.78	127.62	127.66	447096.0
2008-09-09 08:10:00	SPY	ETF	127.62	127.64	127.53	127.61	309232.0
2008-09-09 08:15:00	SPY	ETF	127.59	127.61	127.53	127.55	54561.0
2008-09-09 08:20:00	SPY	ETF	127.55	127.56	127.47	127.54	839770.0
2008-09-09 08:25:00	SPY	ETF	127.54	127.59	127.49	127.49	244602.0
2008-09-09 08:30:00	SPY	ETF	127.5	127.52	127.46	127.48	162478.0
2008-09-09 08:35:00	SPY	ETF	127.46	127.52	127.44	127.52	237178.0
2008-09-09 08:40:00	SPY	ETF	127.52	127.53	127.46	127.5	160227.0
2008-09-09 08:45:00	SPY	ETF	127.49	127.49	127.3	127.32	435704.0
2008-09-09 08:50:00	SPY	ETF	127.32	127.36	127.27	127.3	417273.0
2008-09-09 08:55:00	SPY	ETF	127.29	127.29	127.08	127.09	1232803.0
2008-09-09 09:00:00	SPY	ETF	127.09	127.13	126.98	127.07	760355.0
2008-09-09 09:05:00	SPY	ETF	127.08	127.26	127.07	127.26	277377.0
2008-09-09 09:10:00	SPY	ETF	127.26	127.29	127.15	127.19	128825.0
2008-09-09 09:15:00	SPY	ETF	127.18	127.19	127.11	127.14	90746.0
2008-09-09 09:20:00	SPY	ETF	127.14	127.2	127.03	127.04	153757.0
2008-09-09 09:25:00	SPY	ETF	127.05	127.11	126.99	127.11	402700.0
2008-09-09 09:30:00	SPY	ETF	127.1	127.12	126.62	126.63	9742360.0
2008-09-09 09:35:00	SPY	ETF	126.63	126.77	126.28	126.44	6007303.0
2008-09-09 09:40:00	SPY	ETF	126.43	127.08	126.35	126.79	8097058.0
2008-09-09 09:45:00	SPY	ETF	126.79	127.18	126.71	127.09	6843162.0
2008-09-09 09:50:00	SPY	ETF	127.09	127.3	126.92	127.25	7200852.0
2008-09-09 09:55:00	SPY	ETF	127.255	127.32	127.11	127.13	4223168.0
2008-09-09 10:00:00	SPY	ETF	127.23	127.26	126.93	127.14	8101859.0
2008-09-09 10:05:00	SPY	ETF	127.14	127.36	126.93	126.97	4106149.0

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

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