PREVIEW / etf_5min / 2008-08-19

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-08-19.parquet
  size:    499 KB
  rows:    23,568

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-08-19 04:15:00	SPY	ETF	128.13	128.13	128.13	128.13	600.0
2008-08-19 05:10:00	SPY	ETF	128.2	128.2	128.2	128.2	3000.0
2008-08-19 05:30:00	SPY	ETF	128.18	128.18	128.18	128.18	1000.0
2008-08-19 05:55:00	SPY	ETF	128.2	128.2	128.2	128.2	100000.0
2008-08-19 06:00:00	SPY	ETF	128.18	128.35	128.17	128.35	56500.0
2008-08-19 06:05:00	SPY	ETF	128.35	128.35	128.27	128.27	15500.0
2008-08-19 06:10:00	SPY	ETF	128.3	128.32	128.27	128.27	44500.0
2008-08-19 06:15:00	SPY	ETF	128.25	128.25	128.07	128.07	51200.0
2008-08-19 06:20:00	SPY	ETF	128.1	128.1	128.1	128.1	15000.0
2008-08-19 06:25:00	SPY	ETF	128.12	128.12	128.08	128.1	52000.0
2008-08-19 06:40:00	SPY	ETF	128.08	128.08	128.04	128.04	25900.0
2008-08-19 06:45:00	SPY	ETF	128.04	128.04	127.95	127.95	33200.0
2008-08-19 06:55:00	SPY	ETF	127.95	127.95	127.95	127.95	10000.0
2008-08-19 07:00:00	SPY	ETF	128.0	128.03	127.98	127.99	51819.0
2008-08-19 07:05:00	SPY	ETF	127.99	128.0	127.97	127.99	51400.0
2008-08-19 07:10:00	SPY	ETF	128.02	128.02	127.95	128.01	25100.0
2008-08-19 07:15:00	SPY	ETF	127.98	127.98	127.89	127.9	74250.0
2008-08-19 07:20:00	SPY	ETF	127.95	127.95	127.89	127.93	67300.0
2008-08-19 07:25:00	SPY	ETF	127.95	127.95	127.85	127.85	37805.0
2008-08-19 07:30:00	SPY	ETF	127.85	127.87	127.8	127.87	20414.0
2008-08-19 07:35:00	SPY	ETF	127.81	127.85	127.8	127.82	109700.0
2008-08-19 07:40:00	SPY	ETF	127.82	127.88	127.82	127.83	81150.0
2008-08-19 07:45:00	SPY	ETF	127.85	127.87	127.79	127.84	60700.0
2008-08-19 07:50:00	SPY	ETF	127.84	127.85	127.74	127.74	33900.0
2008-08-19 07:55:00	SPY	ETF	127.74	127.79	127.71	127.75	134100.0
2008-08-19 08:00:00	SPY	ETF	127.74	127.85	127.74	127.74	290077.0
2008-08-19 08:05:00	SPY	ETF	127.73	127.73	127.61	127.63	457601.0
2008-08-19 08:10:00	SPY	ETF	127.97	127.99	127.59	127.66	139080.0
2008-08-19 08:15:00	SPY	ETF	127.66	127.73	127.65	127.73	322805.0
2008-08-19 08:20:00	SPY	ETF	127.74	127.76	127.71	127.73	98458.0
2008-08-19 08:25:00	SPY	ETF	127.74	127.8	127.63	127.63	245667.0
2008-08-19 08:30:00	SPY	ETF	127.68	127.79	127.13	127.22	2788860.0
2008-08-19 08:35:00	SPY	ETF	127.21	127.39	127.2	127.39	445903.0
2008-08-19 08:40:00	SPY	ETF	127.4	127.45	127.31	127.32	747847.0
2008-08-19 08:45:00	SPY	ETF	127.32	127.35	127.22	127.23	297713.0
2008-08-19 08:50:00	SPY	ETF	127.23	127.32	127.1	127.17	661160.0
2008-08-19 08:55:00	SPY	ETF	127.16	127.21	127.15	127.21	90465.0
2008-08-19 09:00:00	SPY	ETF	127.2	127.37	127.2	127.36	1210044.0
2008-08-19 09:05:00	SPY	ETF	127.34	127.41	127.29	127.29	109583.0
2008-08-19 09:10:00	SPY	ETF	127.27	127.33	127.24	127.29	126604.0
2008-08-19 09:15:00	SPY	ETF	127.28	127.37	127.28	127.37	143254.0
2008-08-19 09:20:00	SPY	ETF	127.37	128.39	127.32	127.4	66639.0
2008-08-19 09:25:00	SPY	ETF	127.38	127.43	127.36	127.43	160246.0
2008-08-19 09:30:00	SPY	ETF	127.42	127.54	127.26	127.35	6680684.0
2008-08-19 09:35:00	SPY	ETF	127.35	127.69	127.33	127.56	5086197.0
2008-08-19 09:40:00	SPY	ETF	127.56	127.6	127.32	127.52	3256395.0
2008-08-19 09:45:00	SPY	ETF	127.53	127.61	127.09	127.1	4374081.0
2008-08-19 09:50:00	SPY	ETF	127.11	127.55	126.98	127.27	5481065.0
2008-08-19 09:55:00	SPY	ETF	127.27	127.43	127.19	127.28	3491674.0
2008-08-19 10:00:00	SPY	ETF	127.28	127.35	127.11	127.21	2716120.0

> showing 50 of 23,568 rows — these rows as CSV

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