PREVIEW / etf_1hour / 2008-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-05-22.parquet
  size:    106 KB
  rows:    3,428

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-05-22 04:00:00	SPY	ETF	140.04	140.04	140.04	140.04	100.0
2008-05-22 06:00:00	SPY	ETF	139.66	139.68	139.56	139.56	23200.0
2008-05-22 07:00:00	SPY	ETF	139.78	139.78	139.26	139.28	753314.0
2008-05-22 08:00:00	SPY	ETF	139.31	140.04	139.24	139.69	3912085.0
2008-05-22 09:00:00	SPY	ETF	139.67	139.72	139.28	139.469	21456237.0
2008-05-22 10:00:00	SPY	ETF	139.46	140.16	139.46	139.85	35602648.0
2008-05-22 11:00:00	SPY	ETF	139.85	140.05	139.0	139.48	22395890.0
2008-05-22 12:00:00	SPY	ETF	139.48	139.83	139.23	139.78	17707973.0
2008-05-22 13:00:00	SPY	ETF	139.78	140.17	139.57	139.92	14322201.0
2008-05-22 14:00:00	SPY	ETF	139.92	140.08	139.4	139.8	21305436.0
2008-05-22 15:00:00	SPY	ETF	139.81	139.92	139.32	139.56	26649716.0
2008-05-22 16:00:00	SPY	ETF	139.53	139.6861	139.37	139.51	5118605.0
2008-05-22 17:00:00	SPY	ETF	139.51	139.55	139.5	139.5	50874.0
2008-05-22 18:00:00	SPY	ETF	139.52	139.54	139.48	139.54	12100.0
2008-05-22 19:00:00	SPY	ETF	139.53	139.58	139.45	139.45	13360.0
2008-05-22 04:00:00	QQQ	ETF	48.4	48.46	48.4	48.46	400.0
2008-05-22 05:00:00	QQQ	ETF	48.44	48.47	48.44	48.46	1400.0
2008-05-22 06:00:00	QQQ	ETF	48.35	48.36	48.3	48.36	1600.0
2008-05-22 07:00:00	QQQ	ETF	48.4	48.4	48.17	48.17	834460.0
2008-05-22 08:00:00	QQQ	ETF	48.17	48.32	48.1	48.3	2217679.0
2008-05-22 09:00:00	QQQ	ETF	48.3	48.47	48.13	48.2701	20862145.0
2008-05-22 10:00:00	QQQ	ETF	48.28	48.69	48.26	48.47	28534800.0
2008-05-22 11:00:00	QQQ	ETF	48.46	48.56	48.2	48.35	13569777.0
2008-05-22 12:00:00	QQQ	ETF	48.35	48.61	48.24	48.53	14965498.0
2008-05-22 13:00:00	QQQ	ETF	48.53	48.63	48.4	48.44	7592895.0
2008-05-22 14:00:00	QQQ	ETF	48.45	48.58	48.11	48.32	22239077.0
2008-05-22 15:00:00	QQQ	ETF	48.33	48.42	48.13	48.35	16849403.0
2008-05-22 16:00:00	QQQ	ETF	48.36	48.45	48.29	48.29	13690496.0
2008-05-22 17:00:00	QQQ	ETF	48.3	48.37	48.3	48.35	201453.0
2008-05-22 18:00:00	QQQ	ETF	48.35	48.37	48.35	48.35	127525.0
2008-05-22 19:00:00	QQQ	ETF	48.35	48.37	48.32	48.32	9985.0
2008-05-22 06:00:00	IWM	ETF	73.0	73.0	72.89	72.89	30000.0
2008-05-22 07:00:00	IWM	ETF	72.98	72.98	72.68	72.68	90700.0
2008-05-22 08:00:00	IWM	ETF	72.71	72.93	72.62	72.92	560660.0
2008-05-22 09:00:00	IWM	ETF	72.92	73.25	72.69	72.96	8319213.0
2008-05-22 10:00:00	IWM	ETF	72.96	73.55	72.92	73.33	10704152.0
2008-05-22 11:00:00	IWM	ETF	73.33	73.43	72.95	73.09	8776612.0
2008-05-22 12:00:00	IWM	ETF	73.08	73.33	73.0	73.26	3791117.0
2008-05-22 13:00:00	IWM	ETF	73.24	73.56	73.19	73.42	4301308.0
2008-05-22 14:00:00	IWM	ETF	73.42	73.54	73.04	73.21	7856019.0
2008-05-22 15:00:00	IWM	ETF	73.2	73.25	72.77	73.17	8760380.0
2008-05-22 16:00:00	IWM	ETF	73.17	73.18	72.6	73.04	4207571.0
2008-05-22 17:00:00	IWM	ETF	73.08	73.09	73.03	73.03	2056.0
2008-05-22 19:00:00	IWM	ETF	73.14	73.14	73.04	73.04	400.0
2008-05-22 04:00:00	DIA	ETF	126.25	126.5	126.25	126.44	500.0
2008-05-22 07:00:00	DIA	ETF	126.15	126.17	126.06	126.15	4600.0
2008-05-22 08:00:00	DIA	ETF	126.08	126.4	126.03	126.32	236568.0
2008-05-22 09:00:00	DIA	ETF	126.32	126.33	125.98	126.11	1353963.0
2008-05-22 10:00:00	DIA	ETF	126.14	126.65	126.12	126.39	2774465.0
2008-05-22 11:00:00	DIA	ETF	126.38	126.6	125.92	126.06	1846063.0

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

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