PREVIEW / etf_1hour / 2008-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-08.parquet
  size:    113 KB
  rows:    3,604

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-08 04:00:00	SPY	ETF	123.86	123.86	123.6	123.69	9700.0
2008-07-08 05:00:00	SPY	ETF	124.12	124.24	124.12	124.18	5500.0
2008-07-08 06:00:00	SPY	ETF	124.31	124.65	124.13	124.6	133300.0
2008-07-08 07:00:00	SPY	ETF	124.63	124.7	124.07	124.24	1447238.0
2008-07-08 08:00:00	SPY	ETF	124.45	125.26	124.05	124.79	10546102.0
2008-07-08 09:00:00	SPY	ETF	124.8	125.63	124.62	125.19	42702916.0
2008-07-08 10:00:00	SPY	ETF	125.18	125.48	124.2	124.76	69143943.0
2008-07-08 11:00:00	SPY	ETF	124.751	125.53	124.49	125.21	49910346.0
2008-07-08 12:00:00	SPY	ETF	125.21	125.92	125.06	125.54	30607780.0
2008-07-08 13:00:00	SPY	ETF	125.54	125.89	124.87	125.0	32770459.0
2008-07-08 14:00:00	SPY	ETF	124.99	126.49	124.9	126.46	52488901.0
2008-07-08 15:00:00	SPY	ETF	126.46	127.39	126.31	127.29	65305488.0
2008-07-08 16:00:00	SPY	ETF	127.29	127.43	126.9542	127.32	16504489.0
2008-07-08 17:00:00	SPY	ETF	127.32	127.42	127.29	127.34	194658.0
2008-07-08 18:00:00	SPY	ETF	127.4	127.45	127.32	127.33	23141.0
2008-07-08 19:00:00	SPY	ETF	127.33	127.37	127.3	127.35	54116.0
2008-07-08 04:00:00	QQQ	ETF	44.47	44.47	44.47	44.47	200.0
2008-07-08 05:00:00	QQQ	ETF	44.5	44.55	44.5	44.54	2100.0
2008-07-08 06:00:00	QQQ	ETF	44.71	44.79	44.66	44.77	31400.0
2008-07-08 07:00:00	QQQ	ETF	44.76	44.82	44.61	44.67	398567.0
2008-07-08 08:00:00	QQQ	ETF	44.68	45.05	44.65	44.86	3799382.0
2008-07-08 09:00:00	QQQ	ETF	44.88	45.39	44.77	45.26	30180962.0
2008-07-08 10:00:00	QQQ	ETF	45.26	45.4	44.83	45.0	33970349.0
2008-07-08 11:00:00	QQQ	ETF	45.0099	45.34	44.84	45.17	18654210.0
2008-07-08 12:00:00	QQQ	ETF	45.17	45.55	45.11	45.415	20113823.0
2008-07-08 13:00:00	QQQ	ETF	45.4101	45.52	45.07	45.12	18137067.0
2008-07-08 14:00:00	QQQ	ETF	45.12	45.75	45.09	45.73	26344114.0
2008-07-08 15:00:00	QQQ	ETF	45.72	46.01	45.64	45.99	37247428.0
2008-07-08 16:00:00	QQQ	ETF	45.99	46.0	44.9277	45.77	12658020.0
2008-07-08 17:00:00	QQQ	ETF	45.77	45.82	45.73	45.81	520920.0
2008-07-08 18:00:00	QQQ	ETF	45.81	45.84	45.79	45.82	29724.0
2008-07-08 19:00:00	QQQ	ETF	45.79	45.83	45.78	45.83	58495.0
2008-07-08 07:00:00	IWM	ETF	65.44	65.45	65.15	65.15	32283.0
2008-07-08 08:00:00	IWM	ETF	65.25	65.91	65.25	65.58	447607.0
2008-07-08 09:00:00	IWM	ETF	65.64	66.22	65.41	65.95	13278291.0
2008-07-08 10:00:00	IWM	ETF	65.94	66.08	65.25	65.52	19828880.0
2008-07-08 11:00:00	IWM	ETF	65.51	66.24	65.46	66.01	14671645.0
2008-07-08 12:00:00	IWM	ETF	66.02	66.54	65.96	66.23	12840395.0
2008-07-08 13:00:00	IWM	ETF	66.24	66.45	65.79	66.05	11176045.0
2008-07-08 14:00:00	IWM	ETF	66.05	67.29	66.01	67.27	21228830.0
2008-07-08 15:00:00	IWM	ETF	67.28	68.07	67.16	68.06	27601695.0
2008-07-08 16:00:00	IWM	ETF	68.05	68.45	66.57	68.12	5296114.0
2008-07-08 17:00:00	IWM	ETF	68.19	68.2	68.07	68.2	1657.0
2008-07-08 18:00:00	IWM	ETF	68.15	68.15	68.06	68.06	57552.0
2008-07-08 19:00:00	IWM	ETF	68.12	68.12	68.12	68.12	500.0
2008-07-08 06:00:00	DIA	ETF	111.61	111.61	111.54	111.54	500.0
2008-07-08 07:00:00	DIA	ETF	111.67	111.8	111.45	111.52	1300.0
2008-07-08 08:00:00	DIA	ETF	111.54	112.26	111.54	111.96	170902.0
2008-07-08 09:00:00	DIA	ETF	111.96	112.89	111.92	112.54	4417846.0
2008-07-08 10:00:00	DIA	ETF	112.54	112.76	111.74	112.2	6146199.0

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

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