PREVIEW / etf_1hour / 2007-11-29

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-11-29.parquet
  size:    92 KB
  rows:    3,076

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-29 04:00:00	SPY	ETF	146.62	146.62	146.62	146.62	500.0
2007-11-29 05:00:00	SPY	ETF	146.54	146.9	146.54	146.81	29900.0
2007-11-29 06:00:00	SPY	ETF	146.5	146.71	146.31	146.53	81700.0
2007-11-29 07:00:00	SPY	ETF	146.45	146.96	146.27	146.89	845600.0
2007-11-29 08:00:00	SPY	ETF	146.9	147.0	146.31	146.82	3857000.0
2007-11-29 09:00:00	SPY	ETF	146.83	147.15	146.27	146.62	27579611.0
2007-11-29 10:00:00	SPY	ETF	146.62	146.92	146.1	146.83	29713315.0
2007-11-29 11:00:00	SPY	ETF	146.84	147.72	146.72	147.46	33164078.0
2007-11-29 12:00:00	SPY	ETF	147.46	147.63	146.83	146.89	18595531.0
2007-11-29 13:00:00	SPY	ETF	146.89	147.08	146.3	146.89	24606289.0
2007-11-29 14:00:00	SPY	ETF	146.88	147.32	146.65	147.19	19329400.0
2007-11-29 15:00:00	SPY	ETF	147.2	147.5	146.88	147.27	29560373.0
2007-11-29 16:00:00	SPY	ETF	147.22	147.72	146.6663	147.1	8659200.0
2007-11-29 17:00:00	SPY	ETF	147.15	147.18	146.93	147.0	675200.0
2007-11-29 18:00:00	SPY	ETF	147.0	147.06	146.81	147.06	38000.0
2007-11-29 19:00:00	SPY	ETF	147.04	148.2	146.99	148.04	209000.0
2007-11-29 06:00:00	QQQ	ETF	51.36	51.43	51.35	51.4	104600.0
2007-11-29 07:00:00	QQQ	ETF	51.33	51.46	51.28	51.38	147599.0
2007-11-29 08:00:00	QQQ	ETF	51.39	51.54	51.2	51.35	1499956.0
2007-11-29 09:00:00	QQQ	ETF	51.35	51.7	51.2	51.38	27381140.0
2007-11-29 10:00:00	QQQ	ETF	51.38	51.51	51.22	51.47	24256787.0
2007-11-29 11:00:00	QQQ	ETF	51.46	51.78	51.43	51.67	23822434.0
2007-11-29 12:00:00	QQQ	ETF	51.67	51.7299	51.43	51.45	15956336.0
2007-11-29 13:00:00	QQQ	ETF	51.45	51.56	51.23	51.5	24010205.0
2007-11-29 14:00:00	QQQ	ETF	51.5	51.75	51.45	51.74	26126567.0
2007-11-29 15:00:00	QQQ	ETF	51.74	51.89	51.56	51.73	21670177.0
2007-11-29 16:00:00	QQQ	ETF	51.73	51.73	51.44	51.47	5759664.0
2007-11-29 17:00:00	QQQ	ETF	51.47	51.7	51.45	51.48	881718.0
2007-11-29 18:00:00	QQQ	ETF	51.47	51.48	51.45	51.48	33075.0
2007-11-29 19:00:00	QQQ	ETF	51.48	51.81	51.48	51.8	436999.0
2007-11-29 04:00:00	IWM	ETF	76.93	76.93	76.93	76.93	100.0
2007-11-29 07:00:00	IWM	ETF	76.62	76.89	76.56	76.89	140100.0
2007-11-29 08:00:00	IWM	ETF	76.88	76.98	76.6	76.76	761500.0
2007-11-29 09:00:00	IWM	ETF	76.74	76.86	76.33	76.56	7591964.0
2007-11-29 10:00:00	IWM	ETF	76.57	76.71	76.13	76.55	10960500.0
2007-11-29 11:00:00	IWM	ETF	76.54	76.96	76.46	76.71	7423900.0
2007-11-29 12:00:00	IWM	ETF	76.71	76.83	76.19	76.27	7573400.0
2007-11-29 13:00:00	IWM	ETF	76.27	76.39	75.91	76.13	7152000.0
2007-11-29 14:00:00	IWM	ETF	76.12	76.45	75.96	76.38	5320800.0
2007-11-29 15:00:00	IWM	ETF	76.39	76.53	76.16	76.38	8841100.0
2007-11-29 16:00:00	IWM	ETF	76.39	76.42	76.03	76.13	1631700.0
2007-11-29 17:00:00	IWM	ETF	76.21	76.21	76.18	76.18	1000.0
2007-11-29 18:00:00	IWM	ETF	76.15	76.15	76.15	76.15	500.0
2007-11-29 19:00:00	IWM	ETF	76.24	76.77	76.24	76.59	19900.0
2007-11-29 07:00:00	DIA	ETF	132.41	132.85	132.3	132.85	65600.0
2007-11-29 08:00:00	DIA	ETF	132.78	132.82	132.42	132.68	47600.0
2007-11-29 09:00:00	DIA	ETF	132.63	132.92	132.31	132.56	3029689.0
2007-11-29 10:00:00	DIA	ETF	132.54	132.83	132.18	132.74	2206900.0
2007-11-29 11:00:00	DIA	ETF	132.74	133.48	132.66	133.28	1611800.0
2007-11-29 12:00:00	DIA	ETF	133.28	133.44	132.71	132.74	2724600.0

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

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