PREVIEW / etf_1hour / 2008-06-02

all etf 1-hour files

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

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-02 04:00:00	SPY	ETF	139.71	139.71	139.42	139.42	21450.0
2008-06-02 06:00:00	SPY	ETF	139.7	139.72	139.58	139.61	44595.0
2008-06-02 07:00:00	SPY	ETF	139.61	139.72	139.52	139.7	390200.0
2008-06-02 08:00:00	SPY	ETF	139.69	140.35	139.39	139.68	1802238.0
2008-06-02 09:00:00	SPY	ETF	139.68	139.86	139.18	139.27	16308157.0
2008-06-02 10:00:00	SPY	ETF	139.28	139.66	138.7	138.98	29126862.0
2008-06-02 11:00:00	SPY	ETF	138.98	139.09	138.65	138.96	20858581.0
2008-06-02 12:00:00	SPY	ETF	138.97	139.03	138.0	138.1	28859955.0
2008-06-02 13:00:00	SPY	ETF	138.1	138.465	138.03	138.46	21958098.0
2008-06-02 14:00:00	SPY	ETF	138.46	138.61	138.31	138.37	20657980.0
2008-06-02 15:00:00	SPY	ETF	138.37	139.03	138.23	138.83	33289091.0
2008-06-02 16:00:00	SPY	ETF	138.829	138.95	138.75	138.86	5873423.0
2008-06-02 17:00:00	SPY	ETF	138.86	138.89	138.83	138.89	169479.0
2008-06-02 18:00:00	SPY	ETF	138.86	138.86	138.81	138.81	14466.0
2008-06-02 19:00:00	SPY	ETF	138.83	138.85	138.78	138.85	16358.0
2008-06-02 05:00:00	QQQ	ETF	49.82	49.82	49.82	49.82	200.0
2008-06-02 06:00:00	QQQ	ETF	49.84	49.84	49.82	49.82	700.0
2008-06-02 07:00:00	QQQ	ETF	49.82	49.9	49.82	49.89	244049.0
2008-06-02 08:00:00	QQQ	ETF	49.88	50.01	49.84	49.88	368483.0
2008-06-02 09:00:00	QQQ	ETF	49.88	49.92	49.64	49.72	13980708.0
2008-06-02 10:00:00	QQQ	ETF	49.72	49.77	49.41	49.45	30075300.0
2008-06-02 11:00:00	QQQ	ETF	49.45	49.47	49.24	49.38	16162664.0
2008-06-02 12:00:00	QQQ	ETF	49.37	49.4	49.0	49.0	17485440.0
2008-06-02 13:00:00	QQQ	ETF	49.0	49.17	48.96	49.17	12199854.0
2008-06-02 14:00:00	QQQ	ETF	49.17	49.22	49.08	49.12	12538115.0
2008-06-02 15:00:00	QQQ	ETF	49.12	49.41	49.01	49.4	25493117.0
2008-06-02 16:00:00	QQQ	ETF	49.4	50.0246	49.13	49.47	13576200.0
2008-06-02 17:00:00	QQQ	ETF	49.48	49.48	49.45	49.47	91770.0
2008-06-02 18:00:00	QQQ	ETF	49.47	49.47	49.44	49.44	21610.0
2008-06-02 19:00:00	QQQ	ETF	49.44	49.44	49.42	49.42	900.0
2008-06-02 05:00:00	IWM	ETF	74.34	74.34	74.34	74.34	200.0
2008-06-02 07:00:00	IWM	ETF	74.43	74.43	74.35	74.39	4000.0
2008-06-02 08:00:00	IWM	ETF	74.17	74.49	74.17	74.48	387866.0
2008-06-02 09:00:00	IWM	ETF	74.49	74.63	73.76	73.87	9604529.0
2008-06-02 10:00:00	IWM	ETF	73.87	74.03	73.63	73.97	9295629.0
2008-06-02 11:00:00	IWM	ETF	73.97	73.97	73.75	73.89	6093027.0
2008-06-02 12:00:00	IWM	ETF	73.89	73.95	73.22	73.31	9395178.0
2008-06-02 13:00:00	IWM	ETF	73.31	73.6	73.23	73.6	5496439.0
2008-06-02 14:00:00	IWM	ETF	73.6	73.8	73.54	73.59	6236040.0
2008-06-02 15:00:00	IWM	ETF	73.59	74.13	73.39	74.08	13653122.0
2008-06-02 16:00:00	IWM	ETF	74.05	74.74	73.73	74.09	6219770.0
2008-06-02 17:00:00	IWM	ETF	74.05	74.5	74.05	74.5	1105.0
2008-06-02 19:00:00	IWM	ETF	74.04	74.04	74.04	74.04	390.0
2008-06-02 07:00:00	DIA	ETF	125.55	125.8	125.55	125.77	1800.0
2008-06-02 08:00:00	DIA	ETF	125.81	125.88	125.75	125.84	40291.0
2008-06-02 09:00:00	DIA	ETF	125.86	126.0	125.3	125.37	1059864.0
2008-06-02 10:00:00	DIA	ETF	125.37	125.57	124.82	124.92	2322615.0
2008-06-02 11:00:00	DIA	ETF	124.89	124.99	124.63	124.9	1549474.0
2008-06-02 12:00:00	DIA	ETF	124.9	124.94	124.24	124.32	1966496.0
2008-06-02 13:00:00	DIA	ETF	124.32	124.61	124.3	124.59	1046338.0

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

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