PREVIEW / etf_1hour / 2008-10-03

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-03.parquet
  size:    114 KB
  rows:    3,667

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-10-03 04:00:00	SPY	ETF	112.55	112.66	112.5	112.5	400.0
2008-10-03 05:00:00	SPY	ETF	112.25	112.59	112.25	112.51	1000.0
2008-10-03 06:00:00	SPY	ETF	112.74	112.74	112.37	112.49	24000.0
2008-10-03 07:00:00	SPY	ETF	112.6	113.16	111.9	112.15	1360883.0
2008-10-03 08:00:00	SPY	ETF	112.13	113.12	111.29	112.76	10860033.0
2008-10-03 09:00:00	SPY	ETF	112.75	113.74	112.54	113.58	30497789.0
2008-10-03 10:00:00	SPY	ETF	113.58	114.57	112.86	114.46	56178590.0
2008-10-03 11:00:00	SPY	ETF	114.45	114.96	113.79	114.12	38248648.0
2008-10-03 12:00:00	SPY	ETF	114.11	114.81	111.3558	114.8	31773348.0
2008-10-03 13:00:00	SPY	ETF	114.79	115.45	111.84	112.74	106876583.0
2008-10-03 14:00:00	SPY	ETF	112.74	113.3	110.57	112.2	84628047.0
2008-10-03 15:00:00	SPY	ETF	112.2	112.7	109.68	109.97	72859551.0
2008-10-03 16:00:00	SPY	ETF	109.98	114.56	109.92	110.27	25605672.0
2008-10-03 17:00:00	SPY	ETF	110.28	110.6	110.15	110.34	511812.0
2008-10-03 18:00:00	SPY	ETF	110.32	110.36	110.2	110.27	38950.0
2008-10-03 19:00:00	SPY	ETF	110.27	110.44	110.25	110.3	12003.0
2008-10-03 04:00:00	QQQ	ETF	37.18	37.18	37.18	37.18	1000.0
2008-10-03 05:00:00	QQQ	ETF	37.1	37.1	37.1	37.1	100.0
2008-10-03 06:00:00	QQQ	ETF	37.18	37.19	37.09	37.11	3300.0
2008-10-03 07:00:00	QQQ	ETF	37.19	37.3	37.07	37.07	259144.0
2008-10-03 08:00:00	QQQ	ETF	37.07	37.39	36.76	37.26	2970719.0
2008-10-03 09:00:00	QQQ	ETF	37.25	37.67	37.03	37.39	32892726.0
2008-10-03 10:00:00	QQQ	ETF	37.39	37.89	37.25	37.8	26539893.0
2008-10-03 11:00:00	QQQ	ETF	37.8	37.97	37.68	37.79	17178231.0
2008-10-03 12:00:00	QQQ	ETF	37.78	37.96	37.51	37.938	16242565.0
2008-10-03 13:00:00	QQQ	ETF	37.94	38.18	36.58	37.16	69686203.0
2008-10-03 14:00:00	QQQ	ETF	37.17	37.54	36.31	37.0912	45606650.0
2008-10-03 15:00:00	QQQ	ETF	37.0999	37.16	36.1	36.17	48038732.0
2008-10-03 16:00:00	QQQ	ETF	36.17	36.4741	36.05	36.15	3852000.0
2008-10-03 17:00:00	QQQ	ETF	36.12	36.2	36.07	36.18	77652.0
2008-10-03 18:00:00	QQQ	ETF	36.18	36.22	36.14	36.19	15655.0
2008-10-03 19:00:00	QQQ	ETF	36.18	36.2	36.14	36.15	16385.0
2008-10-03 07:00:00	IWM	ETF	64.44	64.44	63.89	63.97	58300.0
2008-10-03 08:00:00	IWM	ETF	64.6	64.61	63.67	64.49	870379.0
2008-10-03 09:00:00	IWM	ETF	64.48	65.13	64.22	64.84	8728187.0
2008-10-03 10:00:00	IWM	ETF	64.85	65.35	64.6	65.33	11487141.0
2008-10-03 11:00:00	IWM	ETF	65.32	65.64	64.64	64.71	9359755.0
2008-10-03 12:00:00	IWM	ETF	64.71	65.08	64.56	65.03	7120221.0
2008-10-03 13:00:00	IWM	ETF	65.03	65.55	63.15	63.66	27231252.0
2008-10-03 14:00:00	IWM	ETF	63.66	63.94	62.55	63.34	22116107.0
2008-10-03 15:00:00	IWM	ETF	63.34	63.51	61.73	62.02	24992711.0
2008-10-03 16:00:00	IWM	ETF	62.03	63.76	61.67	62.3	3965720.0
2008-10-03 17:00:00	IWM	ETF	62.3	62.3	62.02	62.25	1029110.0
2008-10-03 18:00:00	IWM	ETF	62.19	62.29	62.19	62.29	1400.0
2008-10-03 19:00:00	IWM	ETF	61.79	62.25	61.79	62.25	200.0
2008-10-03 07:00:00	DIA	ETF	105.7	105.75	105.25	105.5	5250.0
2008-10-03 08:00:00	DIA	ETF	105.6	105.89	104.58	105.7	155860.0
2008-10-03 09:00:00	DIA	ETF	105.57	106.28	105.53	106.18	1512031.0
2008-10-03 10:00:00	DIA	ETF	106.21	107.05	105.6	106.97	2928610.0
2008-10-03 11:00:00	DIA	ETF	106.99	107.41	106.47	106.79	2501537.0

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

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