PREVIEW / etf_1hour / 2007-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-11.parquet
  size:    78 KB
  rows:    2,636

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-06-11 05:00:00	SPY	ETF	150.86	150.98	150.86	150.98	3300.0
2007-06-11 06:00:00	SPY	ETF	151.08	151.08	151.01	151.04	36500.0
2007-06-11 07:00:00	SPY	ETF	151.0	151.0	150.79	150.94	81700.0
2007-06-11 08:00:00	SPY	ETF	150.93	151.29	150.78	151.09	1998300.0
2007-06-11 09:00:00	SPY	ETF	151.21	151.42	149.6008	151.26	16393540.0
2007-06-11 10:00:00	SPY	ETF	151.26	151.28	150.7	151.07	20086019.0
2007-06-11 11:00:00	SPY	ETF	151.06	151.56	150.99	151.51	13907219.0
2007-06-11 12:00:00	SPY	ETF	151.51	151.73	150.9	151.65	8741400.0
2007-06-11 13:00:00	SPY	ETF	151.64	151.95	151.6	151.63	9394447.0
2007-06-11 14:00:00	SPY	ETF	151.64	151.93	151.27	151.68	12057660.0
2007-06-11 15:00:00	SPY	ETF	151.68	151.81	151.18	151.3	15901884.0
2007-06-11 16:00:00	SPY	ETF	151.31	151.44	151.29	151.38	2092000.0
2007-06-11 17:00:00	SPY	ETF	151.38	151.41	151.31	151.34	153900.0
2007-06-11 18:00:00	SPY	ETF	151.34	151.35	151.32	151.32	476900.0
2007-06-11 19:00:00	SPY	ETF	151.3	151.33	151.3	151.32	3300.0
2007-06-11 06:00:00	QQQ	ETF	46.9	46.9	46.9	46.9	2000.0
2007-06-11 07:00:00	QQQ	ETF	46.87	46.87	46.82	46.85	88769.0
2007-06-11 08:00:00	QQQ	ETF	46.86	46.97	46.86	46.94	865667.0
2007-06-11 09:00:00	QQQ	ETF	46.93	47.08	46.83	47.0095	14474210.0
2007-06-11 10:00:00	QQQ	ETF	47.0	47.02	46.81	46.91	17594530.0
2007-06-11 11:00:00	QQQ	ETF	46.91	47.05	46.86	47.01	10173331.0
2007-06-11 12:00:00	QQQ	ETF	47.01	47.15	46.93	47.12	8990316.0
2007-06-11 13:00:00	QQQ	ETF	47.12	47.19	47.04	47.0597	12014786.0
2007-06-11 14:00:00	QQQ	ETF	47.0599	47.14	46.94	46.97	12004637.0
2007-06-11 15:00:00	QQQ	ETF	46.97	47.01	46.76	46.82	16685016.0
2007-06-11 16:00:00	QQQ	ETF	46.82	46.89	46.8	46.85	2222575.0
2007-06-11 17:00:00	QQQ	ETF	46.84	47.14	46.8	46.85	77376.0
2007-06-11 18:00:00	QQQ	ETF	46.87	46.87	46.85	46.87	13174.0
2007-06-11 19:00:00	QQQ	ETF	46.87	46.87	46.84	46.86	10300.0
2007-06-11 08:00:00	IWM	ETF	82.9	83.04	82.9	82.99	824600.0
2007-06-11 09:00:00	IWM	ETF	82.99	83.0	82.44	82.94	9704900.0
2007-06-11 10:00:00	IWM	ETF	82.92	82.92	82.33	82.6	12575800.0
2007-06-11 11:00:00	IWM	ETF	82.6	82.9	82.4	82.86	6808674.0
2007-06-11 12:00:00	IWM	ETF	82.86	83.18	82.74	83.11	5612134.0
2007-06-11 13:00:00	IWM	ETF	83.11	83.27	83.0	83.03	5663000.0
2007-06-11 14:00:00	IWM	ETF	83.02	83.18	82.85	82.91	6716500.0
2007-06-11 15:00:00	IWM	ETF	82.9	83.06	82.64	82.85	9100175.0
2007-06-11 16:00:00	IWM	ETF	82.85	82.92	82.8	82.85	1344100.0
2007-06-11 17:00:00	IWM	ETF	82.87	82.87	82.82	82.82	1200.0
2007-06-11 18:00:00	IWM	ETF	82.82	82.82	82.82	82.82	82600.0
2007-06-11 07:00:00	DIA	ETF	134.04	134.06	134.04	134.06	2900.0
2007-06-11 08:00:00	DIA	ETF	134.1	134.31	134.1	134.18	21600.0
2007-06-11 09:00:00	DIA	ETF	134.16	134.47	133.79	134.33	2407300.0
2007-06-11 10:00:00	DIA	ETF	134.34	134.37	133.77	134.09	1996500.0
2007-06-11 11:00:00	DIA	ETF	134.1	134.4	134.01	134.35	951000.0
2007-06-11 12:00:00	DIA	ETF	134.35	134.5	134.22	134.41	598400.0
2007-06-11 13:00:00	DIA	ETF	134.42	134.72	134.35	134.45	1070893.0
2007-06-11 14:00:00	DIA	ETF	134.44	134.75	134.43	134.54	1199700.0
2007-06-11 15:00:00	DIA	ETF	134.53	134.61	134.11	134.19	1863900.0
2007-06-11 16:00:00	DIA	ETF	134.21	134.32	134.21	134.32	68400.0

> showing 50 of 2,636 rows — these rows as CSV

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