PREVIEW / etf_1hour / 2007-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-06-01.parquet
  size:    36 KB
  rows:    1,019

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-01 04:00:00	SPY	ETF	153.7	153.7	153.7	153.7	200.0
2007-06-01 06:00:00	SPY	ETF	153.83	153.83	153.82	153.82	15500.0
2007-06-01 07:00:00	SPY	ETF	153.8	153.84	153.74	153.77	421700.0
2007-06-01 08:00:00	SPY	ETF	153.765	154.16	153.65	153.96	6861700.0
2007-06-01 09:00:00	SPY	ETF	153.97	154.19	153.85	154.08	17230217.0
2007-06-01 10:00:00	SPY	ETF	154.08	154.4	153.75	153.86	24465233.0
2007-06-01 11:00:00	SPY	ETF	153.86	154.11	153.82	153.95	10765634.0
2007-06-01 12:00:00	SPY	ETF	153.96	153.98	153.51	153.73	12937815.0
2007-06-01 13:00:00	SPY	ETF	153.73	154.0	153.63	153.9	9568513.0
2007-06-01 14:00:00	SPY	ETF	153.91	153.96	153.72	153.8	5686093.0
2007-06-01 15:00:00	SPY	ETF	153.81	153.98	153.52	153.96	14382914.0
2007-06-01 16:00:00	SPY	ETF	153.98	154.11	153.89	153.93	4144600.0
2007-06-01 17:00:00	SPY	ETF	153.96	153.98	153.93	153.98	41500.0
2007-06-01 18:00:00	SPY	ETF	153.98	153.98	153.97	153.98	5000.0
2007-06-01 19:00:00	SPY	ETF	153.97	153.97	153.88	153.88	38000.0
2007-06-01 04:00:00	QQQ	ETF	47.54	47.55	47.54	47.55	2842.0
2007-06-01 07:00:00	QQQ	ETF	47.57	47.58	47.54	47.57	100150.0
2007-06-01 08:00:00	QQQ	ETF	47.58	47.72	47.41	47.68	5746414.0
2007-06-01 09:00:00	QQQ	ETF	47.68	47.71	47.57	47.67	10673340.0
2007-06-01 10:00:00	QQQ	ETF	47.67	47.77	47.48	47.5497	24476482.0
2007-06-01 11:00:00	QQQ	ETF	47.5499	47.62	47.52	47.57	8082103.0
2007-06-01 12:00:00	QQQ	ETF	47.56	47.58	47.37	47.45	20354063.0
2007-06-01 13:00:00	QQQ	ETF	47.45	47.58	47.39	47.5401	8679146.0
2007-06-01 14:00:00	QQQ	ETF	47.54	47.58	47.45	47.55	14116029.0
2007-06-01 15:00:00	QQQ	ETF	47.54	47.56	47.42	47.43	24276058.0
2007-06-01 16:00:00	QQQ	ETF	47.43	47.5	47.42	47.5	8341436.0
2007-06-01 17:00:00	QQQ	ETF	47.48	47.49	47.47	47.48	17987.0
2007-06-01 18:00:00	QQQ	ETF	47.47	47.48	47.47	47.47	1160.0
2007-06-01 19:00:00	QQQ	ETF	47.47	47.47	47.4	47.44	31603.0
2007-06-01 08:00:00	IWM	ETF	84.36	85.17	84.2	84.57	2768800.0
2007-06-01 09:00:00	IWM	ETF	84.58	85.06	84.42	85.0	19469688.0
2007-06-01 10:00:00	IWM	ETF	85.0	85.17	84.69	84.78	13664286.0
2007-06-01 11:00:00	IWM	ETF	84.77	84.93	84.73	84.83	5950500.0
2007-06-01 12:00:00	IWM	ETF	84.82	84.84	84.41	84.62	8287600.0
2007-06-01 13:00:00	IWM	ETF	84.61	84.82	84.52	84.73	3603531.0
2007-06-01 14:00:00	IWM	ETF	84.73	84.77	84.51	84.65	3251634.0
2007-06-01 15:00:00	IWM	ETF	84.65	84.85	84.54	84.84	7857852.0
2007-06-01 16:00:00	IWM	ETF	84.8385	84.8385	84.63	84.67	922100.0
2007-06-01 18:00:00	IWM	ETF	84.63	84.63	84.63	84.63	300.0
2007-06-01 19:00:00	IWM	ETF	84.63	84.63	84.63	84.63	900.0
2007-06-01 08:00:00	DIA	ETF	136.53	136.8	136.42	136.62	261700.0
2007-06-01 09:00:00	DIA	ETF	136.66	136.76	136.51	136.6	795900.0
2007-06-01 10:00:00	DIA	ETF	136.59	136.84	136.31	136.39	2772600.0
2007-06-01 11:00:00	DIA	ETF	136.38	136.59	136.35	136.56	1631650.0
2007-06-01 12:00:00	DIA	ETF	136.56	136.57	136.16	136.32	1032900.0
2007-06-01 13:00:00	DIA	ETF	136.34	136.55	136.25	136.48	776000.0
2007-06-01 14:00:00	DIA	ETF	136.48	136.52	136.28	136.36	753699.0
2007-06-01 15:00:00	DIA	ETF	136.37	136.59	136.17	136.58	1464600.0
2007-06-01 16:00:00	DIA	ETF	136.58	136.66	136.56	136.61	27100.0
2007-06-01 17:00:00	DIA	ETF	136.61	136.61	136.61	136.61	100.0

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

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