PREVIEW / etf_1hour / 2005-09-02

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-02.parquet
  size:    30 KB
  rows:    935

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
2005-09-02 07:00:00	SPY	ETF	122.6	122.6	122.6	122.6	5000.0
2005-09-02 08:00:00	SPY	ETF	122.57	122.91	122.39	122.86	3740700.0
2005-09-02 09:00:00	SPY	ETF	122.86	122.89	122.45	122.58	5799300.0
2005-09-02 10:00:00	SPY	ETF	122.58	122.73	122.2	122.41	11356700.0
2005-09-02 11:00:00	SPY	ETF	122.37	122.53	122.12	122.17	4223600.0
2005-09-02 12:00:00	SPY	ETF	122.18	122.59	122.13	122.5	8199700.0
2005-09-02 13:00:00	SPY	ETF	122.5	122.68	122.4	122.63	2582400.0
2005-09-02 14:00:00	SPY	ETF	122.64	122.66	122.34	122.39	2175500.0
2005-09-02 15:00:00	SPY	ETF	122.39	122.46	122.1	122.13	7360400.0
2005-09-02 16:00:00	SPY	ETF	122.14	122.75	122.04	122.3	1140700.0
2005-09-02 17:00:00	SPY	ETF	122.28	122.3	122.17	122.2	4600.0
2005-09-02 18:00:00	SPY	ETF	122.2	122.22	122.16	122.17	2300.0
2005-09-02 19:00:00	SPY	ETF	122.15	122.25	122.15	122.25	2200.0
2005-09-02 09:00:00	QQQ	ETF	38.99	39.03	38.88	38.91	6735200.0
2005-09-02 10:00:00	QQQ	ETF	38.91	38.98	38.78	38.82	12845100.0
2005-09-02 11:00:00	QQQ	ETF	38.82	38.94	38.74	38.79	7497400.0
2005-09-02 12:00:00	QQQ	ETF	38.78	38.89	38.78	38.86	7272700.0
2005-09-02 13:00:00	QQQ	ETF	38.86	38.93	38.82	38.9	4225700.0
2005-09-02 14:00:00	QQQ	ETF	38.9	38.92	38.83	38.85	2875800.0
2005-09-02 15:00:00	QQQ	ETF	38.85	38.88	38.74	38.77	7982300.0
2005-09-02 08:00:00	IWM	ETF	66.61	66.7	66.28	66.69	814700.0
2005-09-02 09:00:00	IWM	ETF	66.69	66.8	66.26	66.34	4087800.0
2005-09-02 10:00:00	IWM	ETF	66.34	66.48	66.05	66.09	5927900.0
2005-09-02 11:00:00	IWM	ETF	66.11	66.24	66.0	66.12	1889500.0
2005-09-02 12:00:00	IWM	ETF	66.13	66.4	66.12	66.32	2875900.0
2005-09-02 13:00:00	IWM	ETF	66.32	66.4	66.25	66.35	1005700.0
2005-09-02 14:00:00	IWM	ETF	66.35	66.37	66.06	66.11	1482900.0
2005-09-02 15:00:00	IWM	ETF	66.1	66.22	65.9	66.03	2810700.0
2005-09-02 16:00:00	IWM	ETF	66.02	66.2	66.02	66.12	101100.0
2005-09-02 08:00:00	DIA	ETF	104.71	104.88	104.43	104.86	631400.0
2005-09-02 09:00:00	DIA	ETF	104.86	104.88	104.53	104.72	727100.0
2005-09-02 10:00:00	DIA	ETF	104.71	104.85	104.39	104.59	2897200.0
2005-09-02 11:00:00	DIA	ETF	104.62	104.81	104.3	104.41	3180100.0
2005-09-02 12:00:00	DIA	ETF	104.4	104.82	104.39	104.75	883900.0
2005-09-02 13:00:00	DIA	ETF	104.74	104.93	104.65	104.88	796800.0
2005-09-02 14:00:00	DIA	ETF	104.88	104.88	104.65	104.69	243700.0
2005-09-02 15:00:00	DIA	ETF	104.68	104.79	104.44	104.5	1908900.0
2005-09-02 16:00:00	DIA	ETF	104.44	104.69	104.44	104.65	315600.0
2005-09-02 17:00:00	DIA	ETF	104.65	104.65	104.65	104.65	200.0
2005-09-02 18:00:00	DIA	ETF	104.55	104.55	104.55	104.55	200.0
2005-09-02 08:00:00	GLD	ETF	44.55	44.55	44.24	44.32	6600.0
2005-09-02 09:00:00	GLD	ETF	44.32	44.32	44.09	44.28	149500.0
2005-09-02 10:00:00	GLD	ETF	44.29	44.32	44.14	44.21	280200.0
2005-09-02 11:00:00	GLD	ETF	44.21	44.31	44.19	44.3	100800.0
2005-09-02 12:00:00	GLD	ETF	44.31	44.36	44.3	44.33	43900.0
2005-09-02 13:00:00	GLD	ETF	44.33	44.33	44.21	44.22	590000.0
2005-09-02 14:00:00	GLD	ETF	44.21	44.25	44.21	44.21	161100.0
2005-09-02 15:00:00	GLD	ETF	44.24	44.27	44.2	44.25	82500.0
2005-09-02 16:00:00	GLD	ETF	44.27	44.27	44.24	44.24	300.0
2005-09-02 08:00:00	TLT	ETF	95.0	95.05	94.76	95.05	164300.0

> showing 50 of 935 rows — these rows as CSV

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