PREVIEW / etf_1hour / 2006-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-06-02.parquet
  size:    44 KB
  rows:    1,353

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-02 05:00:00	SPY	ETF	128.81	128.84	128.81	128.84	1700.0
2006-06-02 06:00:00	SPY	ETF	128.89	128.89	128.89	128.89	100.0
2006-06-02 07:00:00	SPY	ETF	128.82	129.08	128.82	128.93	83400.0
2006-06-02 08:00:00	SPY	ETF	128.94	129.56	128.84	129.43	7819900.0
2006-06-02 09:00:00	SPY	ETF	129.45	129.47	128.46	128.65	24490100.0
2006-06-02 10:00:00	SPY	ETF	128.65	129.3	128.64	129.06	15680800.0
2006-06-02 11:00:00	SPY	ETF	129.06	129.2	128.33	128.43	10970400.0
2006-06-02 12:00:00	SPY	ETF	128.41	128.84	128.32	128.67	6431000.0
2006-06-02 13:00:00	SPY	ETF	128.66	128.97	128.65	128.76	6055900.0
2006-06-02 14:00:00	SPY	ETF	128.76	129.16	128.68	129.08	6808100.0
2006-06-02 15:00:00	SPY	ETF	129.08	129.29	128.83	129.13	9646600.0
2006-06-02 16:00:00	SPY	ETF	129.13	129.18	128.96	129.06	1815200.0
2006-06-02 17:00:00	SPY	ETF	128.98	129.02	128.97	129.02	2200.0
2006-06-02 18:00:00	SPY	ETF	128.99	128.99	128.99	128.99	200.0
2006-06-02 19:00:00	SPY	ETF	129.0	129.0	128.96	128.96	1800.0
2006-06-02 09:00:00	QQQ	ETF	39.97	40.0	39.56	39.68	26261400.0
2006-06-02 10:00:00	QQQ	ETF	39.68	39.89	39.66	39.77	16566700.0
2006-06-02 11:00:00	QQQ	ETF	39.77	39.79	39.32	39.35	26480800.0
2006-06-02 12:00:00	QQQ	ETF	39.35	39.54	39.31	39.45	12294300.0
2006-06-02 13:00:00	QQQ	ETF	39.46	39.6	39.42	39.47	8451200.0
2006-06-02 14:00:00	QQQ	ETF	39.47	39.64	39.4	39.6	9250500.0
2006-06-02 15:00:00	QQQ	ETF	39.59	39.7	39.4	39.64	12938400.0
2006-06-02 08:00:00	IWM	ETF	73.33	73.84	73.13	73.74	3601200.0
2006-06-02 09:00:00	IWM	ETF	73.74	73.87	73.15	73.22	10410800.0
2006-06-02 10:00:00	IWM	ETF	73.22	73.62	73.21	73.36	8791200.0
2006-06-02 11:00:00	IWM	ETF	73.35	73.42	72.68	72.75	7946500.0
2006-06-02 12:00:00	IWM	ETF	72.76	73.2	72.7	73.05	3986200.0
2006-06-02 13:00:00	IWM	ETF	73.06	73.2789	73.02	73.08	4057600.0
2006-06-02 14:00:00	IWM	ETF	73.07	73.37	73.0	73.31	4532200.0
2006-06-02 15:00:00	IWM	ETF	73.32	73.34	73.09	73.34	5878700.0
2006-06-02 16:00:00	IWM	ETF	73.32	73.35	73.1	73.17	255400.0
2006-06-02 18:00:00	IWM	ETF	73.05	73.05	73.05	73.05	100.0
2006-06-02 07:00:00	DIA	ETF	112.43	112.6	112.43	112.6	1200.0
2006-06-02 08:00:00	DIA	ETF	112.5	113.07	112.5	112.95	168500.0
2006-06-02 09:00:00	DIA	ETF	112.89	112.95	111.94	112.04	1441300.0
2006-06-02 10:00:00	DIA	ETF	112.04	112.7	112.02	112.5	1552900.0
2006-06-02 11:00:00	DIA	ETF	112.51	112.57	111.93	111.96	1050900.0
2006-06-02 12:00:00	DIA	ETF	111.96	112.29	111.88	112.12	676500.0
2006-06-02 13:00:00	DIA	ETF	112.14	112.29	112.02	112.14	312700.0
2006-06-02 14:00:00	DIA	ETF	112.15	112.43	112.03	112.34	319600.0
2006-06-02 15:00:00	DIA	ETF	112.37	112.54	112.2	112.45	979300.0
2006-06-02 16:00:00	DIA	ETF	112.46	112.47	112.35	112.37	19900.0
2006-06-02 17:00:00	DIA	ETF	112.36	112.38	112.36	112.38	3200.0
2006-06-02 18:00:00	DIA	ETF	112.35	112.35	112.35	112.35	100.0
2006-06-02 08:00:00	GLD	ETF	62.7	63.53	62.6	63.51	397400.0
2006-06-02 09:00:00	GLD	ETF	63.54	63.54	62.53	62.65	1674000.0
2006-06-02 10:00:00	GLD	ETF	62.65	63.24	62.55	63.0	1501900.0
2006-06-02 11:00:00	GLD	ETF	63.03	63.247	62.9	63.04	828300.0
2006-06-02 12:00:00	GLD	ETF	63.03	63.44	62.97	63.41	607900.0
2006-06-02 13:00:00	GLD	ETF	63.4	63.44	63.1802	63.28	288100.0

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

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