PREVIEW / etf_1hour / 2007-11-06

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-06.parquet
  size:    90 KB
  rows:    3,001

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-06 05:00:00	SPY	ETF	150.47	150.47	150.47	150.47	3000.0
2007-11-06 06:00:00	SPY	ETF	150.51	150.8	150.49	150.77	107000.0
2007-11-06 07:00:00	SPY	ETF	150.75	151.0	150.7	150.82	868500.0
2007-11-06 08:00:00	SPY	ETF	150.82	150.91	150.2	150.7	2595400.0
2007-11-06 09:00:00	SPY	ETF	150.71	151.14	150.71	150.96	17465853.0
2007-11-06 10:00:00	SPY	ETF	150.96	151.2	149.9	150.2	32937193.0
2007-11-06 11:00:00	SPY	ETF	150.19	150.7	150.12	150.49	21015775.0
2007-11-06 12:00:00	SPY	ETF	150.49	151.0	150.0	150.82	16192302.0
2007-11-06 13:00:00	SPY	ETF	150.82	151.33	150.81	151.03	25497495.0
2007-11-06 14:00:00	SPY	ETF	151.025	151.21	150.86	151.05	18497542.0
2007-11-06 15:00:00	SPY	ETF	151.05	152.1	150.97	152.09	33353589.0
2007-11-06 16:00:00	SPY	ETF	152.1	152.11	150.27	151.93	6516500.0
2007-11-06 17:00:00	SPY	ETF	151.91	152.03	151.82	151.92	519500.0
2007-11-06 18:00:00	SPY	ETF	151.92	151.92	151.7	151.74	145900.0
2007-11-06 19:00:00	SPY	ETF	151.75	151.81	151.72	151.76	38200.0
2007-11-06 04:00:00	QQQ	ETF	54.25	54.25	54.25	54.25	100.0
2007-11-06 06:00:00	QQQ	ETF	54.38	54.39	54.38	54.39	37700.0
2007-11-06 07:00:00	QQQ	ETF	54.38	54.44	54.35	54.42	324016.0
2007-11-06 08:00:00	QQQ	ETF	54.42	54.47	54.36	54.36	922964.0
2007-11-06 09:00:00	QQQ	ETF	54.36	54.43	54.22	54.2977	9717946.0
2007-11-06 10:00:00	QQQ	ETF	54.29	54.4	53.78	53.95	29441822.0
2007-11-06 11:00:00	QQQ	ETF	53.9526	54.1	53.86	54.02	17807083.0
2007-11-06 12:00:00	QQQ	ETF	54.01	54.16	53.93	54.105	10714919.0
2007-11-06 13:00:00	QQQ	ETF	54.11	54.36	54.09	54.23	15492082.0
2007-11-06 14:00:00	QQQ	ETF	54.24	54.28	54.11	54.24	14764400.0
2007-11-06 15:00:00	QQQ	ETF	54.24	54.69	54.19	54.69	26328347.0
2007-11-06 16:00:00	QQQ	ETF	54.69	54.69	43.65	54.6	6201857.0
2007-11-06 17:00:00	QQQ	ETF	54.61	54.64	54.58	54.64	95479.0
2007-11-06 18:00:00	QQQ	ETF	54.6	54.62	54.57	54.6	21119.0
2007-11-06 19:00:00	QQQ	ETF	54.6	54.63	54.59	54.6	14817.0
2007-11-06 06:00:00	IWM	ETF	78.76	78.89	78.76	78.89	15000.0
2007-11-06 07:00:00	IWM	ETF	78.99	79.17	78.95	79.0	132600.0
2007-11-06 08:00:00	IWM	ETF	78.97	79.1	78.9	78.9	132700.0
2007-11-06 09:00:00	IWM	ETF	79.0	79.07	78.51	78.66	7538569.0
2007-11-06 10:00:00	IWM	ETF	78.65	78.79	78.03	78.26	12723056.0
2007-11-06 11:00:00	IWM	ETF	78.26	78.47	78.15	78.32	8897756.0
2007-11-06 12:00:00	IWM	ETF	78.32	78.58	78.17	78.53	5496500.0
2007-11-06 13:00:00	IWM	ETF	78.53	79.03	78.52	78.81	8217403.0
2007-11-06 14:00:00	IWM	ETF	78.81	79.02	78.65	78.96	8206069.0
2007-11-06 15:00:00	IWM	ETF	78.96	79.95	78.65	79.94	23635282.0
2007-11-06 16:00:00	IWM	ETF	79.93	80.0	78.73	79.9	20015000.0
2007-11-06 17:00:00	IWM	ETF	79.88	79.91	79.88	79.89	900.0
2007-11-06 18:00:00	IWM	ETF	79.93	79.93	79.86	79.86	13600.0
2007-11-06 07:00:00	DIA	ETF	135.86	135.86	135.82	135.84	4400.0
2007-11-06 08:00:00	DIA	ETF	135.83	135.87	135.73	135.73	14500.0
2007-11-06 09:00:00	DIA	ETF	135.8	136.0	135.6	135.82	821616.0
2007-11-06 10:00:00	DIA	ETF	135.82	136.01	135.05	135.24	2062300.0
2007-11-06 11:00:00	DIA	ETF	135.24	135.6	135.13	135.44	1354100.0
2007-11-06 12:00:00	DIA	ETF	135.41	135.73	135.32	135.66	1311900.0
2007-11-06 13:00:00	DIA	ETF	135.69	136.09	135.64	135.85	1297800.0

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

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