PREVIEW / etf_1min / 2009-08-05

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-08-05.parquet
  size:    1.7 MB
  rows:    93,997

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-08-05 04:15:00	SPY	ETF	100.59	100.59	100.59	100.59	550.0
2009-08-05 04:17:00	SPY	ETF	100.66	100.66	100.64	100.64	500.0
2009-08-05 04:18:00	SPY	ETF	100.59	100.59	100.59	100.59	1000.0
2009-08-05 04:21:00	SPY	ETF	100.56	100.56	100.56	100.56	250.0
2009-08-05 04:26:00	SPY	ETF	100.52	100.52	100.51	100.51	450.0
2009-08-05 04:27:00	SPY	ETF	100.51	100.51	100.51	100.51	100.0
2009-08-05 04:30:00	SPY	ETF	100.62	100.62	100.62	100.62	100.0
2009-08-05 04:36:00	SPY	ETF	100.6	100.6	100.6	100.6	100.0
2009-08-05 05:05:00	SPY	ETF	100.63	100.63	100.63	100.63	2000.0
2009-08-05 05:10:00	SPY	ETF	100.72	100.72	100.72	100.72	100.0
2009-08-05 05:16:00	SPY	ETF	100.78	100.78	100.78	100.78	2000.0
2009-08-05 05:28:00	SPY	ETF	100.79	100.79	100.79	100.79	100.0
2009-08-05 05:33:00	SPY	ETF	100.8	100.8	100.8	100.8	1000.0
2009-08-05 05:34:00	SPY	ETF	100.82	100.82	100.82	100.82	100.0
2009-08-05 05:35:00	SPY	ETF	100.81	100.81	100.81	100.81	100.0
2009-08-05 05:39:00	SPY	ETF	100.86	100.86	100.86	100.86	236.0
2009-08-05 06:12:00	SPY	ETF	100.87	100.87	100.87	100.87	300.0
2009-08-05 06:16:00	SPY	ETF	100.92	100.92	100.92	100.92	500.0
2009-08-05 06:22:00	SPY	ETF	100.85	100.85	100.85	100.85	1500.0
2009-08-05 06:35:00	SPY	ETF	100.9	100.9	100.9	100.9	100.0
2009-08-05 06:48:00	SPY	ETF	100.93	100.93	100.93	100.93	226.0
2009-08-05 06:51:00	SPY	ETF	100.99	100.99	100.99	100.99	2000.0
2009-08-05 06:56:00	SPY	ETF	100.95	100.95	100.95	100.95	200.0
2009-08-05 06:59:00	SPY	ETF	101.0	101.0	101.0	101.0	1000.0
2009-08-05 07:00:00	SPY	ETF	100.98	100.98	100.92	100.92	25500.0
2009-08-05 07:01:00	SPY	ETF	100.93	100.93	100.93	100.93	4000.0
2009-08-05 07:02:00	SPY	ETF	100.93	100.93	100.93	100.93	100.0
2009-08-05 07:03:00	SPY	ETF	100.92	100.92	100.92	100.92	226.0
2009-08-05 07:05:00	SPY	ETF	100.87	100.87	100.86	100.86	610.0
2009-08-05 07:06:00	SPY	ETF	100.83	100.83	100.8	100.82	2350.0
2009-08-05 07:07:00	SPY	ETF	100.78	100.78	100.78	100.78	600.0
2009-08-05 07:09:00	SPY	ETF	100.86	100.86	100.86	100.86	100.0
2009-08-05 07:10:00	SPY	ETF	100.85	100.85	100.85	100.85	3500.0
2009-08-05 07:15:00	SPY	ETF	100.8	100.8	100.8	100.8	200.0
2009-08-05 07:16:00	SPY	ETF	100.8	100.8	100.8	100.8	200.0
2009-08-05 07:17:00	SPY	ETF	100.8	100.8	100.8	100.8	500.0
2009-08-05 07:18:00	SPY	ETF	100.81	100.83	100.81	100.82	50000.0
2009-08-05 07:21:00	SPY	ETF	100.78	100.78	100.78	100.78	300.0
2009-08-05 07:22:00	SPY	ETF	100.84	100.84	100.83	100.83	1700.0
2009-08-05 07:25:00	SPY	ETF	100.86	100.87	100.86	100.87	600.0
2009-08-05 07:26:00	SPY	ETF	100.87	100.87	100.87	100.87	100.0
2009-08-05 07:27:00	SPY	ETF	100.92	100.93	100.92	100.93	631.0
2009-08-05 07:28:00	SPY	ETF	100.93	100.93	100.93	100.93	500.0
2009-08-05 07:29:00	SPY	ETF	100.93	100.93	100.93	100.93	700.0
2009-08-05 07:30:00	SPY	ETF	100.96	101.0	100.96	100.98	7055.0
2009-08-05 07:31:00	SPY	ETF	101.0	101.0	101.0	101.0	200.0
2009-08-05 07:32:00	SPY	ETF	101.02	101.07	101.02	101.05	7810.0
2009-08-05 07:33:00	SPY	ETF	101.01	101.03	101.01	101.01	14234.0
2009-08-05 07:34:00	SPY	ETF	101.04	101.04	101.03	101.03	1600.0
2009-08-05 07:35:00	SPY	ETF	101.03	101.03	101.03	101.03	200.0

> showing 50 of 93,997 rows — these rows as CSV

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