PREVIEW / etf_1hour / 2006-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-02-03.parquet
  size:    40 KB
  rows:    1,212

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-03 06:00:00	SPY	ETF	127.17	127.17	127.16	127.16	7200.0
2006-02-03 07:00:00	SPY	ETF	127.18	127.21	127.07	127.18	97200.0
2006-02-03 08:00:00	SPY	ETF	127.2	127.39	126.63	126.66	7111700.0
2006-02-03 09:00:00	SPY	ETF	126.69	126.77	126.2	126.25	13499900.0
2006-02-03 10:00:00	SPY	ETF	126.25	126.67	126.14	126.63	17705100.0
2006-02-03 11:00:00	SPY	ETF	126.62	126.89	126.38	126.73	7536600.0
2006-02-03 12:00:00	SPY	ETF	126.71	126.8	126.58	126.74	2197000.0
2006-02-03 13:00:00	SPY	ETF	126.74	127.15	126.66	126.85	12234000.0
2006-02-03 14:00:00	SPY	ETF	126.85	127.0	126.49	126.6	9545200.0
2006-02-03 15:00:00	SPY	ETF	126.59	126.83	126.24	126.41	11164100.0
2006-02-03 16:00:00	SPY	ETF	126.39	127.138	126.18	126.26	2584100.0
2006-02-03 17:00:00	SPY	ETF	126.27	126.27	126.2	126.27	8400.0
2006-02-03 18:00:00	SPY	ETF	126.27	126.28	126.25	126.25	1600.0
2006-02-03 19:00:00	SPY	ETF	126.25	126.3	126.25	126.3	1500.0
2006-02-03 09:00:00	QQQ	ETF	41.11	41.13	40.96	41.02	21599100.0
2006-02-03 10:00:00	QQQ	ETF	41.02	41.12	40.88	41.04	24410700.0
2006-02-03 11:00:00	QQQ	ETF	41.04	41.14	40.94	41.02	10433300.0
2006-02-03 12:00:00	QQQ	ETF	41.03	41.04	40.94	40.98	4884200.0
2006-02-03 13:00:00	QQQ	ETF	40.97	41.23	40.97	41.07	11085100.0
2006-02-03 14:00:00	QQQ	ETF	41.08	41.1	40.9	40.92	9168500.0
2006-02-03 15:00:00	QQQ	ETF	40.93	41.02	40.78	40.93	18130100.0
2006-02-03 07:00:00	IWM	ETF	72.07	72.08	72.07	72.08	1000.0
2006-02-03 08:00:00	IWM	ETF	72.1	72.27	71.8	71.84	565500.0
2006-02-03 09:00:00	IWM	ETF	71.81	72.17	71.63	71.65	6629000.0
2006-02-03 10:00:00	IWM	ETF	71.65	71.89	71.51	71.75	9200300.0
2006-02-03 11:00:00	IWM	ETF	71.75	72.11	71.67	72.01	5092000.0
2006-02-03 12:00:00	IWM	ETF	72.01	72.05	71.85	72.01	2183900.0
2006-02-03 13:00:00	IWM	ETF	72.02	72.49	71.96	72.31	4627800.0
2006-02-03 14:00:00	IWM	ETF	72.32	72.35	72.06	72.1	2297900.0
2006-02-03 15:00:00	IWM	ETF	72.1	72.22	71.86	71.91	5145700.0
2006-02-03 16:00:00	IWM	ETF	71.93	71.96	71.64	71.7	325300.0
2006-02-03 17:00:00	IWM	ETF	72.1683	72.1683	72.1683	72.1683	693000.0
2006-02-03 07:00:00	DIA	ETF	108.54	108.54	108.54	108.54	3000.0
2006-02-03 08:00:00	DIA	ETF	108.54	108.78	108.23	108.32	316500.0
2006-02-03 09:00:00	DIA	ETF	108.11	108.28	107.85	107.9	851500.0
2006-02-03 10:00:00	DIA	ETF	107.9	108.12	107.78	108.08	941400.0
2006-02-03 11:00:00	DIA	ETF	108.06	108.3	107.86	108.14	558700.0
2006-02-03 12:00:00	DIA	ETF	108.15	108.2	108.03	108.16	272700.0
2006-02-03 13:00:00	DIA	ETF	108.17	108.62	108.16	108.31	655500.0
2006-02-03 14:00:00	DIA	ETF	108.32	108.55	108.0	108.08	477400.0
2006-02-03 15:00:00	DIA	ETF	108.07	108.25	107.74	107.9	960800.0
2006-02-03 16:00:00	DIA	ETF	107.86	107.86	107.73	107.73	53900.0
2006-02-03 18:00:00	DIA	ETF	107.67	107.7	107.67	107.7	800.0
2006-02-03 07:00:00	GLD	ETF	56.88	56.9	56.88	56.9	1500.0
2006-02-03 08:00:00	GLD	ETF	56.88	57.0	56.73	56.99	181300.0
2006-02-03 09:00:00	GLD	ETF	57.03	57.2	56.71	56.88	621300.0
2006-02-03 10:00:00	GLD	ETF	56.87	56.87	56.25	56.589	1649400.0
2006-02-03 11:00:00	GLD	ETF	56.58	56.75	56.52	56.5699	570500.0
2006-02-03 12:00:00	GLD	ETF	56.57	56.71	56.4	56.59	798600.0
2006-02-03 13:00:00	GLD	ETF	56.6	56.68	56.389	56.46	581000.0

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

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