PREVIEW / etf_1hour / 2006-11-15

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-11-15.parquet
  size:    58 KB
  rows:    1,801

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
2006-11-15 07:00:00	SPY	ETF	139.6	139.65	139.6	139.6	78700.0
2006-11-15 08:00:00	SPY	ETF	139.61	139.72	139.59	139.64	407700.0
2006-11-15 09:00:00	SPY	ETF	139.65	139.98	139.53	139.92	8557800.0
2006-11-15 10:00:00	SPY	ETF	139.92	139.94	139.68	139.8	7664400.0
2006-11-15 11:00:00	SPY	ETF	139.8	140.02	139.77	139.9	6268300.0
2006-11-15 12:00:00	SPY	ETF	139.8992	140.11	139.88	140.05	4055900.0
2006-11-15 13:00:00	SPY	ETF	140.04	140.31	140.01	140.23	6567500.0
2006-11-15 14:00:00	SPY	ETF	140.23	140.45	139.83	140.0	15666400.0
2006-11-15 15:00:00	SPY	ETF	140.0	140.16	139.88	139.97	10274600.0
2006-11-15 16:00:00	SPY	ETF	139.98	140.1	139.92	139.93	6130300.0
2006-11-15 17:00:00	SPY	ETF	139.93	139.95	139.9	139.95	17600.0
2006-11-15 18:00:00	SPY	ETF	139.94	139.94	139.87	139.89	8700.0
2006-11-15 19:00:00	SPY	ETF	139.83	139.9	139.83	139.9	3900.0
2006-11-15 09:00:00	QQQ	ETF	43.99	44.19	43.92	44.15	12660400.0
2006-11-15 10:00:00	QQQ	ETF	44.15	44.18	44.08	44.1	13381000.0
2006-11-15 11:00:00	QQQ	ETF	44.09	44.18	44.08	44.12	9501500.0
2006-11-15 12:00:00	QQQ	ETF	44.12	44.29	44.11	44.23	13199900.0
2006-11-15 13:00:00	QQQ	ETF	44.24	44.32	44.21	44.3	10106500.0
2006-11-15 14:00:00	QQQ	ETF	44.29	44.4	44.1	44.14	31517400.0
2006-11-15 15:00:00	QQQ	ETF	44.14	44.25	44.1	44.1	14626600.0
2006-11-15 07:00:00	IWM	ETF	78.0	78.0	78.0	78.0	5000.0
2006-11-15 08:00:00	IWM	ETF	78.05	78.22	78.05	78.21	557300.0
2006-11-15 09:00:00	IWM	ETF	78.21	78.5	77.98	78.44	6526200.0
2006-11-15 10:00:00	IWM	ETF	78.44	78.6	78.33	78.54	9847600.0
2006-11-15 11:00:00	IWM	ETF	78.53	78.68	78.47	78.62	4344100.0
2006-11-15 12:00:00	IWM	ETF	78.62	78.77	78.58	78.75	6099300.0
2006-11-15 13:00:00	IWM	ETF	78.74	79.01	78.0587	78.97	15858700.0
2006-11-15 14:00:00	IWM	ETF	78.97	79.0	78.52	78.62	9728000.0
2006-11-15 15:00:00	IWM	ETF	78.63	78.81	78.57	78.77	6029200.0
2006-11-15 16:00:00	IWM	ETF	78.77	78.8	78.67	78.68	771400.0
2006-11-15 17:00:00	IWM	ETF	78.64	78.68	78.5429	78.61	2254200.0
2006-11-15 18:00:00	IWM	ETF	78.66	78.7	78.65	78.7	2200.0
2006-11-15 07:00:00	DIA	ETF	122.35	122.35	122.35	122.35	300.0
2006-11-15 08:00:00	DIA	ETF	122.35	122.48	122.35	122.44	3300.0
2006-11-15 09:00:00	DIA	ETF	122.42	122.65	122.28	122.61	765800.0
2006-11-15 10:00:00	DIA	ETF	122.6	122.63	122.47	122.48	1430400.0
2006-11-15 11:00:00	DIA	ETF	122.47	122.63	122.42	122.54	708700.0
2006-11-15 12:00:00	DIA	ETF	122.54	122.74	122.52	122.7	505500.0
2006-11-15 13:00:00	DIA	ETF	122.7	122.97	122.68	122.91	850400.0
2006-11-15 14:00:00	DIA	ETF	122.91	123.11	122.61	122.72	2996800.0
2006-11-15 15:00:00	DIA	ETF	122.72	122.91	122.63	122.72	1446900.0
2006-11-15 16:00:00	DIA	ETF	122.71	122.82	122.68	122.68	37000.0
2006-11-15 17:00:00	DIA	ETF	122.7	122.7	122.7	122.7	1000.0
2006-11-15 18:00:00	DIA	ETF	122.7	122.7	122.7	122.7	1000.0
2006-11-15 07:00:00	GLD	ETF	61.3	61.39	61.2	61.39	103600.0
2006-11-15 08:00:00	GLD	ETF	61.38	61.41	61.09	61.27	234500.0
2006-11-15 09:00:00	GLD	ETF	61.28	61.43	61.2	61.32	863400.0
2006-11-15 10:00:00	GLD	ETF	61.33	61.63	61.25	61.47	855700.0
2006-11-15 11:00:00	GLD	ETF	61.48	61.9	61.4614	61.77	697100.0
2006-11-15 12:00:00	GLD	ETF	61.75	62.07	61.7	62.0	378400.0

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

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