PREVIEW / etf_1hour / 2007-01-08

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-01-08.parquet
  size:    59 KB
  rows:    1,835

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-01-08 04:00:00	SPY	ETF	140.86	140.86	140.86	140.86	2000.0
2007-01-08 07:00:00	SPY	ETF	140.75	140.92	140.7	140.9	270200.0
2007-01-08 08:00:00	SPY	ETF	140.9	140.96	140.74	140.9	571700.0
2007-01-08 09:00:00	SPY	ETF	140.9	140.94	140.43	140.54	11207500.0
2007-01-08 10:00:00	SPY	ETF	140.54	140.8503	140.25	140.44	17081100.0
2007-01-08 11:00:00	SPY	ETF	140.44	140.9	140.39	140.8	8964100.0
2007-01-08 12:00:00	SPY	ETF	140.79	140.82	140.54	140.68	3316600.0
2007-01-08 13:00:00	SPY	ETF	140.68	141.1399	140.55	141.07	7513500.0
2007-01-08 14:00:00	SPY	ETF	141.06	141.31	140.99	141.0	7527600.0
2007-01-08 15:00:00	SPY	ETF	141.0	141.41	140.97	141.17	8681000.0
2007-01-08 16:00:00	SPY	ETF	141.15	141.24	140.2035	141.24	2693800.0
2007-01-08 17:00:00	SPY	ETF	141.25	141.27	141.22	141.25	3700.0
2007-01-08 18:00:00	SPY	ETF	141.21	141.24	141.2	141.24	900.0
2007-01-08 19:00:00	SPY	ETF	141.23	141.32	141.23	141.31	20100.0
2007-01-08 07:00:00	QQQ	ETF	43.81	43.84	43.77	43.84	193900.0
2007-01-08 08:00:00	QQQ	ETF	43.83	43.91	43.8	43.9	2235614.0
2007-01-08 09:00:00	QQQ	ETF	43.9	44.03	43.72	43.88	22377834.0
2007-01-08 10:00:00	QQQ	ETF	43.87	43.99	43.64	43.84	22657200.0
2007-01-08 11:00:00	QQQ	ETF	43.84	44.06	43.83	43.98	10282500.0
2007-01-08 12:00:00	QQQ	ETF	43.98	44.0	43.8	43.91	6274700.0
2007-01-08 13:00:00	QQQ	ETF	43.91	44.08	43.82	44.02	7668400.0
2007-01-08 14:00:00	QQQ	ETF	44.02	44.12	43.92	43.92	9611700.0
2007-01-08 15:00:00	QQQ	ETF	43.92	44.07	43.89	43.9	11577500.0
2007-01-08 16:00:00	QQQ	ETF	43.88	43.94	43.85	43.94	4494796.0
2007-01-08 17:00:00	QQQ	ETF	43.94	43.94	43.92	43.93	12585.0
2007-01-08 18:00:00	QQQ	ETF	43.92	43.92	43.91	43.91	23025.0
2007-01-08 19:00:00	QQQ	ETF	43.93	43.94	43.92	43.93	22169.0
2007-01-08 08:00:00	IWM	ETF	76.91	77.05	76.73	77.02	286600.0
2007-01-08 09:00:00	IWM	ETF	77.02	77.06	76.49	76.58	10212600.0
2007-01-08 10:00:00	IWM	ETF	76.58	76.85	76.23	76.56	14965300.0
2007-01-08 11:00:00	IWM	ETF	76.55	77.0	76.53	76.94	3974800.0
2007-01-08 12:00:00	IWM	ETF	76.93	76.96	76.65	76.82	2310200.0
2007-01-08 13:00:00	IWM	ETF	76.82	77.18	76.71	77.12	3465300.0
2007-01-08 14:00:00	IWM	ETF	77.13	77.26	77.04	77.06	3548600.0
2007-01-08 15:00:00	IWM	ETF	77.05	77.3	77.02	77.06	5127900.0
2007-01-08 16:00:00	IWM	ETF	77.05	77.05	76.43	77.04	1432800.0
2007-01-08 17:00:00	IWM	ETF	77.01	77.01	77.01	77.01	6000.0
2007-01-08 18:00:00	IWM	ETF	77.01	77.01	77.01	77.01	100.0
2007-01-08 19:00:00	IWM	ETF	77.02	77.02	77.02	77.02	500.0
2007-01-08 07:00:00	DIA	ETF	123.99	123.99	123.99	123.99	200.0
2007-01-08 08:00:00	DIA	ETF	123.96	123.97	123.91	123.91	12400.0
2007-01-08 09:00:00	DIA	ETF	123.95	123.95	123.41	123.52	1302300.0
2007-01-08 10:00:00	DIA	ETF	123.5	123.71	123.25	123.42	1579000.0
2007-01-08 11:00:00	DIA	ETF	123.42	123.85	123.38	123.76	1399500.0
2007-01-08 12:00:00	DIA	ETF	123.74	123.83	123.57	123.73	512800.0
2007-01-08 13:00:00	DIA	ETF	123.73	124.32	123.601	124.07	886300.0
2007-01-08 14:00:00	DIA	ETF	124.07	124.22	123.99	124.02	707800.0
2007-01-08 15:00:00	DIA	ETF	124.01	124.39	123.99	124.18	1529700.0
2007-01-08 16:00:00	DIA	ETF	124.14	124.21	124.115	124.13	118700.0
2007-01-08 07:00:00	GLD	ETF	60.18	60.4	60.18	60.4	1500.0

> showing 50 of 1,835 rows — these rows as CSV

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