PREVIEW / etf_5min / 2009-03-09

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-03-09.parquet
  size:    671 KB
  rows:    29,030

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
2009-03-09 06:20:00	SPY	ETF	67.74	68.57	67.74	68.3	41440.0
2009-03-09 06:25:00	SPY	ETF	68.21	68.25	68.15	68.25	7700.0
2009-03-09 06:30:00	SPY	ETF	68.25	68.25	68.25	68.25	5000.0
2009-03-09 06:35:00	SPY	ETF	68.27	68.35	68.27	68.35	1300.0
2009-03-09 06:40:00	SPY	ETF	68.31	68.37	68.3	68.32	8600.0
2009-03-09 06:45:00	SPY	ETF	68.31	68.31	68.22	68.22	15600.0
2009-03-09 06:50:00	SPY	ETF	68.16	68.16	68.12	68.15	3360.0
2009-03-09 06:55:00	SPY	ETF	68.21	68.21	68.15	68.17	30900.0
2009-03-09 07:00:00	SPY	ETF	68.17	68.2	67.93	67.95	38123.0
2009-03-09 07:05:00	SPY	ETF	67.95	68.06	67.87	67.99	133552.0
2009-03-09 07:10:00	SPY	ETF	67.99	68.36	67.99	68.36	346225.0
2009-03-09 07:15:00	SPY	ETF	68.27	68.27	68.1	68.1	115600.0
2009-03-09 07:20:00	SPY	ETF	68.14	68.38	68.14	68.36	36950.0
2009-03-09 07:25:00	SPY	ETF	68.36	68.5	68.34	68.48	42890.0
2009-03-09 07:30:00	SPY	ETF	68.46	68.46	68.26	68.32	23950.0
2009-03-09 07:35:00	SPY	ETF	68.33	68.45	68.33	68.4	13700.0
2009-03-09 07:40:00	SPY	ETF	68.44	68.63	68.39	68.61	50100.0
2009-03-09 07:45:00	SPY	ETF	68.55	68.59	68.52	68.52	52050.0
2009-03-09 07:50:00	SPY	ETF	68.52	68.53	68.37	68.37	42776.0
2009-03-09 07:55:00	SPY	ETF	68.38	68.38	68.26	68.29	30846.0
2009-03-09 08:00:00	SPY	ETF	68.31	68.38	68.29	68.33	144167.0
2009-03-09 08:05:00	SPY	ETF	68.32	68.32	68.15	68.2	164923.0
2009-03-09 08:10:00	SPY	ETF	68.05	69.0	68.05	68.19	479841.0
2009-03-09 08:15:00	SPY	ETF	68.2	68.34	68.2	68.33	665783.0
2009-03-09 08:20:00	SPY	ETF	68.34	69.3	67.83	68.4	756312.0
2009-03-09 08:25:00	SPY	ETF	68.39	68.41	68.09	68.16	696922.0
2009-03-09 08:30:00	SPY	ETF	68.15	68.32	68.15	68.3	681185.0
2009-03-09 08:35:00	SPY	ETF	68.31	68.34	68.29	68.33	348817.0
2009-03-09 08:40:00	SPY	ETF	68.33	68.33	68.22	68.24	73250.0
2009-03-09 08:45:00	SPY	ETF	68.23	68.25	68.04	68.2	379803.0
2009-03-09 08:50:00	SPY	ETF	68.19	68.24	68.06	68.11	313237.0
2009-03-09 08:55:00	SPY	ETF	68.11	68.25	68.06	68.25	133358.0
2009-03-09 09:00:00	SPY	ETF	68.25	68.29	68.18	68.29	146699.0
2009-03-09 09:05:00	SPY	ETF	68.27	68.27	68.06	68.07	159942.0
2009-03-09 09:10:00	SPY	ETF	68.06	68.12	67.95	67.96	517601.0
2009-03-09 09:15:00	SPY	ETF	67.98	68.14	67.89	67.97	873875.0
2009-03-09 09:20:00	SPY	ETF	67.97	68.07	67.92	68.04	286612.0
2009-03-09 09:25:00	SPY	ETF	68.05	68.09	67.95	67.95	320796.0
2009-03-09 09:30:00	SPY	ETF	67.95	68.36	67.95	68.35	6854846.0
2009-03-09 09:35:00	SPY	ETF	68.35	68.57	68.31	68.56	5611597.0
2009-03-09 09:40:00	SPY	ETF	68.56	68.83	68.54	68.74	6694975.0
2009-03-09 09:45:00	SPY	ETF	68.74	69.26	68.66	69.21	6703292.0
2009-03-09 09:50:00	SPY	ETF	69.21	69.46	68.8	69.26	8638405.0
2009-03-09 09:55:00	SPY	ETF	69.27	69.33	68.89	68.95	5960883.0
2009-03-09 10:00:00	SPY	ETF	68.95	69.26	68.9	69.22	4085797.0
2009-03-09 10:05:00	SPY	ETF	69.2294	69.78	69.21	69.57	7698648.0
2009-03-09 10:10:00	SPY	ETF	69.56	70.0	69.54	69.8	6587696.0
2009-03-09 10:15:00	SPY	ETF	69.8	70.0	69.71	69.83	6347437.0
2009-03-09 10:20:00	SPY	ETF	69.83	69.88	69.65	69.7	3549359.0
2009-03-09 10:25:00	SPY	ETF	69.69	69.72	69.48	69.49	3482738.0

> showing 50 of 29,030 rows — these rows as CSV

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