PREVIEW / etf_1hour / 2006-09-07

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-09-07.parquet
  size:    52 KB
  rows:    1,623

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-09-07 04:00:00	SPY	ETF	130.04	130.04	130.04	130.04	500.0
2006-09-07 06:00:00	SPY	ETF	130.13	130.13	130.13	130.13	2000.0
2006-09-07 07:00:00	SPY	ETF	130.14	130.16	130.05	130.1	278600.0
2006-09-07 08:00:00	SPY	ETF	130.14	130.16	130.02	130.08	2988300.0
2006-09-07 09:00:00	SPY	ETF	130.09	130.2	129.98	130.06	6095800.0
2006-09-07 10:00:00	SPY	ETF	130.1	130.1	129.35	129.8	16184800.0
2006-09-07 11:00:00	SPY	ETF	129.8	130.16	129.75	130.12	11104200.0
2006-09-07 12:00:00	SPY	ETF	130.12	130.23	129.94	129.98	9842400.0
2006-09-07 13:00:00	SPY	ETF	129.98	130.57	129.9	130.42	12670400.0
2006-09-07 14:00:00	SPY	ETF	130.42	130.45	130.0	130.24	10783900.0
2006-09-07 15:00:00	SPY	ETF	130.21	130.26	129.71	129.82	13556200.0
2006-09-07 16:00:00	SPY	ETF	129.85	129.99	129.81	129.91	2067200.0
2006-09-07 17:00:00	SPY	ETF	129.97	130.02	129.9	129.95	15200.0
2006-09-07 18:00:00	SPY	ETF	129.95	130.03	129.94	130.03	27600.0
2006-09-07 19:00:00	SPY	ETF	130.01	130.04	130.01	130.01	1700.0
2006-09-07 09:00:00	QQQ	ETF	38.57	38.61	38.45	38.51	15106100.0
2006-09-07 10:00:00	QQQ	ETF	38.51	38.55	38.36	38.48	19315300.0
2006-09-07 11:00:00	QQQ	ETF	38.47	38.75	38.47	38.72	24065600.0
2006-09-07 12:00:00	QQQ	ETF	38.72	38.84	38.61	38.65	13271100.0
2006-09-07 13:00:00	QQQ	ETF	38.65	38.9	38.6	38.81	12491500.0
2006-09-07 14:00:00	QQQ	ETF	38.82	38.85	38.66	38.74	11279100.0
2006-09-07 15:00:00	QQQ	ETF	38.74	38.74	38.47	38.48	14889500.0
2006-09-07 07:00:00	IWM	ETF	70.74	70.74	70.63	70.63	8500.0
2006-09-07 08:00:00	IWM	ETF	70.63	70.69	70.55	70.6	113600.0
2006-09-07 09:00:00	IWM	ETF	70.57	70.61	70.36	70.42	3821200.0
2006-09-07 10:00:00	IWM	ETF	70.43	70.43	70.06	70.33	8013000.0
2006-09-07 11:00:00	IWM	ETF	70.33	70.79	70.33	70.77	3699300.0
2006-09-07 12:00:00	IWM	ETF	70.75	70.91	70.46	70.49	5733000.0
2006-09-07 13:00:00	IWM	ETF	70.5	71.12	70.42	70.99	5684100.0
2006-09-07 14:00:00	IWM	ETF	70.98	71.07	70.61	70.84	4037700.0
2006-09-07 15:00:00	IWM	ETF	70.84	70.85	70.21	70.28	10450300.0
2006-09-07 16:00:00	IWM	ETF	70.28	70.34	70.24	70.34	324700.0
2006-09-07 17:00:00	IWM	ETF	70.27	70.54	70.25	70.41	123900.0
2006-09-07 18:00:00	IWM	ETF	70.44	70.49	70.41	70.49	50900.0
2006-09-07 19:00:00	IWM	ETF	70.45	70.45	70.45	70.45	100.0
2006-09-07 06:00:00	DIA	ETF	114.54	114.54	114.54	114.54	300.0
2006-09-07 07:00:00	DIA	ETF	113.77	113.77	113.77	113.77	4000.0
2006-09-07 08:00:00	DIA	ETF	113.83	113.83	113.68	113.75	18800.0
2006-09-07 09:00:00	DIA	ETF	113.75	113.8	113.63	113.76	821400.0
2006-09-07 10:00:00	DIA	ETF	113.77	113.77	113.31	113.42	1548100.0
2006-09-07 11:00:00	DIA	ETF	113.43	113.72	113.37	113.7	871100.0
2006-09-07 12:00:00	DIA	ETF	113.68	113.77	113.59	113.62	575300.0
2006-09-07 13:00:00	DIA	ETF	113.62	113.95	113.54	113.87	636700.0
2006-09-07 14:00:00	DIA	ETF	113.87	113.89	113.51	113.66	746500.0
2006-09-07 15:00:00	DIA	ETF	113.66	113.67	113.23	113.34	1570600.0
2006-09-07 16:00:00	DIA	ETF	113.36	113.54	113.36	113.49	155700.0
2006-09-07 19:00:00	DIA	ETF	113.55	113.55	113.55	113.55	100.0
2006-09-07 07:00:00	GLD	ETF	62.74	62.74	62.74	62.74	3000.0
2006-09-07 08:00:00	GLD	ETF	62.72	62.97	61.98	62.11	286300.0
2006-09-07 09:00:00	GLD	ETF	62.13	62.19	61.66	61.81	827100.0

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

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