PREVIEW / etf_1hour / 2010-01-12

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-12.parquet
  size:    154 KB
  rows:    4,783

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
2010-01-12 04:00:00	SPY	ETF	114.27	114.3	114.1	114.15	5630.0
2010-01-12 05:00:00	SPY	ETF	114.3	114.3	114.3	114.3	600.0
2010-01-12 06:00:00	SPY	ETF	114.32	114.32	113.77	113.93	83636.0
2010-01-12 07:00:00	SPY	ETF	113.91	114.05	113.87	113.98	345533.0
2010-01-12 08:00:00	SPY	ETF	113.98	114.02	113.73	113.89	3882427.0
2010-01-12 09:00:00	SPY	ETF	113.88	114.73	113.71	114.14	25431784.0
2010-01-12 10:00:00	SPY	ETF	114.1383	114.21	113.93	114.13	22064954.0
2010-01-12 11:00:00	SPY	ETF	114.12	114.17	113.87	113.895	15335458.0
2010-01-12 12:00:00	SPY	ETF	113.89	113.9	113.29	113.335	24029044.0
2010-01-12 13:00:00	SPY	ETF	113.36	113.54	113.22	113.5275	15497683.0
2010-01-12 14:00:00	SPY	ETF	113.52	113.68	113.33	113.63	13881123.0
2010-01-12 15:00:00	SPY	ETF	113.625	113.69	113.29	113.66	25054851.0
2010-01-12 16:00:00	SPY	ETF	113.66	114.7557	113.42	113.86	11795115.0
2010-01-12 17:00:00	SPY	ETF	113.86	113.87	113.81	113.84	87137.0
2010-01-12 18:00:00	SPY	ETF	113.83	113.84	113.79	113.84	87600.0
2010-01-12 19:00:00	SPY	ETF	113.85	114.08	113.83	113.96	249740.0
2010-01-12 04:00:00	QQQ	ETF	46.19	46.19	46.06	46.06	7233.0
2010-01-12 05:00:00	QQQ	ETF	46.18	46.19	46.17	46.17	5422.0
2010-01-12 06:00:00	QQQ	ETF	46.18	46.18	45.99	46.03	34173.0
2010-01-12 07:00:00	QQQ	ETF	46.03	46.07	46.0	46.07	346228.0
2010-01-12 08:00:00	QQQ	ETF	45.99	46.09	45.99	46.07	679077.0
2010-01-12 09:00:00	QQQ	ETF	46.07	46.14	45.82	45.96	14449659.0
2010-01-12 10:00:00	QQQ	ETF	45.96	46.07	45.92	46.01	12909102.0
2010-01-12 11:00:00	QQQ	ETF	46.01	46.02	45.87	45.92	9926631.0
2010-01-12 12:00:00	QQQ	ETF	45.91	45.93	45.54	45.59	15097939.0
2010-01-12 13:00:00	QQQ	ETF	45.6	45.69	45.53	45.678	8397411.0
2010-01-12 14:00:00	QQQ	ETF	45.6704	45.77	45.6	45.745	6305335.0
2010-01-12 15:00:00	QQQ	ETF	45.76	45.78	45.62	45.78	10536547.0
2010-01-12 16:00:00	QQQ	ETF	45.78	46.3761	45.6099	45.9	8853599.0
2010-01-12 17:00:00	QQQ	ETF	45.9	45.94	45.89	45.91	151026.0
2010-01-12 18:00:00	QQQ	ETF	45.92	45.92	45.87	45.88	380037.0
2010-01-12 19:00:00	QQQ	ETF	45.89	45.97	45.88	45.95	100110.0
2010-01-12 07:00:00	IWM	ETF	63.7	63.77	63.67	63.74	51300.0
2010-01-12 08:00:00	IWM	ETF	63.74	63.95	63.65	63.73	490689.0
2010-01-12 09:00:00	IWM	ETF	63.72	64.05	63.68	64.01	6572584.0
2010-01-12 10:00:00	IWM	ETF	64.01	64.16	63.92	64.0025	8554519.0
2010-01-12 11:00:00	IWM	ETF	64.0	64.03	63.845	63.86	3428883.0
2010-01-12 12:00:00	IWM	ETF	63.86	63.865	63.32	63.4199	6681611.0
2010-01-12 13:00:00	IWM	ETF	63.41	63.57	63.26	63.54	4629014.0
2010-01-12 14:00:00	IWM	ETF	63.54	63.65	63.34	63.61	4314855.0
2010-01-12 15:00:00	IWM	ETF	63.61	63.61	63.29	63.53	7049269.0
2010-01-12 16:00:00	IWM	ETF	63.53	64.3644	63.4472	63.74	2495826.0
2010-01-12 17:00:00	IWM	ETF	63.75	63.75	63.69	63.69	6263.0
2010-01-12 18:00:00	IWM	ETF	63.71	63.71	63.6	63.6	1819.0
2010-01-12 19:00:00	IWM	ETF	63.62	63.72	63.62	63.72	650.0
2010-01-12 07:00:00	DIA	ETF	105.88	105.98	105.86	105.98	4600.0
2010-01-12 08:00:00	DIA	ETF	105.93	105.94	105.71	105.88	21750.0
2010-01-12 09:00:00	DIA	ETF	105.81	106.31	105.79	106.31	1635721.0
2010-01-12 10:00:00	DIA	ETF	106.31	106.42	106.17	106.295	1408349.0
2010-01-12 11:00:00	DIA	ETF	106.288	106.33	106.081	106.1464	596428.0

> showing 50 of 4,783 rows — these rows as CSV

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