PREVIEW / etf_1hour / 2006-02-01

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-01.parquet
  size:    39 KB
  rows:    1,215

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-02-01 04:00:00	SPY	ETF	127.68	127.68	127.68	127.68	400.0
2006-02-01 05:00:00	SPY	ETF	127.62	127.62	127.62	127.62	400.0
2006-02-01 06:00:00	SPY	ETF	127.69	127.69	127.69	127.69	20000.0
2006-02-01 07:00:00	SPY	ETF	127.66	127.87	127.64	127.83	110300.0
2006-02-01 08:00:00	SPY	ETF	127.94	127.94	127.5	127.87	664700.0
2006-02-01 09:00:00	SPY	ETF	127.87	128.02	127.78	127.85	9457600.0
2006-02-01 10:00:00	SPY	ETF	127.85	128.33	127.73	128.02	9468800.0
2006-02-01 11:00:00	SPY	ETF	128.02	128.3	127.86	128.07	7739400.0
2006-02-01 12:00:00	SPY	ETF	128.07	128.28	127.93	128.13	7007500.0
2006-02-01 13:00:00	SPY	ETF	128.13	128.16	127.72	127.94	9581000.0
2006-02-01 14:00:00	SPY	ETF	127.94	128.2	127.87	127.99	6597100.0
2006-02-01 15:00:00	SPY	ETF	128.0	128.35	127.96	128.23	7252200.0
2006-02-01 16:00:00	SPY	ETF	128.23	128.43	128.03	128.35	1933300.0
2006-02-01 17:00:00	SPY	ETF	128.36	128.39	128.34	128.34	30700.0
2006-02-01 18:00:00	SPY	ETF	128.37	128.37	128.35	128.35	2100.0
2006-02-01 19:00:00	SPY	ETF	128.33	128.33	128.33	128.33	400.0
2006-02-01 09:00:00	QQQ	ETF	41.75	41.85	41.72	41.75	9519400.0
2006-02-01 10:00:00	QQQ	ETF	41.75	42.12	41.7	41.94	20743600.0
2006-02-01 11:00:00	QQQ	ETF	41.93	42.04	41.89	41.91	10334600.0
2006-02-01 12:00:00	QQQ	ETF	41.92	42.07	41.91	41.98	7025000.0
2006-02-01 13:00:00	QQQ	ETF	41.99	42.07	41.78	41.91	11291900.0
2006-02-01 14:00:00	QQQ	ETF	41.91	42.06	41.91	41.94	10264200.0
2006-02-01 15:00:00	QQQ	ETF	41.95	42.17	41.94	42.13	10981900.0
2006-02-01 07:00:00	IWM	ETF	72.35	72.5	72.35	72.5	25800.0
2006-02-01 08:00:00	IWM	ETF	72.38	72.71	72.35	72.54	375800.0
2006-02-01 09:00:00	IWM	ETF	72.53	72.7	72.49	72.59	2352000.0
2006-02-01 10:00:00	IWM	ETF	72.58	72.9	72.47	72.82	3929700.0
2006-02-01 11:00:00	IWM	ETF	72.82	73.11	72.8	73.01	7959900.0
2006-02-01 12:00:00	IWM	ETF	73.02	73.21	72.94	73.15	2741500.0
2006-02-01 13:00:00	IWM	ETF	73.15	73.16	72.8	73.0	4922400.0
2006-02-01 14:00:00	IWM	ETF	73.0	73.15	72.97	73.05	3698000.0
2006-02-01 15:00:00	IWM	ETF	73.06	73.21	73.0	73.03	5652400.0
2006-02-01 16:00:00	IWM	ETF	73.04	73.19	73.02	73.15	2974200.0
2006-02-01 17:00:00	IWM	ETF	73.12	73.24	73.12	73.24	1200.0
2006-02-01 18:00:00	IWM	ETF	73.16	73.16	73.16	73.16	1000.0
2006-02-01 07:00:00	DIA	ETF	108.31	108.51	108.31	108.49	7100.0
2006-02-01 08:00:00	DIA	ETF	108.49	108.65	108.31	108.65	239000.0
2006-02-01 09:00:00	DIA	ETF	108.66	108.82	108.5	108.72	1086000.0
2006-02-01 10:00:00	DIA	ETF	108.7	109.17	108.64	108.94	962900.0
2006-02-01 11:00:00	DIA	ETF	108.95	109.17	108.8	108.97	1003500.0
2006-02-01 12:00:00	DIA	ETF	108.99	109.16	108.91	109.05	479300.0
2006-02-01 13:00:00	DIA	ETF	109.04	109.07	108.69	108.9	427200.0
2006-02-01 14:00:00	DIA	ETF	108.88	109.21	108.88	109.08	443600.0
2006-02-01 15:00:00	DIA	ETF	109.08	109.6	109.05	109.42	2088700.0
2006-02-01 16:00:00	DIA	ETF	109.42	109.62	109.41	109.57	133100.0
2006-02-01 17:00:00	DIA	ETF	109.56	109.65	109.56	109.65	800.0
2006-02-01 18:00:00	DIA	ETF	109.7	109.7	109.57	109.57	400.0
2006-02-01 19:00:00	DIA	ETF	109.56	109.56	109.56	109.56	100.0
2006-02-01 07:00:00	GLD	ETF	56.66	56.66	56.64	56.65	3000.0
2006-02-01 08:00:00	GLD	ETF	56.65	56.96	56.65	56.87	19500.0

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

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