PREVIEW / etf_1hour / 2008-10-01

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-01.parquet
  size:    113 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-01 04:00:00	SPY	ETF	115.05	115.34	115.05	115.34	1800.0
2008-10-01 05:00:00	SPY	ETF	115.46	115.46	114.96	114.96	52200.0
2008-10-01 06:00:00	SPY	ETF	114.88	115.7	114.87	115.7	36100.0
2008-10-01 07:00:00	SPY	ETF	115.56	116.0	115.35	115.35	916031.0
2008-10-01 08:00:00	SPY	ETF	115.36	115.8	115.0	115.4	3954004.0
2008-10-01 09:00:00	SPY	ETF	115.41	115.47	114.51	115.27	29870084.0
2008-10-01 10:00:00	SPY	ETF	115.26	115.28	114.01	114.35	43934989.0
2008-10-01 11:00:00	SPY	ETF	114.34	116.5379	113.95	114.93	31730601.0
2008-10-01 12:00:00	SPY	ETF	114.93	116.64	114.72	116.21	53268393.0
2008-10-01 13:00:00	SPY	ETF	116.21	116.38	114.74	115.59	67097794.0
2008-10-01 14:00:00	SPY	ETF	115.58	116.69	115.16	116.0	47337834.0
2008-10-01 15:00:00	SPY	ETF	116.01	116.38	115.59	115.99	37491622.0
2008-10-01 16:00:00	SPY	ETF	115.98	116.56	115.83	116.18	15762703.0
2008-10-01 17:00:00	SPY	ETF	116.19	116.4	116.19	116.38	127542.0
2008-10-01 18:00:00	SPY	ETF	116.38	116.75	116.32	116.58	265903.0
2008-10-01 19:00:00	SPY	ETF	116.6	116.77	116.42	116.42	47605.0
2008-10-01 04:00:00	QQQ	ETF	38.85	38.85	38.85	38.85	100.0
2008-10-01 06:00:00	QQQ	ETF	38.83	38.98	38.68	38.98	3000.0
2008-10-01 07:00:00	QQQ	ETF	38.98	39.09	38.93	38.93	345752.0
2008-10-01 08:00:00	QQQ	ETF	39.02	39.02	38.66	38.78	2503973.0
2008-10-01 09:00:00	QQQ	ETF	38.79	38.97	38.62	38.88	18702094.0
2008-10-01 10:00:00	QQQ	ETF	38.87	38.89	38.11	38.2	31967153.0
2008-10-01 11:00:00	QQQ	ETF	38.19	38.43	38.03	38.34	16523473.0
2008-10-01 12:00:00	QQQ	ETF	38.33	38.92	38.2	38.77	24924814.0
2008-10-01 13:00:00	QQQ	ETF	38.78	38.78	38.16	38.43	29451642.0
2008-10-01 14:00:00	QQQ	ETF	38.43	38.81	38.32	38.51	18855921.0
2008-10-01 15:00:00	QQQ	ETF	38.52	38.59	38.31	38.49	22816047.0
2008-10-01 16:00:00	QQQ	ETF	38.49	38.69	38.39	38.65	7497862.0
2008-10-01 17:00:00	QQQ	ETF	38.65	38.87	38.63	38.68	118297.0
2008-10-01 18:00:00	QQQ	ETF	38.68	38.8	38.68	38.75	63065.0
2008-10-01 19:00:00	QQQ	ETF	38.75	38.88	38.71	38.8	42764.0
2008-10-01 07:00:00	IWM	ETF	67.51	67.51	67.51	67.51	3000.0
2008-10-01 08:00:00	IWM	ETF	67.38	67.5	67.19	67.4	192068.0
2008-10-01 09:00:00	IWM	ETF	67.36	68.0	66.78	67.14	8329037.0
2008-10-01 10:00:00	IWM	ETF	67.14	67.16	66.35	66.49	13642623.0
2008-10-01 11:00:00	IWM	ETF	66.49	66.74	66.29	66.6	6446294.0
2008-10-01 12:00:00	IWM	ETF	66.6	67.28	66.5	67.07	8416902.0
2008-10-01 13:00:00	IWM	ETF	67.08	67.2	66.45	66.83	9839332.0
2008-10-01 14:00:00	IWM	ETF	66.83	67.12	66.66	66.87	7482581.0
2008-10-01 15:00:00	IWM	ETF	66.86	67.2	66.68	67.07	11382333.0
2008-10-01 16:00:00	IWM	ETF	67.06	67.54	66.98	67.45	1142665.0
2008-10-01 17:00:00	IWM	ETF	67.49	67.56	67.37	67.56	25900.0
2008-10-01 19:00:00	IWM	ETF	67.5	67.5	67.5	67.5	300.0
2008-10-01 07:00:00	DIA	ETF	108.0	108.0	107.7	107.7	1200.0
2008-10-01 08:00:00	DIA	ETF	107.7	107.95	107.4	107.6	57320.0
2008-10-01 09:00:00	DIA	ETF	107.61	107.73	107.1	107.47	1814741.0
2008-10-01 10:00:00	DIA	ETF	107.47	107.49	106.3	106.66	3491774.0
2008-10-01 11:00:00	DIA	ETF	106.64	107.49	106.28	107.28	2184692.0
2008-10-01 12:00:00	DIA	ETF	107.28	108.79	107.17	108.33	2639735.0
2008-10-01 13:00:00	DIA	ETF	108.33	108.68	107.17	107.92	4718126.0

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

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