PREVIEW / etf_1min / 2009-06-24

all etf 1-min files

  file:    by_date/etf_1min/2009/2009-06-24.parquet
  size:    1.6 MB
  rows:    87,478

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-06-24 04:18:00	SPY	ETF	89.62	89.62	89.62	89.62	150.0
2009-06-24 04:19:00	SPY	ETF	89.62	89.62	89.62	89.62	800.0
2009-06-24 04:24:00	SPY	ETF	89.68	89.68	89.68	89.68	100.0
2009-06-24 04:44:00	SPY	ETF	89.74	89.74	89.74	89.74	400.0
2009-06-24 04:47:00	SPY	ETF	89.7	89.7	89.7	89.7	20000.0
2009-06-24 04:54:00	SPY	ETF	89.62	89.62	89.62	89.62	100.0
2009-06-24 04:57:00	SPY	ETF	89.62	89.62	89.62	89.62	100.0
2009-06-24 05:13:00	SPY	ETF	89.78	89.78	89.78	89.78	200.0
2009-06-24 05:14:00	SPY	ETF	89.85	89.85	89.85	89.85	200.0
2009-06-24 05:20:00	SPY	ETF	89.87	89.87	89.87	89.87	100.0
2009-06-24 05:23:00	SPY	ETF	89.75	89.75	89.75	89.75	20000.0
2009-06-24 05:53:00	SPY	ETF	89.94	89.94	89.94	89.94	800.0
2009-06-24 06:06:00	SPY	ETF	89.83	89.83	89.83	89.83	100.0
2009-06-24 06:14:00	SPY	ETF	89.81	89.81	89.81	89.81	100.0
2009-06-24 06:15:00	SPY	ETF	89.84	89.84	89.84	89.84	100.0
2009-06-24 06:20:00	SPY	ETF	89.82	89.82	89.82	89.82	200.0
2009-06-24 06:23:00	SPY	ETF	89.87	89.9	89.87	89.9	500.0
2009-06-24 06:36:00	SPY	ETF	89.87	89.87	89.87	89.87	2200.0
2009-06-24 06:44:00	SPY	ETF	89.8	89.82	89.78	89.82	8800.0
2009-06-24 06:45:00	SPY	ETF	89.81	89.81	89.81	89.81	1000.0
2009-06-24 06:47:00	SPY	ETF	89.78	89.78	89.77	89.77	1625.0
2009-06-24 06:50:00	SPY	ETF	89.74	89.75	89.74	89.75	5200.0
2009-06-24 06:51:00	SPY	ETF	89.76	89.76	89.76	89.76	2000.0
2009-06-24 06:52:00	SPY	ETF	89.79	89.79	89.79	89.79	1000.0
2009-06-24 06:53:00	SPY	ETF	89.79	89.79	89.79	89.79	1000.0
2009-06-24 06:56:00	SPY	ETF	89.81	89.81	89.8	89.8	1100.0
2009-06-24 06:59:00	SPY	ETF	89.84	89.84	89.84	89.84	500.0
2009-06-24 07:00:00	SPY	ETF	89.84	89.85	89.84	89.85	800.0
2009-06-24 07:01:00	SPY	ETF	89.85	89.85	89.84	89.84	10500.0
2009-06-24 07:02:00	SPY	ETF	89.85	89.86	89.85	89.85	3300.0
2009-06-24 07:06:00	SPY	ETF	89.86	89.86	89.85	89.85	2600.0
2009-06-24 07:08:00	SPY	ETF	89.86	89.86	89.86	89.86	1000.0
2009-06-24 07:09:00	SPY	ETF	89.86	89.86	89.86	89.86	3500.0
2009-06-24 07:10:00	SPY	ETF	89.86	89.86	89.82	89.82	10700.0
2009-06-24 07:11:00	SPY	ETF	89.82	89.82	89.8	89.8	3400.0
2009-06-24 07:12:00	SPY	ETF	89.84	89.9	89.84	89.87	15698.0
2009-06-24 07:14:00	SPY	ETF	89.89	89.89	89.89	89.89	2500.0
2009-06-24 07:15:00	SPY	ETF	89.88	89.88	89.88	89.88	100.0
2009-06-24 07:16:00	SPY	ETF	89.87	89.87	89.87	89.87	500.0
2009-06-24 07:17:00	SPY	ETF	89.86	89.87	89.86	89.87	1700.0
2009-06-24 07:18:00	SPY	ETF	89.87	89.87	89.87	89.87	100.0
2009-06-24 07:19:00	SPY	ETF	89.87	89.87	89.87	89.87	1480.0
2009-06-24 07:20:00	SPY	ETF	89.87	89.87	89.87	89.87	26300.0
2009-06-24 07:21:00	SPY	ETF	89.88	89.88	89.87	89.87	558.0
2009-06-24 07:22:00	SPY	ETF	89.87	89.93	89.87	89.93	1400.0
2009-06-24 07:23:00	SPY	ETF	89.93	90.07	89.92	90.04	23708.0
2009-06-24 07:24:00	SPY	ETF	90.04	90.08	90.04	90.07	32900.0
2009-06-24 07:25:00	SPY	ETF	90.07	90.09	90.05	90.05	77256.0
2009-06-24 07:26:00	SPY	ETF	90.05	90.05	90.05	90.05	2600.0
2009-06-24 07:27:00	SPY	ETF	90.05	90.05	90.01	90.01	25800.0

> showing 50 of 87,478 rows — these rows as CSV

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