PREVIEW / etf_5min / 2009-03-23

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-03-23.parquet
  size:    729 KB
  rows:    30,233

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-23 04:10:00	SPY	ETF	78.95	78.95	78.94	78.94	7500.0
2009-03-23 04:15:00	SPY	ETF	78.9	78.98	78.88	78.95	30170.0
2009-03-23 04:20:00	SPY	ETF	78.88	78.88	78.83	78.83	5100.0
2009-03-23 04:35:00	SPY	ETF	78.75	78.75	78.75	78.75	500.0
2009-03-23 04:50:00	SPY	ETF	78.85	78.85	78.85	78.85	100.0
2009-03-23 05:00:00	SPY	ETF	78.98	78.98	78.98	78.98	330.0
2009-03-23 05:10:00	SPY	ETF	79.03	79.03	79.03	79.03	1000.0
2009-03-23 05:15:00	SPY	ETF	78.96	79.0	78.95	79.0	6200.0
2009-03-23 05:20:00	SPY	ETF	79.0	79.02	79.0	79.02	1400.0
2009-03-23 05:30:00	SPY	ETF	78.87	78.87	78.85	78.85	1200.0
2009-03-23 05:35:00	SPY	ETF	78.87	78.87	78.87	78.87	300.0
2009-03-23 05:50:00	SPY	ETF	78.8	78.8	78.8	78.8	100.0
2009-03-23 05:55:00	SPY	ETF	78.83	78.87	78.83	78.87	2800.0
2009-03-23 06:00:00	SPY	ETF	79.0	79.0	78.91	78.91	700.0
2009-03-23 06:05:00	SPY	ETF	78.98	78.98	78.94	78.95	700.0
2009-03-23 06:10:00	SPY	ETF	78.88	78.88	78.88	78.88	150.0
2009-03-23 06:15:00	SPY	ETF	78.85	78.85	78.85	78.85	380.0
2009-03-23 06:20:00	SPY	ETF	78.86	78.86	78.86	78.86	600.0
2009-03-23 06:25:00	SPY	ETF	78.86	79.05	78.86	79.05	3600.0
2009-03-23 06:30:00	SPY	ETF	78.99	78.99	78.99	78.99	5000.0
2009-03-23 06:35:00	SPY	ETF	79.01	79.07	79.01	79.07	1200.0
2009-03-23 06:40:00	SPY	ETF	79.11	79.11	79.0	79.0	154500.0
2009-03-23 06:45:00	SPY	ETF	79.04	79.16	79.04	79.13	10300.0
2009-03-23 06:50:00	SPY	ETF	79.07	79.11	79.05	79.05	29302.0
2009-03-23 06:55:00	SPY	ETF	79.05	79.07	78.99	79.04	66900.0
2009-03-23 07:00:00	SPY	ETF	79.0	79.03	78.95	79.0	229543.0
2009-03-23 07:05:00	SPY	ETF	78.97	78.97	78.83	78.9	71587.0
2009-03-23 07:10:00	SPY	ETF	78.9	78.93	78.85	78.9	234879.0
2009-03-23 07:15:00	SPY	ETF	78.9	78.95	78.88	78.92	52867.0
2009-03-23 07:20:00	SPY	ETF	78.92	78.92	78.86	78.9	190769.0
2009-03-23 07:25:00	SPY	ETF	78.9	79.0	78.9	78.98	74965.0
2009-03-23 07:30:00	SPY	ETF	78.98	79.1	78.94	79.1	45458.0
2009-03-23 07:35:00	SPY	ETF	79.1	79.25	79.05	79.1	295957.0
2009-03-23 07:40:00	SPY	ETF	79.1	79.16	79.1	79.1	58700.0
2009-03-23 07:45:00	SPY	ETF	79.1	79.12	79.07	79.07	158032.0
2009-03-23 07:50:00	SPY	ETF	79.05	79.18	79.05	79.18	93450.0
2009-03-23 07:55:00	SPY	ETF	79.18	79.37	79.15	79.35	507084.0
2009-03-23 08:00:00	SPY	ETF	79.35	79.42	78.76	79.26	1536254.0
2009-03-23 08:05:00	SPY	ETF	79.24	79.24	78.99	78.99	295599.0
2009-03-23 08:10:00	SPY	ETF	79.0	79.3	78.8	78.94	440868.0
2009-03-23 08:15:00	SPY	ETF	78.92	79.04	78.77	78.79	980759.0
2009-03-23 08:20:00	SPY	ETF	78.78	78.84	78.64	78.69	1127159.0
2009-03-23 08:25:00	SPY	ETF	78.69	78.71	78.63	78.68	256967.0
2009-03-23 08:30:00	SPY	ETF	78.69	78.73	78.49	78.53	797729.0
2009-03-23 08:35:00	SPY	ETF	78.54	78.61	78.47	78.53	765389.0
2009-03-23 08:40:00	SPY	ETF	78.54	78.56	77.7276	78.46	1326947.0
2009-03-23 08:45:00	SPY	ETF	78.46	78.49	78.37	78.44	312603.0
2009-03-23 08:50:00	SPY	ETF	78.44	78.5	78.39	78.44	189501.0
2009-03-23 08:55:00	SPY	ETF	78.44	78.51	78.4	78.49	159365.0
2009-03-23 09:00:00	SPY	ETF	78.5	78.73	78.5	78.7	355415.0

> showing 50 of 30,233 rows — these rows as CSV

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