PREVIEW / etf_1hour / 2008-04-10

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-10.parquet
  size:    99 KB
  rows:    3,323

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
2008-04-10 05:00:00	SPY	ETF	135.16	135.25	135.1	135.25	800.0
2008-04-10 06:00:00	SPY	ETF	135.23	135.37	135.04	135.31	80900.0
2008-04-10 07:00:00	SPY	ETF	135.3	135.38	135.01	135.13	906800.0
2008-04-10 08:00:00	SPY	ETF	135.16	135.81	134.98	135.41	4326800.0
2008-04-10 09:00:00	SPY	ETF	135.4	135.67	134.97	135.09	17937945.0
2008-04-10 10:00:00	SPY	ETF	135.09	136.22	134.9	136.19	35081886.0
2008-04-10 11:00:00	SPY	ETF	136.19	136.61	135.92	136.54	30952974.0
2008-04-10 12:00:00	SPY	ETF	136.55	136.67	136.09	136.14	18444873.0
2008-04-10 13:00:00	SPY	ETF	136.14	136.64	136.12	136.27	13802547.0
2008-04-10 14:00:00	SPY	ETF	136.27	136.5	135.84	136.41	21317507.0
2008-04-10 15:00:00	SPY	ETF	136.41	136.53	135.55	135.94	32312106.0
2008-04-10 16:00:00	SPY	ETF	135.87	136.42	135.37	136.16	11410538.0
2008-04-10 17:00:00	SPY	ETF	136.16	137.371	135.371	136.25	3312400.0
2008-04-10 18:00:00	SPY	ETF	136.24	136.24	136.13	136.15	244100.0
2008-04-10 19:00:00	SPY	ETF	136.14	136.36	136.13	136.36	129800.0
2008-04-10 05:00:00	QQQ	ETF	44.84	44.84	44.8	44.83	2457.0
2008-04-10 06:00:00	QQQ	ETF	44.8	44.91	44.77	44.91	4420.0
2008-04-10 07:00:00	QQQ	ETF	44.88	44.97	44.77	44.9	357812.0
2008-04-10 08:00:00	QQQ	ETF	44.91	44.95	44.69	44.92	3260397.0
2008-04-10 09:00:00	QQQ	ETF	44.92	45.22	44.89	45.02	16962296.0
2008-04-10 10:00:00	QQQ	ETF	45.01	45.67	44.94	45.64	26735696.0
2008-04-10 11:00:00	QQQ	ETF	45.64	45.77	45.54	45.701	15188574.0
2008-04-10 12:00:00	QQQ	ETF	45.71	45.74	45.58	45.62	6423254.0
2008-04-10 13:00:00	QQQ	ETF	45.63	45.84	45.6	45.65	10094126.0
2008-04-10 14:00:00	QQQ	ETF	45.65	45.76	45.5	45.73	12755449.0
2008-04-10 15:00:00	QQQ	ETF	45.74	45.78	45.41	45.55	16539678.0
2008-04-10 16:00:00	QQQ	ETF	45.55	45.6	45.164	45.59	3419579.0
2008-04-10 17:00:00	QQQ	ETF	45.59	45.66	45.58	45.66	107198.0
2008-04-10 18:00:00	QQQ	ETF	45.63	45.63	45.61	45.62	11398.0
2008-04-10 19:00:00	QQQ	ETF	45.65	45.67	45.65	45.67	21239.0
2008-04-10 04:00:00	IWM	ETF	69.75	69.75	69.75	69.75	100.0
2008-04-10 07:00:00	IWM	ETF	69.59	69.61	69.36	69.39	446000.0
2008-04-10 08:00:00	IWM	ETF	69.39	69.6	69.33	69.55	470300.0
2008-04-10 09:00:00	IWM	ETF	69.54	70.04	69.46	69.48	5402030.0
2008-04-10 10:00:00	IWM	ETF	69.48	70.51	69.43	70.51	13095890.0
2008-04-10 11:00:00	IWM	ETF	70.51	70.75	70.38	70.63	9347481.0
2008-04-10 12:00:00	IWM	ETF	70.63	70.66	70.42	70.43	3837833.0
2008-04-10 13:00:00	IWM	ETF	70.44	70.89	70.43	70.71	4076601.0
2008-04-10 14:00:00	IWM	ETF	70.71	70.75	70.39	70.7	6727685.0
2008-04-10 15:00:00	IWM	ETF	70.7	70.73	70.15	70.48	10509953.0
2008-04-10 16:00:00	IWM	ETF	70.48	70.58	70.4	70.57	883200.0
2008-04-10 17:00:00	IWM	ETF	70.57	70.6	70.55	70.6	10900.0
2008-04-10 18:00:00	IWM	ETF	70.6	70.65	70.59	70.65	5900.0
2008-04-10 07:00:00	DIA	ETF	125.21	125.33	125.15	125.27	32200.0
2008-04-10 08:00:00	DIA	ETF	125.25	125.49	125.11	125.49	59200.0
2008-04-10 09:00:00	DIA	ETF	125.5	125.73	125.05	125.13	1819400.0
2008-04-10 10:00:00	DIA	ETF	125.11	126.09	124.99	126.04	3536402.0
2008-04-10 11:00:00	DIA	ETF	126.05	126.43	125.9	126.37	2214988.0
2008-04-10 12:00:00	DIA	ETF	126.36	126.47	126.01	126.03	1312567.0
2008-04-10 13:00:00	DIA	ETF	126.03	126.47	125.99	126.18	1231300.0

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

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