PREVIEW / etf_1hour / 2006-06-01

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-01.parquet
  size:    45 KB
  rows:    1,367

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-06-01 04:00:00	SPY	ETF	126.98	126.98	126.91	126.91	200.0
2006-06-01 06:00:00	SPY	ETF	127.1	127.1	126.96	127.0	83700.0
2006-06-01 07:00:00	SPY	ETF	127.03	127.18	127.0	127.16	589400.0
2006-06-01 08:00:00	SPY	ETF	127.15	127.58	126.8	127.46	3679100.0
2006-06-01 09:00:00	SPY	ETF	127.44	127.87	127.27	127.66	8565700.0
2006-06-01 10:00:00	SPY	ETF	127.66	128.05	127.41	127.87	14665000.0
2006-06-01 11:00:00	SPY	ETF	127.86	128.26	127.82	127.96	8144900.0
2006-06-01 12:00:00	SPY	ETF	127.96	128.28	127.95	128.02	4223600.0
2006-06-01 13:00:00	SPY	ETF	128.03	128.3	127.99	128.22	3473100.0
2006-06-01 14:00:00	SPY	ETF	128.21	128.43	128.02	128.37	7442200.0
2006-06-01 15:00:00	SPY	ETF	128.37	128.94	128.2692	128.83	17640700.0
2006-06-01 16:00:00	SPY	ETF	128.81	128.91	128.69	128.73	1583800.0
2006-06-01 17:00:00	SPY	ETF	128.74	128.75	128.71	128.75	10700.0
2006-06-01 18:00:00	SPY	ETF	128.72	128.79	128.68	128.68	6300.0
2006-06-01 19:00:00	SPY	ETF	128.7	128.72	128.7	128.71	8800.0
2006-06-01 09:00:00	QQQ	ETF	38.91	39.1	38.84	39.02	17787200.0
2006-06-01 10:00:00	QQQ	ETF	39.03	39.27	38.92	39.2	25108100.0
2006-06-01 11:00:00	QQQ	ETF	39.19	39.31	39.17	39.21	9970500.0
2006-06-01 12:00:00	QQQ	ETF	39.21	39.36	39.2	39.26	9568800.0
2006-06-01 13:00:00	QQQ	ETF	39.26	39.34	39.24	39.33	6524600.0
2006-06-01 14:00:00	QQQ	ETF	39.34	39.51	39.29	39.48	15094800.0
2006-06-01 15:00:00	QQQ	ETF	39.48	39.73	39.4	39.72	24355700.0
2006-06-01 08:00:00	IWM	ETF	71.87	72.0	71.63	71.9	1818700.0
2006-06-01 09:00:00	IWM	ETF	71.89	72.3	71.65	72.06	6597600.0
2006-06-01 10:00:00	IWM	ETF	72.07	72.43	71.9	72.26	6234400.0
2006-06-01 11:00:00	IWM	ETF	72.24	72.6	72.19	72.28	5579600.0
2006-06-01 12:00:00	IWM	ETF	72.28	72.5	72.25	72.25	2029200.0
2006-06-01 13:00:00	IWM	ETF	72.26	72.5	72.24	72.48	1814200.0
2006-06-01 14:00:00	IWM	ETF	72.48	72.75	72.35	72.7	6097800.0
2006-06-01 15:00:00	IWM	ETF	72.7	73.24	72.67	73.23	15061800.0
2006-06-01 16:00:00	IWM	ETF	73.17	73.34	72.5068	73.25	1766400.0
2006-06-01 17:00:00	IWM	ETF	73.28	73.28	73.25	73.25	1300.0
2006-06-01 18:00:00	IWM	ETF	73.25	73.28	73.21	73.21	4500.0
2006-06-01 08:00:00	DIA	ETF	111.52	111.75	111.47	111.73	41000.0
2006-06-01 09:00:00	DIA	ETF	111.65	111.93	111.47	111.81	960700.0
2006-06-01 10:00:00	DIA	ETF	111.82	112.06	111.56	111.96	1840100.0
2006-06-01 11:00:00	DIA	ETF	111.94	112.22	111.88	111.96	501400.0
2006-06-01 12:00:00	DIA	ETF	111.97	112.19	111.91	111.97	306900.0
2006-06-01 13:00:00	DIA	ETF	111.99	112.17	111.95	112.12	312300.0
2006-06-01 14:00:00	DIA	ETF	112.111	112.29	111.97	112.26	595600.0
2006-06-01 15:00:00	DIA	ETF	112.26	112.66	112.18	112.51	1372600.0
2006-06-01 16:00:00	DIA	ETF	112.46	112.5	112.38	112.38	18800.0
2006-06-01 17:00:00	DIA	ETF	112.5	112.5	112.5	112.5	2200.0
2006-06-01 18:00:00	DIA	ETF	112.23	112.23	112.23	112.23	100.0
2006-06-01 07:00:00	GLD	ETF	62.7	62.8	62.65	62.73	54400.0
2006-06-01 08:00:00	GLD	ETF	62.67	62.94	62.17	62.27	448600.0
2006-06-01 09:00:00	GLD	ETF	62.3	62.39	61.74	62.08	3631500.0
2006-06-01 10:00:00	GLD	ETF	62.07	62.7	61.8	62.69	2499500.0
2006-06-01 11:00:00	GLD	ETF	62.7	62.97	62.59	62.9	1493100.0
2006-06-01 12:00:00	GLD	ETF	62.89	62.97	62.68	62.85	712100.0

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

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