PREVIEW / etf_5min / 2008-08-27

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-08-27.parquet
  size:    462 KB
  rows:    21,896

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-27 05:20:00	SPY	ETF	127.09	127.09	127.09	127.09	500.0
2008-08-27 05:25:00	SPY	ETF	127.01	127.01	127.01	127.01	100.0
2008-08-27 05:55:00	SPY	ETF	126.98	127.01	126.98	127.01	6000.0
2008-08-27 06:05:00	SPY	ETF	127.09	127.12	127.06	127.12	25000.0
2008-08-27 06:10:00	SPY	ETF	127.13	127.15	127.13	127.15	75000.0
2008-08-27 06:20:00	SPY	ETF	127.08	127.1	127.08	127.1	5000.0
2008-08-27 06:45:00	SPY	ETF	127.04	127.04	127.01	127.01	5000.0
2008-08-27 06:50:00	SPY	ETF	127.12	127.12	127.12	127.12	1000.0
2008-08-27 06:55:00	SPY	ETF	127.12	127.12	127.04	127.04	15000.0
2008-08-27 07:00:00	SPY	ETF	127.02	127.08	127.02	127.05	30400.0
2008-08-27 07:05:00	SPY	ETF	127.05	127.12	127.05	127.1	25900.0
2008-08-27 07:10:00	SPY	ETF	127.17	127.27	127.17	127.26	28800.0
2008-08-27 07:15:00	SPY	ETF	127.27	127.29	127.25	127.27	16000.0
2008-08-27 07:20:00	SPY	ETF	127.29	127.29	127.29	127.29	5600.0
2008-08-27 07:25:00	SPY	ETF	127.3	127.3	127.19	127.19	11500.0
2008-08-27 07:30:00	SPY	ETF	127.19	127.22	127.19	127.2	51300.0
2008-08-27 07:35:00	SPY	ETF	127.15	127.22	127.15	127.2	32899.0
2008-08-27 07:40:00	SPY	ETF	127.15	127.16	127.11	127.11	35563.0
2008-08-27 07:45:00	SPY	ETF	127.11	127.21	127.11	127.18	23292.0
2008-08-27 07:50:00	SPY	ETF	127.19	127.22	127.18	127.18	1088.0
2008-08-27 07:55:00	SPY	ETF	127.17	127.24	127.17	127.19	16199.0
2008-08-27 08:00:00	SPY	ETF	127.15	127.26	127.15	127.25	581600.0
2008-08-27 08:05:00	SPY	ETF	127.25	127.26	127.24	127.24	151483.0
2008-08-27 08:10:00	SPY	ETF	127.23	127.23	127.14	127.17	60200.0
2008-08-27 08:15:00	SPY	ETF	127.17	127.18	127.01	127.11	315700.0
2008-08-27 08:20:00	SPY	ETF	127.15	127.16	127.06	127.15	181294.0
2008-08-27 08:25:00	SPY	ETF	127.17	127.29	127.15	127.27	95232.0
2008-08-27 08:30:00	SPY	ETF	127.37	127.81	127.27	127.73	2459117.0
2008-08-27 08:35:00	SPY	ETF	127.73	127.99	127.71	127.88	1339999.0
2008-08-27 08:40:00	SPY	ETF	127.87	127.9	127.73	127.76	457263.0
2008-08-27 08:45:00	SPY	ETF	127.77	127.9	127.76	127.82	84350.0
2008-08-27 08:50:00	SPY	ETF	127.82	127.87	127.1	127.82	130315.0
2008-08-27 08:55:00	SPY	ETF	127.8	127.82	127.77	127.77	51000.0
2008-08-27 09:00:00	SPY	ETF	127.76	127.76	127.6	127.7	459526.0
2008-08-27 09:05:00	SPY	ETF	127.68	127.76	127.65	127.76	165422.0
2008-08-27 09:10:00	SPY	ETF	127.77	127.77	127.6	127.63	153449.0
2008-08-27 09:15:00	SPY	ETF	127.61	127.66	127.56	127.58	198723.0
2008-08-27 09:20:00	SPY	ETF	127.59	127.64	127.58	127.62	269326.0
2008-08-27 09:25:00	SPY	ETF	127.62	127.65	127.54	127.56	311928.0
2008-08-27 09:30:00	SPY	ETF	127.55	127.61	127.44	127.47	2738395.0
2008-08-27 09:35:00	SPY	ETF	127.48	127.73	127.39	127.72	3125143.0
2008-08-27 09:40:00	SPY	ETF	127.72	127.8	127.54	127.62	2903128.0
2008-08-27 09:45:00	SPY	ETF	127.63	127.63	127.43	127.48	2310327.0
2008-08-27 09:50:00	SPY	ETF	127.5	127.51	127.3	127.38	2487944.0
2008-08-27 09:55:00	SPY	ETF	127.38	127.48	127.33	127.46	1881437.0
2008-08-27 10:00:00	SPY	ETF	127.45	127.68	127.39	127.63	1731396.0
2008-08-27 10:05:00	SPY	ETF	127.63	127.77	127.55	127.69	2274636.0
2008-08-27 10:10:00	SPY	ETF	127.7	127.72	127.56	127.58	723560.0
2008-08-27 10:15:00	SPY	ETF	127.59	127.86	127.55	127.8	1644154.0
2008-08-27 10:20:00	SPY	ETF	127.8	128.07	127.79	127.99	4679847.0

> showing 50 of 21,896 rows — these rows as CSV

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