PREVIEW / etf_1hour / 2008-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-06.parquet
  size:    111 KB
  rows:    3,565

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-06 04:00:00	SPY	ETF	141.09	141.1	141.0	141.0	5850.0
2008-06-06 05:00:00	SPY	ETF	140.72	140.85	140.72	140.85	10100.0
2008-06-06 06:00:00	SPY	ETF	140.62	140.9	140.58	140.9	10700.0
2008-06-06 07:00:00	SPY	ETF	141.0	141.0	140.63	140.85	213588.0
2008-06-06 08:00:00	SPY	ETF	140.6	141.4	139.92	140.12	13381521.0
2008-06-06 09:00:00	SPY	ETF	140.11	140.11	139.33	139.4	34533997.0
2008-06-06 10:00:00	SPY	ETF	139.41	139.42	138.44	138.67	55607617.0
2008-06-06 11:00:00	SPY	ETF	138.67	138.68	137.93	138.29	44880447.0
2008-06-06 12:00:00	SPY	ETF	138.29	138.54	138.03	138.24	28881298.0
2008-06-06 13:00:00	SPY	ETF	138.25	138.34	137.78	138.05	34745225.0
2008-06-06 14:00:00	SPY	ETF	138.04	138.055	137.15	137.19	52081610.0
2008-06-06 15:00:00	SPY	ETF	137.19	138.0	136.34	136.38	88876639.0
2008-06-06 16:00:00	SPY	ETF	136.63	137.1	136.22	136.46	18504112.0
2008-06-06 17:00:00	SPY	ETF	136.45	136.54	136.32	136.42	239949.0
2008-06-06 18:00:00	SPY	ETF	136.5	136.5	136.4	136.42	10364.0
2008-06-06 19:00:00	SPY	ETF	136.5	136.55	136.42	136.55	18127.0
2008-06-06 06:00:00	QQQ	ETF	50.5	50.6	50.5	50.6	1400.0
2008-06-06 07:00:00	QQQ	ETF	50.62	50.62	50.49	50.59	234703.0
2008-06-06 08:00:00	QQQ	ETF	50.58	50.75	50.23	50.33	4911000.0
2008-06-06 09:00:00	QQQ	ETF	50.33	50.61	49.91	50.04	21910084.0
2008-06-06 10:00:00	QQQ	ETF	50.05	50.0599	49.77	49.81	29147182.0
2008-06-06 11:00:00	QQQ	ETF	49.81	49.82	49.55	49.6699	22709645.0
2008-06-06 12:00:00	QQQ	ETF	49.66	49.8	49.56	49.69	13735948.0
2008-06-06 13:00:00	QQQ	ETF	49.69	49.71	49.44	49.53	15486042.0
2008-06-06 14:00:00	QQQ	ETF	49.52	49.53	49.07	49.09	26271366.0
2008-06-06 15:00:00	QQQ	ETF	49.09	49.48	49.02	49.03	36918419.0
2008-06-06 16:00:00	QQQ	ETF	49.03	50.5786	48.89	49.03	12776886.0
2008-06-06 17:00:00	QQQ	ETF	49.04	49.06	48.98	49.05	164504.0
2008-06-06 18:00:00	QQQ	ETF	49.05	49.05	48.97	49.01	26700.0
2008-06-06 19:00:00	QQQ	ETF	49.03	49.08	49.03	49.07	14240.0
2008-06-06 06:00:00	IWM	ETF	76.29	76.29	76.29	76.29	100.0
2008-06-06 07:00:00	IWM	ETF	76.49	76.49	76.26	76.38	51154.0
2008-06-06 08:00:00	IWM	ETF	76.37	76.59	75.89	76.0	3013025.0
2008-06-06 09:00:00	IWM	ETF	75.99	75.99	75.22	75.31	15490176.0
2008-06-06 10:00:00	IWM	ETF	75.31	75.31	74.5	75.01	17159549.0
2008-06-06 11:00:00	IWM	ETF	75.01	75.01	74.55	74.92	10896862.0
2008-06-06 12:00:00	IWM	ETF	74.91	75.13	74.79	74.87	10114915.0
2008-06-06 13:00:00	IWM	ETF	74.88	74.9	74.47	74.62	10532277.0
2008-06-06 14:00:00	IWM	ETF	74.62	74.63	74.18	74.25	17554856.0
2008-06-06 15:00:00	IWM	ETF	74.25	74.92	73.94	73.94	30955545.0
2008-06-06 16:00:00	IWM	ETF	73.94	76.24	73.89	74.02	6581605.0
2008-06-06 17:00:00	IWM	ETF	74.02	74.03	74.02	74.03	4400.0
2008-06-06 18:00:00	IWM	ETF	74.03	74.03	74.02	74.03	2200.0
2008-06-06 19:00:00	IWM	ETF	74.02	74.03	73.94	74.03	9300.0
2008-06-06 06:00:00	DIA	ETF	126.06	126.06	126.06	126.06	100.0
2008-06-06 07:00:00	DIA	ETF	126.15	126.22	126.15	126.21	8737.0
2008-06-06 08:00:00	DIA	ETF	126.25	126.62	125.52	125.69	242274.0
2008-06-06 09:00:00	DIA	ETF	125.67	125.67	124.31	124.38	2641727.0
2008-06-06 10:00:00	DIA	ETF	124.37	124.39	123.7	123.92	3963725.0
2008-06-06 11:00:00	DIA	ETF	123.92	123.94	123.15	123.55	3068156.0

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

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