PREVIEW / etf_1min / 2009-03-30

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-03-30.parquet
  size:    1.6 MB
  rows:    89,940

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.85	8044.0
2009-03-30 04:16:00	SPY	ETF	79.76	79.76	79.76	79.76	140.0
2009-03-30 04:18:00	SPY	ETF	79.85	79.85	79.85	79.85	200.0
2009-03-30 04:19:00	SPY	ETF	79.8	79.8	79.8	79.8	100.0
2009-03-30 04:21:00	SPY	ETF	79.68	79.68	79.68	79.68	100.0
2009-03-30 04:23:00	SPY	ETF	79.81	79.81	79.81	79.81	100.0
2009-03-30 04:29:00	SPY	ETF	79.93	79.93	79.93	79.93	100.0
2009-03-30 04:32:00	SPY	ETF	80.05	80.05	80.05	80.05	400.0
2009-03-30 04:39: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:46:00	SPY	ETF	79.85	79.85	79.85	79.85	200.0
2009-03-30 04:52:00	SPY	ETF	79.8	79.8	79.8	79.8	100.0
2009-03-30 05:01: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:17:00	SPY	ETF	79.93	80.0	79.93	80.0	1800.0
2009-03-30 05:18:00	SPY	ETF	80.0	80.0	80.0	80.0	11000.0
2009-03-30 05:19:00	SPY	ETF	80.0	80.0	80.0	80.0	2200.0
2009-03-30 05:22:00	SPY	ETF	80.04	80.04	80.04	80.04	500.0
2009-03-30 05:28: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.95	79.95	500.0
2009-03-30 05:41:00	SPY	ETF	79.95	79.95	79.93	79.93	11400.0
2009-03-30 05:42:00	SPY	ETF	79.93	79.93	79.93	79.93	500.0
2009-03-30 05:43:00	SPY	ETF	79.92	79.92	79.9	79.9	20100.0
2009-03-30 05:44:00	SPY	ETF	79.89	79.89	79.88	79.88	10000.0
2009-03-30 05:53: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:06:00	SPY	ETF	80.1	80.11	80.1	80.11	1200.0
2009-03-30 06:09:00	SPY	ETF	80.04	80.04	79.98	79.98	500.0
2009-03-30 06:10:00	SPY	ETF	79.96	79.96	79.96	79.96	801.0
2009-03-30 06:21:00	SPY	ETF	80.01	80.01	80.01	80.01	690.0
2009-03-30 06:28:00	SPY	ETF	80.0	80.02	80.0	80.02	5400.0
2009-03-30 06:29:00	SPY	ETF	80.0	80.0	80.0	80.0	5100.0
2009-03-30 06:31:00	SPY	ETF	80.0	80.0	80.0	80.0	500.0
2009-03-30 06:33:00	SPY	ETF	80.03	80.06	80.03	80.06	10000.0
2009-03-30 06:35:00	SPY	ETF	80.09	80.1	80.06	80.1	5700.0
2009-03-30 06:36:00	SPY	ETF	80.15	80.15	80.15	80.15	1500.0
2009-03-30 06:39:00	SPY	ETF	80.15	80.15	80.15	80.15	100.0
2009-03-30 06:42:00	SPY	ETF	80.18	80.18	80.18	80.18	150.0
2009-03-30 06:43:00	SPY	ETF	80.2	80.2	80.18	80.18	2950.0
2009-03-30 06:44:00	SPY	ETF	80.17	80.17	80.17	80.17	100.0
2009-03-30 06:45:00	SPY	ETF	80.15	80.15	80.15	80.15	100.0
2009-03-30 06:48:00	SPY	ETF	80.22	80.22	80.22	80.22	100.0
2009-03-30 06:49:00	SPY	ETF	80.15	80.15	80.15	80.15	2000.0
2009-03-30 06:50:00	SPY	ETF	80.15	80.17	80.15	80.15	5400.0
2009-03-30 06:51:00	SPY	ETF	80.15	80.15	80.15	80.15	11000.0
2009-03-30 06:53:00	SPY	ETF	80.18	80.18	80.18	80.18	120.0
2009-03-30 06:54:00	SPY	ETF	80.15	80.15	80.15	80.15	6200.0
2009-03-30 06:55:00	SPY	ETF	80.15	80.15	80.12	80.12	26100.0
2009-03-30 06:56:00	SPY	ETF	80.2	80.21	80.2	80.21	26200.0

> showing 50 of 89,940 rows — these rows as CSV

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