PREVIEW / etf_1hour / 2006-12-28

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-28.parquet
  size:    56 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-12-28 06:00:00	SPY	ETF	142.39	142.42	142.38	142.42	25000.0
2006-12-28 07:00:00	SPY	ETF	142.33	142.35	142.3	142.35	5500.0
2006-12-28 08:00:00	SPY	ETF	142.39	142.48	142.18	142.45	702700.0
2006-12-28 09:00:00	SPY	ETF	142.43	142.5	142.1	142.27	6402700.0
2006-12-28 10:00:00	SPY	ETF	142.27	142.5	142.14	142.16	8151600.0
2006-12-28 11:00:00	SPY	ETF	142.16	142.29	142.05	142.11	3918100.0
2006-12-28 12:00:00	SPY	ETF	142.11	142.26	141.99	142.2	3360900.0
2006-12-28 13:00:00	SPY	ETF	142.2	142.33	142.13	142.28	1816400.0
2006-12-28 14:00:00	SPY	ETF	142.28	142.54	142.27	142.5	3596300.0
2006-12-28 15:00:00	SPY	ETF	142.5	142.7	142.18	142.19	5726300.0
2006-12-28 16:00:00	SPY	ETF	142.18	142.318	142.05	142.16	2299800.0
2006-12-28 17:00:00	SPY	ETF	142.16	142.17	142.15	142.15	1000.0
2006-12-28 18:00:00	SPY	ETF	142.16	142.2	142.13	142.2	2700.0
2006-12-28 19:00:00	SPY	ETF	142.2	142.21	142.17	142.17	1000.0
2006-12-28 09:00:00	QQQ	ETF	43.2	43.27	43.05	43.16	9179000.0
2006-12-28 10:00:00	QQQ	ETF	43.17	43.32	43.11	43.15	17501600.0
2006-12-28 11:00:00	QQQ	ETF	43.15	43.17	43.07	43.11	6333400.0
2006-12-28 12:00:00	QQQ	ETF	43.11	43.21	43.08	43.18	5248500.0
2006-12-28 13:00:00	QQQ	ETF	43.19	43.24	43.16	43.2	5065500.0
2006-12-28 14:00:00	QQQ	ETF	43.19	43.35	43.19	43.33	7126000.0
2006-12-28 15:00:00	QQQ	ETF	43.34	43.38	43.2	43.2	11879100.0
2006-12-28 08:00:00	IWM	ETF	79.08	79.1	78.85	79.1	20700.0
2006-12-28 09:00:00	IWM	ETF	79.1	79.28	78.78	78.93	5297300.0
2006-12-28 10:00:00	IWM	ETF	78.93	79.19	78.76	78.78	4626200.0
2006-12-28 11:00:00	IWM	ETF	78.77	78.91	78.65	78.82	5020000.0
2006-12-28 12:00:00	IWM	ETF	78.83	78.97	78.77	78.91	1554100.0
2006-12-28 13:00:00	IWM	ETF	78.91	78.98	78.78	78.93	2044400.0
2006-12-28 14:00:00	IWM	ETF	78.92	79.14	78.92	79.07	3434400.0
2006-12-28 15:00:00	IWM	ETF	79.07	79.28	78.8	78.84	5356600.0
2006-12-28 16:00:00	IWM	ETF	78.84	78.85	78.76	78.8	152100.0
2006-12-28 17:00:00	IWM	ETF	78.8	78.8	78.8	78.8	5100.0
2006-12-28 19:00:00	IWM	ETF	78.78	78.78	78.78	78.78	100.0
2006-12-28 08:00:00	DIA	ETF	124.88	124.94	124.88	124.93	6800.0
2006-12-28 09:00:00	DIA	ETF	124.9	124.99	124.69	124.82	1007500.0
2006-12-28 10:00:00	DIA	ETF	124.83	125.0	124.66	124.76	1602600.0
2006-12-28 11:00:00	DIA	ETF	124.76	124.78	124.63	124.69	947900.0
2006-12-28 12:00:00	DIA	ETF	124.68	124.82	124.59	124.77	305800.0
2006-12-28 13:00:00	DIA	ETF	124.76	124.85	124.68	124.82	259800.0
2006-12-28 14:00:00	DIA	ETF	124.83	125.1	124.8	125.08	890300.0
2006-12-28 15:00:00	DIA	ETF	125.09	125.14	124.81	124.81	1275700.0
2006-12-28 16:00:00	DIA	ETF	124.81	124.91	124.7	124.81	266700.0
2006-12-28 17:00:00	DIA	ETF	124.84	124.84	124.84	124.84	100.0
2006-12-28 06:00:00	GLD	ETF	62.4	62.4	62.4	62.4	100.0
2006-12-28 08:00:00	GLD	ETF	62.52	62.8	62.5	62.73	52600.0
2006-12-28 09:00:00	GLD	ETF	62.71	63.07	62.71	62.87	519500.0
2006-12-28 10:00:00	GLD	ETF	62.87	62.95	62.69	62.9	488000.0
2006-12-28 11:00:00	GLD	ETF	62.91	62.96	62.79	62.8188	344100.0
2006-12-28 12:00:00	GLD	ETF	62.8101	62.91	62.79	62.87	321900.0
2006-12-28 13:00:00	GLD	ETF	62.88	62.98	62.77	62.911	310700.0
2006-12-28 14:00:00	GLD	ETF	62.91	62.97	62.85	62.86	155100.0

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

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