PREVIEW / etf_5min / 2009-03-30

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-03-30.parquet
  size:    669 KB
  rows:    28,735

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-30 04:10:00	SPY	ETF	79.6	79.6	79.6	79.6	200.0
2009-03-30 04:15:00	SPY	ETF	79.69	80.35	79.69	79.8	8484.0
2009-03-30 04:20:00	SPY	ETF	79.68	79.81	79.68	79.81	200.0
2009-03-30 04:25:00	SPY	ETF	79.93	79.93	79.93	79.93	100.0
2009-03-30 04:30:00	SPY	ETF	80.05	80.05	80.05	80.05	400.0
2009-03-30 04:35:00	SPY	ETF	79.96	79.96	79.96	79.96	1000.0
2009-03-30 04:40:00	SPY	ETF	79.95	79.95	79.89	79.89	1500.0
2009-03-30 04:45:00	SPY	ETF	79.85	79.85	79.85	79.85	200.0
2009-03-30 04:50:00	SPY	ETF	79.8	79.8	79.8	79.8	100.0
2009-03-30 05:00:00	SPY	ETF	79.9	79.95	79.9	79.95	30000.0
2009-03-30 05:05:00	SPY	ETF	79.84	79.84	79.84	79.84	100.0
2009-03-30 05:15:00	SPY	ETF	79.93	80.0	79.93	80.0	15000.0
2009-03-30 05:20:00	SPY	ETF	80.04	80.04	80.04	80.04	500.0
2009-03-30 05:25:00	SPY	ETF	80.0	80.0	80.0	80.0	200.0
2009-03-30 05:40:00	SPY	ETF	79.95	79.95	79.88	79.88	42500.0
2009-03-30 05:50:00	SPY	ETF	79.98	80.0	79.98	80.0	1980.0
2009-03-30 06:00:00	SPY	ETF	80.13	80.13	80.13	80.13	800.0
2009-03-30 06:05:00	SPY	ETF	80.1	80.11	79.98	79.98	1700.0
2009-03-30 06:10:00	SPY	ETF	79.96	79.96	79.96	79.96	801.0
2009-03-30 06:20:00	SPY	ETF	80.01	80.01	80.01	80.01	690.0
2009-03-30 06:25:00	SPY	ETF	80.0	80.02	80.0	80.0	10500.0
2009-03-30 06:30:00	SPY	ETF	80.0	80.06	80.0	80.06	10500.0
2009-03-30 06:35:00	SPY	ETF	80.09	80.15	80.06	80.15	7300.0
2009-03-30 06:40:00	SPY	ETF	80.18	80.2	80.17	80.17	3200.0
2009-03-30 06:45:00	SPY	ETF	80.15	80.22	80.15	80.15	2200.0
2009-03-30 06:50:00	SPY	ETF	80.15	80.18	80.15	80.15	22720.0
2009-03-30 06:55:00	SPY	ETF	80.15	80.22	80.12	80.19	99100.0
2009-03-30 07:00:00	SPY	ETF	80.19	80.26	80.09	80.21	195175.0
2009-03-30 07:05:00	SPY	ETF	80.23	80.33	80.19	80.29	221905.0
2009-03-30 07:10:00	SPY	ETF	80.33	80.34	80.26	80.26	100800.0
2009-03-30 07:15:00	SPY	ETF	80.28	80.34	80.2	80.24	55300.0
2009-03-30 07:20:00	SPY	ETF	80.23	80.25	80.18	80.21	74050.0
2009-03-30 07:25:00	SPY	ETF	80.2	80.23	80.17	80.17	18947.0
2009-03-30 07:30:00	SPY	ETF	80.2	80.23	80.17	80.2	53000.0
2009-03-30 07:35:00	SPY	ETF	80.2	80.25	80.17	80.2	80469.0
2009-03-30 07:40:00	SPY	ETF	80.2	80.22	80.17	80.19	58188.0
2009-03-30 07:45:00	SPY	ETF	80.2	80.25	80.09	80.1	43109.0
2009-03-30 07:50:00	SPY	ETF	80.1	80.11	80.07	80.1	115900.0
2009-03-30 07:55:00	SPY	ETF	80.1	80.15	80.04	80.06	87843.0
2009-03-30 08:00:00	SPY	ETF	80.06	80.21	80.02	80.17	687537.0
2009-03-30 08:05:00	SPY	ETF	80.19	80.21	80.15	80.18	28591.0
2009-03-30 08:10:00	SPY	ETF	80.18	81.3817	80.18	80.27	366405.0
2009-03-30 08:15:00	SPY	ETF	80.28	81.057	80.23	80.25	363744.0
2009-03-30 08:20:00	SPY	ETF	80.23	81.1	80.22	80.22	202230.0
2009-03-30 08:25:00	SPY	ETF	80.22	80.25	79.72	80.17	811084.0
2009-03-30 08:30:00	SPY	ETF	79.35	80.17	79.35	80.13	145004.0
2009-03-30 08:35:00	SPY	ETF	80.13	80.13	80.09	80.11	83445.0
2009-03-30 08:40:00	SPY	ETF	80.12	80.16	80.11	80.15	98923.0
2009-03-30 08:45:00	SPY	ETF	80.16	80.2	80.09	80.09	118444.0
2009-03-30 08:50:00	SPY	ETF	80.08	80.12	80.08	80.1	228249.0

> showing 50 of 28,735 rows — these rows as CSV

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