PREVIEW / etf_1hour / 2007-03-07

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-07.parquet
  size:    68 KB
  rows:    2,149

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-03-07 04:00:00	SPY	ETF	139.56	139.56	139.56	139.56	1600.0
2007-03-07 06:00:00	SPY	ETF	139.61	139.61	139.39	139.52	27900.0
2007-03-07 07:00:00	SPY	ETF	139.5	139.64	139.42	139.45	495200.0
2007-03-07 08:00:00	SPY	ETF	139.44	139.67	139.43	139.62	1374800.0
2007-03-07 09:00:00	SPY	ETF	139.6	140.05	139.32	139.73	14788500.0
2007-03-07 10:00:00	SPY	ETF	139.73	140.1	139.6	139.72	15567900.0
2007-03-07 11:00:00	SPY	ETF	139.72	139.74	139.4	139.7	15933300.0
2007-03-07 12:00:00	SPY	ETF	139.7099	140.04	139.63	139.94	8150900.0
2007-03-07 13:00:00	SPY	ETF	139.93	140.46	139.81	140.33	13199200.0
2007-03-07 14:00:00	SPY	ETF	140.33	140.36	140.0	140.15	18577800.0
2007-03-07 15:00:00	SPY	ETF	140.14	140.37	139.45	139.46	22106900.0
2007-03-07 16:00:00	SPY	ETF	139.48	139.58	139.43	139.5	1857400.0
2007-03-07 17:00:00	SPY	ETF	139.47	139.54	139.47	139.54	64900.0
2007-03-07 18:00:00	SPY	ETF	139.54	139.54	139.28	139.35	73700.0
2007-03-07 19:00:00	SPY	ETF	139.35	139.58	139.35	139.53	26100.0
2007-03-07 09:00:00	QQQ	ETF	42.86	42.96	42.71	42.77	18418188.0
2007-03-07 10:00:00	QQQ	ETF	42.77	42.89	42.72	42.75	15707800.0
2007-03-07 11:00:00	QQQ	ETF	42.74	42.8	42.65	42.78	13174100.0
2007-03-07 12:00:00	QQQ	ETF	42.77	42.89	42.66	42.83	13860000.0
2007-03-07 13:00:00	QQQ	ETF	42.83	42.98	42.79	42.92	10167700.0
2007-03-07 14:00:00	QQQ	ETF	42.92	42.93	42.79	42.87	12109600.0
2007-03-07 15:00:00	QQQ	ETF	42.87	42.94	42.66	42.67	19472600.0
2007-03-07 16:00:00	QQQ	ETF	42.67	42.71	42.64	42.67	6226680.0
2007-03-07 17:00:00	QQQ	ETF	42.67	42.68	42.65	42.67	59235.0
2007-03-07 18:00:00	QQQ	ETF	42.66	42.68	42.61	42.62	66024.0
2007-03-07 19:00:00	QQQ	ETF	42.61	42.68	42.61	42.66	21175.0
2007-03-07 07:00:00	IWM	ETF	77.0	77.0	76.99	76.99	300.0
2007-03-07 08:00:00	IWM	ETF	77.12	77.3	77.12	77.22	75000.0
2007-03-07 09:00:00	IWM	ETF	77.2	77.56	77.04	77.23	8035000.0
2007-03-07 10:00:00	IWM	ETF	77.2203	77.44	77.12	77.22	11245100.0
2007-03-07 11:00:00	IWM	ETF	77.2	77.21	76.8	77.1	10422900.0
2007-03-07 12:00:00	IWM	ETF	77.1	77.36	77.03	77.27	2455600.0
2007-03-07 13:00:00	IWM	ETF	77.28	77.62	77.19	77.49	4018100.0
2007-03-07 14:00:00	IWM	ETF	77.5	77.57	77.27	77.41	7127700.0
2007-03-07 15:00:00	IWM	ETF	77.41	77.59	76.99	77.0	10537100.0
2007-03-07 16:00:00	IWM	ETF	77.0	77.2996	76.86	76.91	424100.0
2007-03-07 18:00:00	IWM	ETF	76.87	76.87	76.7	76.7	10700.0
2007-03-07 19:00:00	IWM	ETF	76.72	76.86	76.72	76.86	3700.0
2007-03-07 08:00:00	DIA	ETF	121.91	121.95	121.83	121.9	22500.0
2007-03-07 09:00:00	DIA	ETF	121.95	122.39	121.87	122.17	641900.0
2007-03-07 10:00:00	DIA	ETF	122.17	122.45	122.07	122.14	1783300.0
2007-03-07 11:00:00	DIA	ETF	122.13	122.13	121.87	122.09	1149400.0
2007-03-07 12:00:00	DIA	ETF	122.09	122.33	122.04	122.29	534800.0
2007-03-07 13:00:00	DIA	ETF	122.28	122.6	122.17	122.5	663000.0
2007-03-07 14:00:00	DIA	ETF	122.49	122.59	122.25	122.42	817100.0
2007-03-07 15:00:00	DIA	ETF	122.39	122.57	121.92	121.97	1237700.0
2007-03-07 16:00:00	DIA	ETF	121.97	122.06	121.95	122.05	31500.0
2007-03-07 17:00:00	DIA	ETF	122.04	122.04	122.04	122.04	100.0
2007-03-07 18:00:00	DIA	ETF	122.0	122.0	121.95	121.97	3500.0
2007-03-07 19:00:00	DIA	ETF	121.95	121.97	121.95	121.97	1900.0

> showing 50 of 2,149 rows — these rows as CSV

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