PREVIEW / etf_1hour / 2005-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-17.parquet
  size:    32 KB
  rows:    967

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-08-17 07:00:00	SPY	ETF	122.34	122.36	122.3	122.36	26400.0
2005-08-17 08:00:00	SPY	ETF	122.43	122.45	121.01	122.08	1513400.0
2005-08-17 09:00:00	SPY	ETF	122.08	122.44	122.08	122.27	7217900.0
2005-08-17 10:00:00	SPY	ETF	122.27	122.57	122.03	122.45	12563400.0
2005-08-17 11:00:00	SPY	ETF	122.46	122.69	122.35	122.51	10937200.0
2005-08-17 12:00:00	SPY	ETF	122.51	122.8	122.47	122.69	5679000.0
2005-08-17 13:00:00	SPY	ETF	122.7	122.87	122.58	122.63	2952700.0
2005-08-17 14:00:00	SPY	ETF	122.65	122.83	122.24	122.38	9914200.0
2005-08-17 15:00:00	SPY	ETF	122.39	122.71	122.23	122.29	6979900.0
2005-08-17 16:00:00	SPY	ETF	122.3	122.445	122.15	122.25	1361700.0
2005-08-17 17:00:00	SPY	ETF	122.25	122.27	122.22	122.26	163100.0
2005-08-17 18:00:00	SPY	ETF	122.27	122.28	122.23	122.28	5700.0
2005-08-17 19:00:00	SPY	ETF	122.3	122.33	122.3	122.33	6100.0
2005-08-17 09:00:00	QQQ	ETF	38.88	39.01	38.85	38.93	10080100.0
2005-08-17 10:00:00	QQQ	ETF	38.93	39.05	38.79	38.98	14973000.0
2005-08-17 11:00:00	QQQ	ETF	38.98	39.05	38.94	38.98	9795900.0
2005-08-17 12:00:00	QQQ	ETF	38.98	39.16	38.98	39.12	8881400.0
2005-08-17 13:00:00	QQQ	ETF	39.12	39.17	39.04	39.07	4833000.0
2005-08-17 14:00:00	QQQ	ETF	39.08	39.12	38.99	39.04	5643900.0
2005-08-17 15:00:00	QQQ	ETF	39.03	39.15	39.01	39.01	8288600.0
2005-08-17 08:00:00	IWM	ETF	65.13	65.14	64.85	64.93	15600.0
2005-08-17 09:00:00	IWM	ETF	64.99	65.16	64.84	64.97	3895900.0
2005-08-17 10:00:00	IWM	ETF	64.96	65.47	64.93	65.38	4065900.0
2005-08-17 11:00:00	IWM	ETF	65.38	65.5	65.28	65.33	2836100.0
2005-08-17 12:00:00	IWM	ETF	65.33	65.56	65.31	65.47	1917000.0
2005-08-17 13:00:00	IWM	ETF	65.46	65.59	65.35	65.4	1691000.0
2005-08-17 14:00:00	IWM	ETF	65.41	65.47	65.05	65.24	2321200.0
2005-08-17 15:00:00	IWM	ETF	65.24	65.5	65.08	65.08	3674400.0
2005-08-17 16:00:00	IWM	ETF	65.1	65.13	64.98	65.03	509200.0
2005-08-17 17:00:00	IWM	ETF	65.03	65.03	65.03	65.03	1100.0
2005-08-17 18:00:00	IWM	ETF	65.03	65.03	65.03	65.03	400.0
2005-08-17 19:00:00	IWM	ETF	65.07	65.07	65.07	65.07	500.0
2005-08-17 08:00:00	DIA	ETF	105.56	105.6	105.14	105.25	60500.0
2005-08-17 09:00:00	DIA	ETF	105.27	105.6	105.26	105.48	1010200.0
2005-08-17 10:00:00	DIA	ETF	105.5	105.77	105.31	105.68	1073800.0
2005-08-17 11:00:00	DIA	ETF	105.7	105.93	105.65	105.82	604100.0
2005-08-17 12:00:00	DIA	ETF	105.82	106.04	105.804	106.0	1091000.0
2005-08-17 13:00:00	DIA	ETF	105.99	106.11	105.9	105.93	481500.0
2005-08-17 14:00:00	DIA	ETF	105.92	105.99	105.68	105.79	1248600.0
2005-08-17 15:00:00	DIA	ETF	105.79	106.03	105.7	105.72	779600.0
2005-08-17 16:00:00	DIA	ETF	105.75	105.75	105.65	105.69	8200.0
2005-08-17 17:00:00	DIA	ETF	105.65	105.65	105.61	105.61	1100100.0
2005-08-17 18:00:00	DIA	ETF	105.65	105.65	105.65	105.65	2200.0
2005-08-17 19:00:00	DIA	ETF	105.65	105.65	105.65	105.65	1700.0
2005-08-17 08:00:00	GLD	ETF	44.15	44.28	44.03	44.28	64900.0
2005-08-17 09:00:00	GLD	ETF	44.25	44.4	44.13	44.16	272200.0
2005-08-17 10:00:00	GLD	ETF	44.14	44.254	44.09	44.19	678200.0
2005-08-17 11:00:00	GLD	ETF	44.19	44.2	43.83	43.9	287100.0
2005-08-17 12:00:00	GLD	ETF	43.91	43.94	43.72	43.87	307500.0
2005-08-17 13:00:00	GLD	ETF	43.86	43.96	43.82	43.91	178300.0

> showing 50 of 967 rows — these rows as CSV

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