PREVIEW / etf_1hour / 2007-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-07.parquet
  size:    97 KB
  rows:    3,215

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-11-07 04:00:00	SPY	ETF	151.33	151.4	150.2	150.44	27300.0
2007-11-07 05:00:00	SPY	ETF	150.24	150.58	150.24	150.58	61400.0
2007-11-07 06:00:00	SPY	ETF	150.54	150.63	150.27	150.29	225800.0
2007-11-07 07:00:00	SPY	ETF	150.24	150.54	149.84	150.14	2991900.0
2007-11-07 08:00:00	SPY	ETF	150.17	151.45	149.92	150.63	9259700.0
2007-11-07 09:00:00	SPY	ETF	150.63	151.75	150.31	150.72	20899478.0
2007-11-07 10:00:00	SPY	ETF	150.71	151.13	150.05	150.2	32194989.0
2007-11-07 11:00:00	SPY	ETF	150.19	150.62	150.03	150.55	17804965.0
2007-11-07 12:00:00	SPY	ETF	150.55	150.5501	149.37	149.52	32271440.0
2007-11-07 13:00:00	SPY	ETF	149.51	149.74	148.41	149.18	56101724.0
2007-11-07 14:00:00	SPY	ETF	149.15	150.29	148.58	149.11	41667431.0
2007-11-07 15:00:00	SPY	ETF	149.11	152.1072	147.55	147.58	71690768.0
2007-11-07 16:00:00	SPY	ETF	147.67	149.15	147.1	147.13	9707000.0
2007-11-07 17:00:00	SPY	ETF	147.13	148.0174	146.35	147.0	3195100.0
2007-11-07 18:00:00	SPY	ETF	146.9	147.91	146.85	146.91	817200.0
2007-11-07 19:00:00	SPY	ETF	146.88	147.21	146.88	147.04	61600.0
2007-11-07 04:00:00	QQQ	ETF	54.35	54.35	54.12	54.12	6800.0
2007-11-07 05:00:00	QQQ	ETF	54.19	54.19	54.19	54.19	10000.0
2007-11-07 06:00:00	QQQ	ETF	54.24	54.24	54.15	54.19	22300.0
2007-11-07 07:00:00	QQQ	ETF	54.14	54.21	54.04	54.09	755670.0
2007-11-07 08:00:00	QQQ	ETF	54.12	54.32	54.09	54.29	2273077.0
2007-11-07 09:00:00	QQQ	ETF	54.29	54.41	54.19	54.37	15214320.0
2007-11-07 10:00:00	QQQ	ETF	54.37	54.58	54.14	54.2	25232629.0
2007-11-07 11:00:00	QQQ	ETF	54.2	54.36	54.15	54.33	11219933.0
2007-11-07 12:00:00	QQQ	ETF	54.34	54.34	53.98	54.04	20720560.0
2007-11-07 13:00:00	QQQ	ETF	54.03	54.12	53.74	53.913	29292882.0
2007-11-07 14:00:00	QQQ	ETF	53.91	54.17	53.84	53.98	22973843.0
2007-11-07 15:00:00	QQQ	ETF	53.98	54.14	53.31	53.34	45121326.0
2007-11-07 16:00:00	QQQ	ETF	53.35	54.2445	52.85	52.86	19622186.0
2007-11-07 17:00:00	QQQ	ETF	52.87	53.1298	52.6	52.63	3910608.0
2007-11-07 18:00:00	QQQ	ETF	52.63	52.83	52.61	52.69	1479947.0
2007-11-07 19:00:00	QQQ	ETF	52.69	52.73	52.67	52.72	102107.0
2007-11-07 04:00:00	IWM	ETF	79.06	79.06	79.06	79.06	200.0
2007-11-07 06:00:00	IWM	ETF	79.06	79.06	78.76	78.81	30400.0
2007-11-07 07:00:00	IWM	ETF	78.73	78.9	78.53	78.7	305900.0
2007-11-07 08:00:00	IWM	ETF	78.71	79.05	78.7	79.05	709500.0
2007-11-07 09:00:00	IWM	ETF	79.05	79.12	78.75	78.92	9139722.0
2007-11-07 10:00:00	IWM	ETF	78.93	79.1	78.31	78.35	13927126.0
2007-11-07 11:00:00	IWM	ETF	78.35	78.65	78.26	78.54	9350109.0
2007-11-07 12:00:00	IWM	ETF	78.53	78.53	77.72	77.85	14827800.0
2007-11-07 13:00:00	IWM	ETF	77.85	78.21	77.4	77.98	17825321.0
2007-11-07 14:00:00	IWM	ETF	77.98	78.29	77.74	77.92	12557192.0
2007-11-07 15:00:00	IWM	ETF	77.92	78.22	77.17	77.25	27196602.0
2007-11-07 16:00:00	IWM	ETF	77.25	79.87	77.05	77.05	8063100.0
2007-11-07 17:00:00	IWM	ETF	77.08	77.8	76.6	76.8	572100.0
2007-11-07 18:00:00	IWM	ETF	76.85	77.0	76.85	76.96	114800.0
2007-11-07 19:00:00	IWM	ETF	76.92	77.0	76.85	77.0	17000.0
2007-11-07 06:00:00	DIA	ETF	133.3	133.3	133.3	133.3	300.0
2007-11-07 07:00:00	DIA	ETF	135.03	135.2	134.75	134.97	9200.0
2007-11-07 08:00:00	DIA	ETF	135.0	136.33	134.99	135.32	64000.0

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

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