PREVIEW / etf_1hour / 2006-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-23.parquet
  size:    51 KB
  rows:    1,606

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-08-23 07:00:00	SPY	ETF	130.05	130.05	130.05	130.05	1000.0
2006-08-23 08:00:00	SPY	ETF	130.02	130.22	129.98	130.19	651200.0
2006-08-23 09:00:00	SPY	ETF	130.2	130.44	130.12	130.31	6521800.0
2006-08-23 10:00:00	SPY	ETF	130.31	130.32	129.7	129.79	17613700.0
2006-08-23 11:00:00	SPY	ETF	129.8	129.82	129.43	129.65	15577000.0
2006-08-23 12:00:00	SPY	ETF	129.65	129.76	129.54	129.67	4133900.0
2006-08-23 13:00:00	SPY	ETF	129.67	129.7	129.22	129.34	6025700.0
2006-08-23 14:00:00	SPY	ETF	129.34	129.44	129.21	129.23	4673500.0
2006-08-23 15:00:00	SPY	ETF	129.22	129.58	129.19	129.58	8679900.0
2006-08-23 16:00:00	SPY	ETF	129.57	129.79	129.57	129.72	1597200.0
2006-08-23 17:00:00	SPY	ETF	129.71	129.71	129.66	129.66	8200.0
2006-08-23 18:00:00	SPY	ETF	129.69	129.69	129.66	129.66	33000.0
2006-08-23 19:00:00	SPY	ETF	129.65	129.71	129.65	129.7	700.0
2006-08-23 09:00:00	QQQ	ETF	38.47	38.67	38.29	38.59	10288600.0
2006-08-23 10:00:00	QQQ	ETF	38.59	38.95	38.05	38.32	23046700.0
2006-08-23 11:00:00	QQQ	ETF	38.32	38.32	37.9	38.19	15578700.0
2006-08-23 12:00:00	QQQ	ETF	38.18	38.24	38.14	38.22	6297100.0
2006-08-23 13:00:00	QQQ	ETF	38.22	38.22	38.01	38.07	7826600.0
2006-08-23 14:00:00	QQQ	ETF	38.08	38.11	37.92	37.97	11958700.0
2006-08-23 15:00:00	QQQ	ETF	37.97	38.17	37.12	38.17	14426300.0
2006-08-23 08:00:00	IWM	ETF	70.39	70.54	70.36	70.48	53600.0
2006-08-23 09:00:00	IWM	ETF	70.47	70.8	70.47	70.6	1944700.0
2006-08-23 10:00:00	IWM	ETF	70.6	70.6	69.7	69.78	9793000.0
2006-08-23 11:00:00	IWM	ETF	69.79	69.8	69.52	69.66	5437800.0
2006-08-23 12:00:00	IWM	ETF	69.65	69.77	69.55	69.71	2297500.0
2006-08-23 13:00:00	IWM	ETF	69.71	69.71	69.25	69.33	4015000.0
2006-08-23 14:00:00	IWM	ETF	69.32	70.4214	69.24	69.26	6378600.0
2006-08-23 15:00:00	IWM	ETF	69.26	69.59	69.2	69.49	6277400.0
2006-08-23 16:00:00	IWM	ETF	69.49	69.63	69.45	69.63	341800.0
2006-08-23 17:00:00	IWM	ETF	69.55	69.56	69.54	69.55	3100.0
2006-08-23 18:00:00	IWM	ETF	69.54	69.54	69.54	69.54	700.0
2006-08-23 19:00:00	IWM	ETF	69.59	69.61	69.59	69.61	700.0
2006-08-23 08:00:00	DIA	ETF	113.18	113.31	113.18	113.27	5000.0
2006-08-23 09:00:00	DIA	ETF	113.26	113.62	113.2	113.54	605000.0
2006-08-23 10:00:00	DIA	ETF	113.54	113.55	113.04	113.1	911200.0
2006-08-23 11:00:00	DIA	ETF	113.11	113.12	112.73	112.94	994600.0
2006-08-23 12:00:00	DIA	ETF	112.95	113.05	112.86	112.94	362000.0
2006-08-23 13:00:00	DIA	ETF	112.95	112.95	112.58	112.66	584500.0
2006-08-23 14:00:00	DIA	ETF	112.66	112.79	112.61	112.62	735100.0
2006-08-23 15:00:00	DIA	ETF	112.62	112.93	112.6	112.91	1430400.0
2006-08-23 16:00:00	DIA	ETF	112.94	113.12	112.94	113.09	1308700.0
2006-08-23 17:00:00	DIA	ETF	113.09	113.09	113.09	113.09	700.0
2006-08-23 18:00:00	DIA	ETF	113.12	113.12	113.12	113.12	40000.0
2006-08-23 19:00:00	DIA	ETF	113.05	113.05	113.05	113.05	600.0
2006-08-23 07:00:00	GLD	ETF	62.13	62.13	62.13	62.13	100.0
2006-08-23 08:00:00	GLD	ETF	62.17	62.59	62.12	62.55	114000.0
2006-08-23 09:00:00	GLD	ETF	62.55	62.6	62.37	62.58	668500.0
2006-08-23 10:00:00	GLD	ETF	62.57	62.68	61.85	61.9	1063900.0
2006-08-23 11:00:00	GLD	ETF	61.94	62.108	61.8	62.02	524900.0
2006-08-23 12:00:00	GLD	ETF	62.02	62.18	61.95	62.12	297200.0

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

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