PREVIEW / etf_1hour / 2008-06-04

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-04.parquet
  size:    107 KB
  rows:    3,412

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-06-04 04:00:00	SPY	ETF	137.86	137.88	137.6	137.66	5900.0
2008-06-04 05:00:00	SPY	ETF	137.71	137.71	137.5	137.5	76600.0
2008-06-04 06:00:00	SPY	ETF	137.64	137.68	137.56	137.68	164600.0
2008-06-04 07:00:00	SPY	ETF	137.63	137.65	137.45	137.53	397186.0
2008-06-04 08:00:00	SPY	ETF	137.56	137.93	137.46	137.55	5612973.0
2008-06-04 09:00:00	SPY	ETF	137.55	138.46	137.46	138.19	27673037.0
2008-06-04 10:00:00	SPY	ETF	138.18	138.86	137.97	138.76	34680648.0
2008-06-04 11:00:00	SPY	ETF	138.75	139.08	138.6	138.79	18546050.0
2008-06-04 12:00:00	SPY	ETF	138.79	139.16	138.47	138.52	26409870.0
2008-06-04 13:00:00	SPY	ETF	138.52	138.93	138.25	138.83	23462810.0
2008-06-04 14:00:00	SPY	ETF	138.83	138.89	137.46	137.59	52185687.0
2008-06-04 15:00:00	SPY	ETF	137.59	138.48	137.49	138.04	46197345.0
2008-06-04 16:00:00	SPY	ETF	138.0199	139.25	137.9	138.02	5181248.0
2008-06-04 17:00:00	SPY	ETF	138.02	138.06	137.97	138.05	36806.0
2008-06-04 18:00:00	SPY	ETF	138.05	138.12	138.02	138.05	64142.0
2008-06-04 19:00:00	SPY	ETF	138.08	138.15	138.02	138.15	3800.0
2008-06-04 04:00:00	QQQ	ETF	49.0	49.0	49.0	49.0	300.0
2008-06-04 05:00:00	QQQ	ETF	49.02	49.02	49.02	49.02	200.0
2008-06-04 06:00:00	QQQ	ETF	49.02	49.02	48.98	49.02	1200.0
2008-06-04 07:00:00	QQQ	ETF	49.05	49.05	48.92	48.96	165160.0
2008-06-04 08:00:00	QQQ	ETF	48.98	49.1	48.85	48.87	1382319.0
2008-06-04 09:00:00	QQQ	ETF	48.88	49.44	48.84	49.33	18711233.0
2008-06-04 10:00:00	QQQ	ETF	49.325	49.93	49.24	49.87	32051073.0
2008-06-04 11:00:00	QQQ	ETF	49.88	50.06	49.86	49.909	17478875.0
2008-06-04 12:00:00	QQQ	ETF	49.9	50.1	49.82	49.83	17518121.0
2008-06-04 13:00:00	QQQ	ETF	49.83	50.0	49.7	49.98	15567125.0
2008-06-04 14:00:00	QQQ	ETF	49.98	50.0	49.39	49.489	33345272.0
2008-06-04 15:00:00	QQQ	ETF	49.48	49.8	49.435	49.75	28693710.0
2008-06-04 16:00:00	QQQ	ETF	49.75	50.05	49.6	49.67	3596588.0
2008-06-04 17:00:00	QQQ	ETF	49.67	49.69	49.64	49.65	23058.0
2008-06-04 18:00:00	QQQ	ETF	49.66	49.68	49.63	49.66	28091.0
2008-06-04 19:00:00	QQQ	ETF	49.66	49.69	49.65	49.68	57401.0
2008-06-04 06:00:00	IWM	ETF	73.53	73.57	73.53	73.57	200.0
2008-06-04 07:00:00	IWM	ETF	73.54	73.55	73.41	73.5	24221.0
2008-06-04 08:00:00	IWM	ETF	73.45	73.77	73.45	73.48	841679.0
2008-06-04 09:00:00	IWM	ETF	73.49	73.92	73.34	73.73	9290420.0
2008-06-04 10:00:00	IWM	ETF	73.73	74.42	73.63	74.36	12343466.0
2008-06-04 11:00:00	IWM	ETF	74.37	74.75	74.31	74.54	8835958.0
2008-06-04 12:00:00	IWM	ETF	74.54	74.95	74.52	74.66	10286924.0
2008-06-04 13:00:00	IWM	ETF	74.66	74.84	74.56	74.79	8340464.0
2008-06-04 14:00:00	IWM	ETF	74.79	74.83	73.97	74.03	14236562.0
2008-06-04 15:00:00	IWM	ETF	74.03	74.39	73.94	74.28	13064336.0
2008-06-04 16:00:00	IWM	ETF	74.28	74.34	73.82	74.2	3153206.0
2008-06-04 17:00:00	IWM	ETF	74.17	74.22	74.16	74.22	2997.0
2008-06-04 18:00:00	IWM	ETF	74.19	74.19	74.19	74.19	300.0
2008-06-04 19:00:00	IWM	ETF	74.2	74.2	74.2	74.2	500.0
2008-06-04 06:00:00	DIA	ETF	123.76	123.76	123.73	123.73	1600.0
2008-06-04 07:00:00	DIA	ETF	123.69	123.69	123.57	123.57	4626.0
2008-06-04 08:00:00	DIA	ETF	123.63	123.9	123.62	123.66	110444.0
2008-06-04 09:00:00	DIA	ETF	123.68	124.45	123.58	124.25	1728751.0

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

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