PREVIEW / etf_1hour / 2007-12-05

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-05.parquet
  size:    94 KB
  rows:    3,138

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
2007-12-05 04:00:00	SPY	ETF	147.26	147.26	147.26	147.26	800.0
2007-12-05 05:00:00	SPY	ETF	147.36	147.4	147.36	147.4	5500.0
2007-12-05 06:00:00	SPY	ETF	147.4	147.42	147.24	147.41	63800.0
2007-12-05 07:00:00	SPY	ETF	147.35	147.57	147.27	147.45	378000.0
2007-12-05 08:00:00	SPY	ETF	147.45	148.19	147.27	148.12	7892100.0
2007-12-05 09:00:00	SPY	ETF	148.11	148.21	146.76	148.08	15510463.0
2007-12-05 10:00:00	SPY	ETF	148.08	148.44	147.88	148.3499	20301675.0
2007-12-05 11:00:00	SPY	ETF	148.36	149.2	148.26	148.88	18987966.0
2007-12-05 12:00:00	SPY	ETF	148.88	149.0	148.29	148.48	22577174.0
2007-12-05 13:00:00	SPY	ETF	148.47	148.78	148.09	148.65	24293058.0
2007-12-05 14:00:00	SPY	ETF	148.66	148.81	147.86	148.1	23810201.0
2007-12-05 15:00:00	SPY	ETF	148.09	148.97	148.02	148.86	26866153.0
2007-12-05 16:00:00	SPY	ETF	148.79	149.07	147.96	149.07	3824100.0
2007-12-05 17:00:00	SPY	ETF	149.07	149.45	148.48	149.25	218400.0
2007-12-05 18:00:00	SPY	ETF	149.32	149.65	149.31	149.5	264400.0
2007-12-05 19:00:00	SPY	ETF	149.51	149.61	149.48	149.61	38800.0
2007-12-05 04:00:00	QQQ	ETF	50.9	50.9	50.9	50.9	200.0
2007-12-05 05:00:00	QQQ	ETF	50.91	50.91	50.91	50.91	10000.0
2007-12-05 07:00:00	QQQ	ETF	50.95	51.02	50.94	50.98	115073.0
2007-12-05 08:00:00	QQQ	ETF	50.97	51.35	50.674	51.33	4802404.0
2007-12-05 09:00:00	QQQ	ETF	51.33	51.36	51.16	51.3	17740513.0
2007-12-05 10:00:00	QQQ	ETF	51.308	51.63	51.27	51.62	16982256.0
2007-12-05 11:00:00	QQQ	ETF	51.62	51.7501	51.52	51.72	15130789.0
2007-12-05 12:00:00	QQQ	ETF	51.72	51.77	51.54	51.59	13678720.0
2007-12-05 13:00:00	QQQ	ETF	51.58	52.0	51.49	51.68	17461490.0
2007-12-05 14:00:00	QQQ	ETF	51.68	51.75	51.32	51.41	26488840.0
2007-12-05 15:00:00	QQQ	ETF	51.41	51.68	51.3699	51.63	19031336.0
2007-12-05 16:00:00	QQQ	ETF	51.63	51.76	51.55	51.74	5531057.0
2007-12-05 17:00:00	QQQ	ETF	51.75	51.95	51.74	51.89	436758.0
2007-12-05 18:00:00	QQQ	ETF	51.9	51.96	51.86	51.88	177524.0
2007-12-05 19:00:00	QQQ	ETF	51.89	51.93	51.86	51.88	38931.0
2007-12-05 05:00:00	IWM	ETF	75.64	75.64	75.64	75.64	5000.0
2007-12-05 06:00:00	IWM	ETF	75.54	75.63	75.54	75.63	5100.0
2007-12-05 07:00:00	IWM	ETF	75.65	75.71	75.56	75.65	31000.0
2007-12-05 08:00:00	IWM	ETF	75.65	76.16	75.01	76.16	2724800.0
2007-12-05 09:00:00	IWM	ETF	76.17	76.28	75.86	75.95	8462301.0
2007-12-05 10:00:00	IWM	ETF	75.96	76.16	75.78	76.09	11143169.0
2007-12-05 11:00:00	IWM	ETF	76.09	76.56	76.04	76.52	7947000.0
2007-12-05 12:00:00	IWM	ETF	76.53	76.62	76.09	76.22	6085756.0
2007-12-05 13:00:00	IWM	ETF	76.22	76.29	75.98	76.23	8223625.0
2007-12-05 14:00:00	IWM	ETF	76.23	76.26	75.52	75.67	9873304.0
2007-12-05 15:00:00	IWM	ETF	75.67	76.44	75.62	76.43	11043682.0
2007-12-05 16:00:00	IWM	ETF	76.43	76.56	75.7	76.56	4617100.0
2007-12-05 17:00:00	IWM	ETF	76.6	76.77	76.6	76.75	18900.0
2007-12-05 18:00:00	IWM	ETF	76.71	76.92	76.71	76.92	38300.0
2007-12-05 19:00:00	IWM	ETF	76.86	76.87	76.86	76.86	2600.0
2007-12-05 07:00:00	DIA	ETF	133.19	133.3	133.19	133.28	2800.0
2007-12-05 08:00:00	DIA	ETF	133.29	133.87	133.17	133.86	90600.0
2007-12-05 09:00:00	DIA	ETF	133.84	133.91	133.54	133.8	1486113.0
2007-12-05 10:00:00	DIA	ETF	133.8	134.04	133.63	133.99	1600615.0

> showing 50 of 3,138 rows — these rows as CSV

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