PREVIEW / etf_1hour / 2009-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-17.parquet
  size:    151 KB
  rows:    4,695

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-12-17 04:00:00	SPY	ETF	111.17	111.17	111.17	111.17	200.0
2009-12-17 05:00:00	SPY	ETF	111.11	111.11	110.89	110.89	25200.0
2009-12-17 06:00:00	SPY	ETF	110.9	110.91	110.66	110.88	13400.0
2009-12-17 07:00:00	SPY	ETF	110.9	110.96	110.54	110.62	539511.0
2009-12-17 08:00:00	SPY	ETF	110.62	110.95	110.52	110.67	2229145.0
2009-12-17 09:00:00	SPY	ETF	110.66	110.93	110.35	110.37	24019090.0
2009-12-17 10:00:00	SPY	ETF	110.36	110.8	110.3	110.77	25645623.0
2009-12-17 11:00:00	SPY	ETF	110.76	110.84	110.33	110.43	21191961.0
2009-12-17 12:00:00	SPY	ETF	110.43	110.49	110.08	110.22	21186408.0
2009-12-17 13:00:00	SPY	ETF	110.23	110.41	110.19	110.37	13066442.0
2009-12-17 14:00:00	SPY	ETF	110.37	110.84	110.349	110.4383	16650206.0
2009-12-17 15:00:00	SPY	ETF	110.43	110.52	110.15	110.16	35658671.0
2009-12-17 16:00:00	SPY	ETF	110.15	110.84	110.08	110.38	21172473.0
2009-12-17 17:00:00	SPY	ETF	110.39	110.81	110.37	110.45	154294.0
2009-12-17 18:00:00	SPY	ETF	110.44	110.45	110.38	110.42	85290.0
2009-12-17 19:00:00	SPY	ETF	110.41	110.44	110.35	110.43	27170.0
2009-12-17 05:00:00	QQQ	ETF	44.18	44.18	44.1	44.1	4970.0
2009-12-17 06:00:00	QQQ	ETF	44.05	44.09	43.98	44.09	35405.0
2009-12-17 07:00:00	QQQ	ETF	44.1	44.16	44.02	44.04	84899.0
2009-12-17 08:00:00	QQQ	ETF	44.05	44.16	44.03	44.1	1104467.0
2009-12-17 09:00:00	QQQ	ETF	44.1	44.21	43.8995	43.91	13004333.0
2009-12-17 10:00:00	QQQ	ETF	43.9	44.02	43.78	44.01	15461289.0
2009-12-17 11:00:00	QQQ	ETF	44.01	44.08	43.88	43.91	9942425.0
2009-12-17 12:00:00	QQQ	ETF	43.92	43.93	43.76	43.8299	6223597.0
2009-12-17 13:00:00	QQQ	ETF	43.82	43.9	43.81	43.89	5345658.0
2009-12-17 14:00:00	QQQ	ETF	43.9	43.99	43.87	43.94	5665447.0
2009-12-17 15:00:00	QQQ	ETF	43.93	44.0	43.83	43.83	14585495.0
2009-12-17 16:00:00	QQQ	ETF	43.83	44.3532	43.78	44.01	12202941.0
2009-12-17 17:00:00	QQQ	ETF	44.03	44.06	44.02	44.05	152783.0
2009-12-17 18:00:00	QQQ	ETF	44.04	44.04	44.01	44.02	219000.0
2009-12-17 19:00:00	QQQ	ETF	44.02	44.04	44.0	44.02	62113.0
2009-12-17 06:00:00	IWM	ETF	60.81	60.81	60.81	60.81	100.0
2009-12-17 07:00:00	IWM	ETF	60.99	60.99	60.76	60.77	23900.0
2009-12-17 08:00:00	IWM	ETF	60.81	60.97	60.76	60.83	409008.0
2009-12-17 09:00:00	IWM	ETF	60.83	61.17	60.42	60.44	10470765.0
2009-12-17 10:00:00	IWM	ETF	60.45	60.79	60.35	60.76	10819106.0
2009-12-17 11:00:00	IWM	ETF	60.76	60.83	60.47	60.51	7635194.0
2009-12-17 12:00:00	IWM	ETF	60.5	60.54	60.18	60.315	5067237.0
2009-12-17 13:00:00	IWM	ETF	60.33	60.6	60.3	60.56	5567804.0
2009-12-17 14:00:00	IWM	ETF	60.56	60.67	60.49	60.645	3938466.0
2009-12-17 15:00:00	IWM	ETF	60.64	60.81	60.45	60.62	9900054.0
2009-12-17 16:00:00	IWM	ETF	60.62	61.2853	60.5259	60.89	5540068.0
2009-12-17 17:00:00	IWM	ETF	60.9	60.97	60.88	60.93	46510.0
2009-12-17 18:00:00	IWM	ETF	61.3	61.3	60.84	60.9	4300.0
2009-12-17 19:00:00	IWM	ETF	60.9	60.9	60.84	60.84	2600.0
2009-12-17 05:00:00	DIA	ETF	104.31	104.31	104.31	104.31	200.0
2009-12-17 07:00:00	DIA	ETF	104.2	104.2	104.03	104.1	5700.0
2009-12-17 08:00:00	DIA	ETF	104.13	104.2	103.96	104.03	30095.0
2009-12-17 09:00:00	DIA	ETF	103.98	104.15	103.73	103.76	1403951.0
2009-12-17 10:00:00	DIA	ETF	103.76	103.95	103.59	103.83	1236082.0

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

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