PREVIEW / etf_1hour / 2008-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-04-08.parquet
  size:    99 KB
  rows:    3,404

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-04-08 04:00:00	SPY	ETF	136.37	136.44	136.37	136.44	200.0
2008-04-08 05:00:00	SPY	ETF	136.3	136.3	136.21	136.24	8200.0
2008-04-08 06:00:00	SPY	ETF	136.37	136.37	136.15	136.25	35100.0
2008-04-08 07:00:00	SPY	ETF	136.27	136.46	136.2	136.45	389400.0
2008-04-08 08:00:00	SPY	ETF	136.45	136.45	136.21	136.36	1835200.0
2008-04-08 09:00:00	SPY	ETF	136.36	136.58	136.1	136.52	17568037.0
2008-04-08 10:00:00	SPY	ETF	136.53	136.89	136.23	136.71	24037389.0
2008-04-08 11:00:00	SPY	ETF	136.71	137.1554	136.45	136.54	15144421.0
2008-04-08 12:00:00	SPY	ETF	136.53	136.7	136.38	136.5	10550701.0
2008-04-08 13:00:00	SPY	ETF	136.5	136.6	136.27	136.48	11446638.0
2008-04-08 14:00:00	SPY	ETF	136.48	136.63	135.95	136.58	29369597.0
2008-04-08 15:00:00	SPY	ETF	136.57	136.73	136.13	136.46	28996483.0
2008-04-08 16:00:00	SPY	ETF	136.6	137.1554	136.46	136.81	5484000.0
2008-04-08 17:00:00	SPY	ETF	136.79	136.8	136.45	136.74	1180600.0
2008-04-08 18:00:00	SPY	ETF	136.74	137.17	136.74	137.07	328500.0
2008-04-08 19:00:00	SPY	ETF	137.04	137.26	136.98	137.11	237500.0
2008-04-08 05:00:00	QQQ	ETF	45.52	45.52	45.5	45.5	600.0
2008-04-08 06:00:00	QQQ	ETF	45.56	45.56	45.47	45.49	56879.0
2008-04-08 07:00:00	QQQ	ETF	45.52	45.52	45.46	45.49	345692.0
2008-04-08 08:00:00	QQQ	ETF	45.49	45.52	45.38	45.44	3599246.0
2008-04-08 09:00:00	QQQ	ETF	45.45	45.48	45.32	45.451	12252742.0
2008-04-08 10:00:00	QQQ	ETF	45.46	45.7	45.33	45.62	17467322.0
2008-04-08 11:00:00	QQQ	ETF	45.62	45.72	45.4801	45.5026	9102515.0
2008-04-08 12:00:00	QQQ	ETF	45.51	45.6	45.48	45.52	5484972.0
2008-04-08 13:00:00	QQQ	ETF	45.52	45.56	45.4	45.488	8866316.0
2008-04-08 14:00:00	QQQ	ETF	45.48	45.48	45.18	45.43	18916239.0
2008-04-08 15:00:00	QQQ	ETF	45.44	45.5	45.27	45.39	14387477.0
2008-04-08 16:00:00	QQQ	ETF	45.39	45.51	45.38	45.46	4398138.0
2008-04-08 17:00:00	QQQ	ETF	45.46	45.5	45.38	45.46	486931.0
2008-04-08 18:00:00	QQQ	ETF	45.47	45.59	45.4	45.54	146236.0
2008-04-08 19:00:00	QQQ	ETF	45.55	45.63	45.55	45.6	57704.0
2008-04-08 07:00:00	IWM	ETF	70.59	70.64	70.59	70.6	7100.0
2008-04-08 08:00:00	IWM	ETF	70.63	70.64	70.46	70.56	152600.0
2008-04-08 09:00:00	IWM	ETF	70.56	70.76	70.37	70.74	8614637.0
2008-04-08 10:00:00	IWM	ETF	70.75	71.17	70.62	71.06	9902619.0
2008-04-08 11:00:00	IWM	ETF	71.07	71.28	70.99	71.07	3863117.0
2008-04-08 12:00:00	IWM	ETF	71.08	71.19	70.88	71.0	4267946.0
2008-04-08 13:00:00	IWM	ETF	71.01	71.03	70.68	70.88	6271625.0
2008-04-08 14:00:00	IWM	ETF	70.88	71.0	70.51	70.98	6844628.0
2008-04-08 15:00:00	IWM	ETF	70.98	71.13	70.7	70.97	7953623.0
2008-04-08 16:00:00	IWM	ETF	70.97	71.21	70.97	71.18	847800.0
2008-04-08 17:00:00	IWM	ETF	71.07	71.13	71.0	71.07	58100.0
2008-04-08 18:00:00	IWM	ETF	71.26	71.33	71.22	71.3	4800.0
2008-04-08 19:00:00	IWM	ETF	71.19	71.21	71.19	71.21	400.0
2008-04-08 07:00:00	DIA	ETF	125.37	125.58	125.37	125.5	24500.0
2008-04-08 08:00:00	DIA	ETF	125.5	125.55	125.41	125.53	50900.0
2008-04-08 09:00:00	DIA	ETF	125.53	125.58	125.24	125.57	1675911.0
2008-04-08 10:00:00	DIA	ETF	125.55	125.91	125.34	125.76	2009456.0
2008-04-08 11:00:00	DIA	ETF	125.76	126.03	125.66	125.73	1062367.0
2008-04-08 12:00:00	DIA	ETF	125.72	125.88	125.61	125.74	1371694.0

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

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