PREVIEW / etf_1hour / 2007-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-12-19.parquet
  size:    94 KB
  rows:    3,121

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
2007-12-19 04:00:00	SPY	ETF	145.62	145.62	145.55	145.55	3600.0
2007-12-19 05:00:00	SPY	ETF	145.57	145.62	145.1	145.24	8800.0
2007-12-19 06:00:00	SPY	ETF	145.39	145.62	145.39	145.47	69100.0
2007-12-19 07:00:00	SPY	ETF	145.38	145.86	145.1	145.5	1452700.0
2007-12-19 08:00:00	SPY	ETF	145.2	146.343	145.19	146.03	2481200.0
2007-12-19 09:00:00	SPY	ETF	146.02	146.6	145.69	146.39	25616813.0
2007-12-19 10:00:00	SPY	ETF	146.41	146.89	146.2	146.54	36503033.0
2007-12-19 11:00:00	SPY	ETF	146.55	146.55	145.11	145.27	35666105.0
2007-12-19 12:00:00	SPY	ETF	145.28	145.83	145.22	145.6695	13709950.0
2007-12-19 13:00:00	SPY	ETF	145.67	145.67	144.94	145.29	15347774.0
2007-12-19 14:00:00	SPY	ETF	145.29	146.5	145.2	146.15	31253234.0
2007-12-19 15:00:00	SPY	ETF	146.15	146.35	145.62	145.62	25194970.0
2007-12-19 16:00:00	SPY	ETF	145.69	146.168	145.38	145.81	5739600.0
2007-12-19 17:00:00	SPY	ETF	145.83	146.75	145.62	145.94	484600.0
2007-12-19 18:00:00	SPY	ETF	145.92	146.02	145.86	145.95	123700.0
2007-12-19 19:00:00	SPY	ETF	145.96	146.0	145.89	145.97	13100.0
2007-12-19 04:00:00	QQQ	ETF	49.85	49.85	49.85	49.85	200.0
2007-12-19 05:00:00	QQQ	ETF	49.7	49.7	49.7	49.7	200.0
2007-12-19 06:00:00	QQQ	ETF	49.8	49.82	49.8	49.82	12000.0
2007-12-19 07:00:00	QQQ	ETF	49.85	49.99	49.76	49.88	708278.0
2007-12-19 08:00:00	QQQ	ETF	49.9	50.01	49.86	49.91	2222339.0
2007-12-19 09:00:00	QQQ	ETF	49.92	50.17	49.7999	50.09	16470968.0
2007-12-19 10:00:00	QQQ	ETF	50.09	50.2	49.98	50.03	18892679.0
2007-12-19 11:00:00	QQQ	ETF	50.03	50.0394	49.7	49.7	17319018.0
2007-12-19 12:00:00	QQQ	ETF	49.71	49.9595	49.65	49.89	11509227.0
2007-12-19 13:00:00	QQQ	ETF	49.88	49.88	49.61	49.72	10425646.0
2007-12-19 14:00:00	QQQ	ETF	49.719	50.18	49.688	50.08	27569036.0
2007-12-19 15:00:00	QQQ	ETF	50.08	50.16	49.91	49.92	19982139.0
2007-12-19 16:00:00	QQQ	ETF	49.93	50.1	49.88	49.94	11995001.0
2007-12-19 17:00:00	QQQ	ETF	50.09	50.2	50.08	50.16	805358.0
2007-12-19 18:00:00	QQQ	ETF	50.17	50.2	50.16	50.17	28899.0
2007-12-19 19:00:00	QQQ	ETF	50.19	50.2	50.18	50.19	31580.0
2007-12-19 06:00:00	IWM	ETF	75.09	75.09	75.09	75.09	5000.0
2007-12-19 07:00:00	IWM	ETF	75.0	75.2	74.79	74.99	231800.0
2007-12-19 08:00:00	IWM	ETF	74.93	75.28	74.92	75.15	1310700.0
2007-12-19 09:00:00	IWM	ETF	75.12	75.45	74.95	75.36	8875878.0
2007-12-19 10:00:00	IWM	ETF	75.37	75.62	75.14	75.44	14581129.0
2007-12-19 11:00:00	IWM	ETF	75.44	75.48	74.88	74.99	13288616.0
2007-12-19 12:00:00	IWM	ETF	74.99	75.29	74.96	75.14	7048560.0
2007-12-19 13:00:00	IWM	ETF	75.14	75.15	74.72	74.86	6700215.0
2007-12-19 14:00:00	IWM	ETF	74.86	75.69	74.81	75.52	14442238.0
2007-12-19 15:00:00	IWM	ETF	75.51	75.73	75.4	75.48	15704490.0
2007-12-19 16:00:00	IWM	ETF	75.47	75.7	75.44	75.65	4089100.0
2007-12-19 17:00:00	IWM	ETF	75.62	75.76	75.58	75.76	111000.0
2007-12-19 18:00:00	IWM	ETF	75.68	75.77	75.68	75.74	11100.0
2007-12-19 19:00:00	IWM	ETF	75.79	75.79	75.79	75.79	500.0
2007-12-19 07:00:00	DIA	ETF	132.03	132.32	132.01	132.19	2100.0
2007-12-19 08:00:00	DIA	ETF	132.21	132.58	132.21	132.58	19900.0
2007-12-19 09:00:00	DIA	ETF	132.57	132.92	132.37	132.82	1468174.0
2007-12-19 10:00:00	DIA	ETF	132.85	133.12	132.66	132.82	2026901.0

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

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