PREVIEW / etf_1hour / 2007-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-14.parquet
  size:    77 KB
  rows:    2,628

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-14 06:00:00	SPY	ETF	151.95	152.0	151.91	151.99	21200.0
2007-06-14 07:00:00	SPY	ETF	151.92	152.3	151.91	152.24	361500.0
2007-06-14 08:00:00	SPY	ETF	152.28	152.37	151.85	152.03	8008900.0
2007-06-14 09:00:00	SPY	ETF	152.06	152.81	151.98	152.77	25103254.0
2007-06-14 10:00:00	SPY	ETF	152.77	153.12	152.58	152.79	22017849.0
2007-06-14 11:00:00	SPY	ETF	152.79	152.88	152.31	152.47	21433222.0
2007-06-14 12:00:00	SPY	ETF	152.47	152.85	152.44	152.72	11115825.0
2007-06-14 13:00:00	SPY	ETF	152.73	152.88	152.57	152.73	17488631.0
2007-06-14 14:00:00	SPY	ETF	152.73	152.91	152.58	152.78	12485438.0
2007-06-14 15:00:00	SPY	ETF	152.79	152.99	152.64	152.71	21378912.0
2007-06-14 16:00:00	SPY	ETF	152.73	152.89	152.69	152.79	3784900.0
2007-06-14 17:00:00	SPY	ETF	152.81	152.88	152.63	152.63	1566300.0
2007-06-14 18:00:00	SPY	ETF	152.84	152.84	152.77	152.79	253500.0
2007-06-14 19:00:00	SPY	ETF	152.78	152.83	152.77	152.79	128200.0
2007-06-14 04:00:00	QQQ	ETF	47.1	47.15	47.1	47.15	1500.0
2007-06-14 07:00:00	QQQ	ETF	47.1	47.19	47.07	47.16	758575.0
2007-06-14 08:00:00	QQQ	ETF	47.16	47.21	47.02	47.12	4460575.0
2007-06-14 09:00:00	QQQ	ETF	47.12	47.42	47.09	47.39	17218872.0
2007-06-14 10:00:00	QQQ	ETF	47.39	47.49	47.32	47.3605	21439896.0
2007-06-14 11:00:00	QQQ	ETF	47.3685	47.4	47.22	47.26	12214657.0
2007-06-14 12:00:00	QQQ	ETF	47.26	47.37	47.25	47.33	9220957.0
2007-06-14 13:00:00	QQQ	ETF	47.32	47.42	47.3	47.375	6813063.0
2007-06-14 14:00:00	QQQ	ETF	47.38	47.47	47.29	47.41	11986378.0
2007-06-14 15:00:00	QQQ	ETF	47.41	47.46	47.32	47.36	12954453.0
2007-06-14 16:00:00	QQQ	ETF	47.35	47.38	47.308	47.35	2996472.0
2007-06-14 17:00:00	QQQ	ETF	47.35	47.38	47.34	47.38	24999.0
2007-06-14 18:00:00	QQQ	ETF	47.37	47.37	47.34	47.34	14562.0
2007-06-14 19:00:00	QQQ	ETF	47.36	47.36	47.34	47.34	3800.0
2007-06-14 07:00:00	IWM	ETF	82.3	82.84	82.3	82.81	156900.0
2007-06-14 08:00:00	IWM	ETF	82.74	82.92	82.6	82.76	1440800.0
2007-06-14 09:00:00	IWM	ETF	82.8	83.51	82.75	83.48	12772205.0
2007-06-14 10:00:00	IWM	ETF	83.48	83.67	83.24	83.4	12012900.0
2007-06-14 11:00:00	IWM	ETF	83.4	83.45	83.05	83.15	9395867.0
2007-06-14 12:00:00	IWM	ETF	83.15	83.37	83.1	83.3	4504897.0
2007-06-14 13:00:00	IWM	ETF	83.29	83.38	83.12	83.21	4815008.0
2007-06-14 14:00:00	IWM	ETF	83.2	83.37	82.17	83.18	6437600.0
2007-06-14 15:00:00	IWM	ETF	83.18	83.33	83.07	83.2	11652550.0
2007-06-14 16:00:00	IWM	ETF	83.2	83.34	83.18	83.27	1928100.0
2007-06-14 17:00:00	IWM	ETF	83.28	83.34	83.22	83.34	3720100.0
2007-06-14 18:00:00	IWM	ETF	83.29	83.29	83.29	83.29	100.0
2007-06-14 07:00:00	DIA	ETF	135.12	135.2	135.12	135.2	5400.0
2007-06-14 08:00:00	DIA	ETF	135.18	135.23	134.87	134.9	210700.0
2007-06-14 09:00:00	DIA	ETF	134.93	135.58	134.85	135.54	1908720.0
2007-06-14 10:00:00	DIA	ETF	135.54	135.8	135.41	135.49	2411300.0
2007-06-14 11:00:00	DIA	ETF	135.5	135.6	135.23	135.36	1936999.0
2007-06-14 12:00:00	DIA	ETF	135.37	136.56	135.35	135.55	1214200.0
2007-06-14 13:00:00	DIA	ETF	135.55	135.71	135.42	135.6	940300.0
2007-06-14 14:00:00	DIA	ETF	135.61	135.81	135.48	135.72	2208750.0
2007-06-14 15:00:00	DIA	ETF	135.72	135.87	135.55	135.58	1837000.0
2007-06-14 16:00:00	DIA	ETF	135.6	135.72	135.57	135.7	73300.0

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

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