PREVIEW / etf_1hour / 2008-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-16.parquet
  size:    115 KB
  rows:    3,615

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-07-16 04:00:00	SPY	ETF	121.4	121.4	121.35	121.36	2500.0
2008-07-16 05:00:00	SPY	ETF	121.32	121.32	120.91	120.92	17700.0
2008-07-16 06:00:00	SPY	ETF	120.85	120.85	120.25	120.52	335400.0
2008-07-16 07:00:00	SPY	ETF	120.5	120.88	120.35	120.66	1070874.0
2008-07-16 08:00:00	SPY	ETF	120.6	121.84	120.26	121.28	13663169.0
2008-07-16 09:00:00	SPY	ETF	121.3	122.42	121.1	122.33	50511549.0
2008-07-16 10:00:00	SPY	ETF	122.33	122.82	121.25	122.48	68647746.0
2008-07-16 11:00:00	SPY	ETF	122.48	122.9	121.25	122.35	48233901.0
2008-07-16 12:00:00	SPY	ETF	122.35	122.95	122.22	122.87	26256394.0
2008-07-16 13:00:00	SPY	ETF	122.87	123.34	122.73	123.17	33761906.0
2008-07-16 14:00:00	SPY	ETF	123.17	123.78	122.68	123.67	50235769.0
2008-07-16 15:00:00	SPY	ETF	123.66	124.57	123.49	124.47	53040793.0
2008-07-16 16:00:00	SPY	ETF	124.451	124.52	121.4914	124.05	17263047.0
2008-07-16 17:00:00	SPY	ETF	124.05	124.14	121.49	123.95	4393850.0
2008-07-16 18:00:00	SPY	ETF	123.95	124.01	123.92	123.93	74500.0
2008-07-16 19:00:00	SPY	ETF	123.93	124.0	123.9	123.99	40773.0
2008-07-16 06:00:00	QQQ	ETF	43.88	44.06	43.84	44.02	12000.0
2008-07-16 07:00:00	QQQ	ETF	43.85	44.11	43.85	44.05	483010.0
2008-07-16 08:00:00	QQQ	ETF	44.05	44.49	44.05	44.25	9221818.0
2008-07-16 09:00:00	QQQ	ETF	44.23	44.47	43.92	44.42	30386622.0
2008-07-16 10:00:00	QQQ	ETF	44.42	44.76	44.07	44.67	36014037.0
2008-07-16 11:00:00	QQQ	ETF	44.68	44.9	44.51	44.69	25029914.0
2008-07-16 12:00:00	QQQ	ETF	44.69	44.92	44.56	44.91	14082846.0
2008-07-16 13:00:00	QQQ	ETF	44.89	45.09	44.86	45.01	17427420.0
2008-07-16 14:00:00	QQQ	ETF	45.01	45.31	44.83	45.27	21013922.0
2008-07-16 15:00:00	QQQ	ETF	45.28	45.38	45.18	45.34	26499449.0
2008-07-16 16:00:00	QQQ	ETF	45.33	45.3599	44.7471	45.14	3681725.0
2008-07-16 17:00:00	QQQ	ETF	45.15	45.18	45.12	45.17	60068.0
2008-07-16 18:00:00	QQQ	ETF	45.15	45.16	45.13	45.14	34873.0
2008-07-16 19:00:00	QQQ	ETF	45.14	45.16	45.13	45.16	24344.0
2008-07-16 06:00:00	IWM	ETF	65.85	65.85	65.84	65.84	2200.0
2008-07-16 07:00:00	IWM	ETF	65.64	65.81	65.6	65.75	27971.0
2008-07-16 08:00:00	IWM	ETF	65.7	66.5	65.7	66.19	1704502.0
2008-07-16 09:00:00	IWM	ETF	66.17	66.68	65.79	66.64	9761153.0
2008-07-16 10:00:00	IWM	ETF	66.63	67.09	66.02	67.04	20397199.0
2008-07-16 11:00:00	IWM	ETF	67.03	67.4	66.92	67.14	12167288.0
2008-07-16 12:00:00	IWM	ETF	67.14	67.47	67.05	67.41	7546043.0
2008-07-16 13:00:00	IWM	ETF	67.41	67.8	67.36	67.57	11479578.0
2008-07-16 14:00:00	IWM	ETF	67.59	68.0	67.21	67.93	12966415.0
2008-07-16 15:00:00	IWM	ETF	67.93	68.49	67.85	68.38	19992912.0
2008-07-16 16:00:00	IWM	ETF	68.4	68.44	66.04	68.19	13566736.0
2008-07-16 17:00:00	IWM	ETF	68.14	68.2	68.14	68.14	1244.0
2008-07-16 18:00:00	IWM	ETF	68.14	68.14	68.14	68.14	200.0
2008-07-16 19:00:00	IWM	ETF	68.14	68.14	68.14	68.14	1959.0
2008-07-16 06:00:00	DIA	ETF	108.99	109.12	108.96	108.96	400.0
2008-07-16 07:00:00	DIA	ETF	108.81	109.11	108.81	108.93	40311.0
2008-07-16 08:00:00	DIA	ETF	109.01	109.92	109.01	109.46	389925.0
2008-07-16 09:00:00	DIA	ETF	109.42	110.42	109.2	110.38	4076431.0
2008-07-16 10:00:00	DIA	ETF	110.39	110.94	109.53	110.69	5715588.0
2008-07-16 11:00:00	DIA	ETF	110.7	111.08	110.31	110.66	4795438.0

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

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