PREVIEW / etf_1hour / 2009-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-07.parquet
  size:    146 KB
  rows:    4,496

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-07 04:00:00	SPY	ETF	110.64	110.9	110.64	110.9	720.0
2009-12-07 05:00:00	SPY	ETF	110.94	111.09	110.88	110.9	21200.0
2009-12-07 06:00:00	SPY	ETF	110.98	111.0	110.85	110.85	30500.0
2009-12-07 07:00:00	SPY	ETF	110.87	111.1	110.8	111.06	766640.0
2009-12-07 08:00:00	SPY	ETF	111.05	111.08	110.75	111.01	1276441.0
2009-12-07 09:00:00	SPY	ETF	111.02	111.53	110.88	111.38	19247365.0
2009-12-07 10:00:00	SPY	ETF	111.39	111.45	111.0	111.23	22795881.0
2009-12-07 11:00:00	SPY	ETF	111.2101	111.24	111.03	111.2	10762247.0
2009-12-07 12:00:00	SPY	ETF	111.19	111.44	111.04	111.33	12116569.0
2009-12-07 13:00:00	SPY	ETF	111.32	111.52	111.17	111.24	11065326.0
2009-12-07 14:00:00	SPY	ETF	111.24	111.28	110.49	110.68	17356827.0
2009-12-07 15:00:00	SPY	ETF	110.67	110.96	110.55	110.77	21425441.0
2009-12-07 16:00:00	SPY	ETF	110.78	111.33	110.6099	111.07	8165257.0
2009-12-07 17:00:00	SPY	ETF	111.05	111.16	111.03	111.15	1787968.0
2009-12-07 18:00:00	SPY	ETF	111.13	111.16	111.06	111.06	90181.0
2009-12-07 19:00:00	SPY	ETF	111.08	111.25	111.06	111.25	117271.0
2009-12-07 04:00:00	QQQ	ETF	43.95	43.95	43.91	43.91	500.0
2009-12-07 05:00:00	QQQ	ETF	44.04	44.08	44.04	44.08	300.0
2009-12-07 06:00:00	QQQ	ETF	44.05	44.06	44.05	44.06	1500.0
2009-12-07 07:00:00	QQQ	ETF	44.0	44.13	44.0	44.12	11443.0
2009-12-07 08:00:00	QQQ	ETF	44.12	44.12	43.99	44.09	265903.0
2009-12-07 09:00:00	QQQ	ETF	44.11	44.29	44.04	44.21	12524877.0
2009-12-07 10:00:00	QQQ	ETF	44.201	44.26	44.1	44.16	11270460.0
2009-12-07 11:00:00	QQQ	ETF	44.17	44.18	44.06	44.11	6919761.0
2009-12-07 12:00:00	QQQ	ETF	44.12	44.18	44.05	44.12	6150650.0
2009-12-07 13:00:00	QQQ	ETF	44.11	44.19	44.0575	44.07	6007958.0
2009-12-07 14:00:00	QQQ	ETF	44.07	44.09	43.82	43.89	9324976.0
2009-12-07 15:00:00	QQQ	ETF	43.88	43.98	43.83	43.91	11982317.0
2009-12-07 16:00:00	QQQ	ETF	43.919	44.05	43.89	44.02	2608561.0
2009-12-07 17:00:00	QQQ	ETF	44.03	44.05	44.02	44.04	146079.0
2009-12-07 18:00:00	QQQ	ETF	44.02	44.04	44.0	44.03	21450.0
2009-12-07 19:00:00	QQQ	ETF	44.03	44.08	44.03	44.07	41258.0
2009-12-07 07:00:00	IWM	ETF	60.14	60.43	60.13	60.43	397918.0
2009-12-07 08:00:00	IWM	ETF	60.41	60.49	60.07	60.4	1082182.0
2009-12-07 09:00:00	IWM	ETF	60.4	60.74	60.33	60.7025	8522431.0
2009-12-07 10:00:00	IWM	ETF	60.7	60.84	60.38	60.6	10427996.0
2009-12-07 11:00:00	IWM	ETF	60.6	60.61	60.45	60.56	3061045.0
2009-12-07 12:00:00	IWM	ETF	60.57	60.74	60.48	60.66	5329792.0
2009-12-07 13:00:00	IWM	ETF	60.6599	60.76	60.56	60.615	3348102.0
2009-12-07 14:00:00	IWM	ETF	60.6	60.63	60.11	60.21	5410394.0
2009-12-07 15:00:00	IWM	ETF	60.21	60.52	60.11	60.5	9487730.0
2009-12-07 16:00:00	IWM	ETF	60.49	60.7	60.4028	60.67	4182218.0
2009-12-07 17:00:00	IWM	ETF	60.67	60.75	60.67	60.75	28692.0
2009-12-07 18:00:00	IWM	ETF	60.77	60.77	60.68	60.68	1700.0
2009-12-07 19:00:00	IWM	ETF	60.7	60.7	60.68	60.7	1000.0
2009-12-07 08:00:00	DIA	ETF	103.83	103.95	103.82	103.92	4501.0
2009-12-07 09:00:00	DIA	ETF	103.96	104.53	103.8	104.3834	1292165.0
2009-12-07 10:00:00	DIA	ETF	104.4	104.5	104.11	104.26	1504188.0
2009-12-07 11:00:00	DIA	ETF	104.27	104.33	104.16	104.31	614062.0
2009-12-07 12:00:00	DIA	ETF	104.3	104.48	104.185	104.37	729757.0

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

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