PREVIEW / etf_1hour / 2008-06-05

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-06-05.parquet
  size:    108 KB
  rows:    3,455

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-05 04:00:00	SPY	ETF	138.53	138.7	138.53	138.59	21800.0
2008-06-05 05:00:00	SPY	ETF	138.54	138.54	138.46	138.46	500.0
2008-06-05 06:00:00	SPY	ETF	138.52	138.54	138.27	138.28	9100.0
2008-06-05 07:00:00	SPY	ETF	138.23	138.71	138.21	138.66	1717727.0
2008-06-05 08:00:00	SPY	ETF	138.68	139.19	138.52	138.56	8245421.0
2008-06-05 09:00:00	SPY	ETF	138.57	139.14	138.32	139.05	23798457.0
2008-06-05 10:00:00	SPY	ETF	139.06	139.79	138.74	139.55	43741920.0
2008-06-05 11:00:00	SPY	ETF	139.54	139.75	139.32	139.61	19609581.0
2008-06-05 12:00:00	SPY	ETF	139.61	140.16	139.55	140.08	25382949.0
2008-06-05 13:00:00	SPY	ETF	140.08	140.23	139.91	140.02	18870750.0
2008-06-05 14:00:00	SPY	ETF	140.02	140.1474	139.0	140.11	50388646.0
2008-06-05 15:00:00	SPY	ETF	140.12	140.83	140.01	140.64	34779081.0
2008-06-05 16:00:00	SPY	ETF	140.69	140.91	138.0814	140.82	5917631.0
2008-06-05 17:00:00	SPY	ETF	140.85	140.9	139.05	140.8	419419.0
2008-06-05 18:00:00	SPY	ETF	140.81	140.85	140.79	140.79	8790.0
2008-06-05 19:00:00	SPY	ETF	140.77	140.87	140.77	140.82	22921.0
2008-06-05 04:00:00	QQQ	ETF	49.82	49.82	49.82	49.82	300.0
2008-06-05 06:00:00	QQQ	ETF	49.81	49.81	49.76	49.76	7400.0
2008-06-05 07:00:00	QQQ	ETF	49.76	49.96	49.74	49.96	856812.0
2008-06-05 08:00:00	QQQ	ETF	49.95	50.12	49.84	49.89	2465009.0
2008-06-05 09:00:00	QQQ	ETF	49.9	50.17	49.7	50.1101	17204282.0
2008-06-05 10:00:00	QQQ	ETF	50.12	50.41	50.05	50.3276	27071360.0
2008-06-05 11:00:00	QQQ	ETF	50.325	50.41	50.25	50.35	10543566.0
2008-06-05 12:00:00	QQQ	ETF	50.35	50.47	50.32	50.41	11732021.0
2008-06-05 13:00:00	QQQ	ETF	50.41	50.47	50.32	50.39	8078805.0
2008-06-05 14:00:00	QQQ	ETF	50.39	50.4	50.13	50.39	16941292.0
2008-06-05 15:00:00	QQQ	ETF	50.389	50.61	50.35	50.541	23464688.0
2008-06-05 16:00:00	QQQ	ETF	50.55	50.66	50.2985	50.6	5411568.0
2008-06-05 17:00:00	QQQ	ETF	50.58	50.61	50.54	50.59	75125.0
2008-06-05 18:00:00	QQQ	ETF	50.59	50.6	50.58	50.58	9260.0
2008-06-05 19:00:00	QQQ	ETF	50.59	50.59	50.56	50.59	9928.0
2008-06-05 06:00:00	IWM	ETF	74.34	74.34	74.34	74.34	500.0
2008-06-05 07:00:00	IWM	ETF	74.43	74.58	74.43	74.58	13328.0
2008-06-05 08:00:00	IWM	ETF	74.51	74.82	74.5	74.5	1493883.0
2008-06-05 09:00:00	IWM	ETF	74.49	75.06	74.25	74.96	12475057.0
2008-06-05 10:00:00	IWM	ETF	74.97	75.56	74.84	75.37	13009671.0
2008-06-05 11:00:00	IWM	ETF	75.38	75.43	75.27	75.37	4940051.0
2008-06-05 12:00:00	IWM	ETF	75.36	75.89	75.32	75.81	16049786.0
2008-06-05 13:00:00	IWM	ETF	75.82	76.0	75.74	75.83	9187003.0
2008-06-05 14:00:00	IWM	ETF	75.82	75.92	75.3	75.85	16633525.0
2008-06-05 15:00:00	IWM	ETF	75.85	76.18	75.78	76.18	18516079.0
2008-06-05 16:00:00	IWM	ETF	76.18	76.35	74.29	76.32	9146887.0
2008-06-05 17:00:00	IWM	ETF	76.32	76.32	76.17	76.17	41916.0
2008-06-05 18:00:00	IWM	ETF	76.29	76.32	76.28	76.32	14714.0
2008-06-05 19:00:00	IWM	ETF	76.32	76.32	76.27	76.32	1301.0
2008-06-05 04:00:00	DIA	ETF	124.13	124.38	124.13	124.38	200.0
2008-06-05 07:00:00	DIA	ETF	124.38	124.48	124.36	124.48	3570.0
2008-06-05 08:00:00	DIA	ETF	124.48	124.84	124.38	124.38	96331.0
2008-06-05 09:00:00	DIA	ETF	124.37	124.91	124.12	124.75	1189900.0
2008-06-05 10:00:00	DIA	ETF	124.76	125.48	124.47	125.26	2628256.0

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

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