PREVIEW / etf_1hour / 2005-08-02

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-02.parquet
  size:    31 KB
  rows:    934

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-02 07:00:00	SPY	ETF	123.93	123.93	123.81	123.81	51200.0
2005-08-02 08:00:00	SPY	ETF	123.81	123.93	123.79	123.9	1522900.0
2005-08-02 09:00:00	SPY	ETF	123.87	124.03	123.65	124.0	5472700.0
2005-08-02 10:00:00	SPY	ETF	123.99	124.41	123.93	124.24	13679200.0
2005-08-02 11:00:00	SPY	ETF	124.22	124.48	124.18	124.38	3880600.0
2005-08-02 12:00:00	SPY	ETF	124.38	124.56	124.27	124.34	3819600.0
2005-08-02 13:00:00	SPY	ETF	124.33	124.39	124.18	124.2	4075900.0
2005-08-02 14:00:00	SPY	ETF	124.2	124.46	124.18	124.36	4128400.0
2005-08-02 15:00:00	SPY	ETF	124.37	124.6	124.21	124.46	6222900.0
2005-08-02 16:00:00	SPY	ETF	124.45	124.47	124.26	124.33	1014400.0
2005-08-02 17:00:00	SPY	ETF	124.35	124.35	124.31	124.31	20700.0
2005-08-02 18:00:00	SPY	ETF	124.34	124.4	124.32	124.32	29700.0
2005-08-02 19:00:00	SPY	ETF	124.33	124.36	124.33	124.36	1100.0
2005-08-02 09:00:00	QQQ	ETF	39.71	39.8	39.65	39.76	8953100.0
2005-08-02 10:00:00	QQQ	ETF	39.77	40.1	39.73	39.99	22634200.0
2005-08-02 11:00:00	QQQ	ETF	39.99	40.08	39.95	40.07	7743900.0
2005-08-02 12:00:00	QQQ	ETF	40.07	40.12	39.85	40.04	7297400.0
2005-08-02 13:00:00	QQQ	ETF	40.04	40.08	39.98	40.0	6638500.0
2005-08-02 14:00:00	QQQ	ETF	40.01	40.1	39.99	40.04	6516400.0
2005-08-02 15:00:00	QQQ	ETF	40.03	40.14	39.85	40.07	11262000.0
2005-08-02 08:00:00	IWM	ETF	67.99	68.05	67.8	67.8	1900.0
2005-08-02 09:00:00	IWM	ETF	68.03	68.26	68.0	68.18	1178700.0
2005-08-02 10:00:00	IWM	ETF	68.19	68.42	68.1	68.22	3045800.0
2005-08-02 11:00:00	IWM	ETF	68.23	68.3	68.0	68.23	3042500.0
2005-08-02 12:00:00	IWM	ETF	68.24	68.38	68.17	68.21	1569200.0
2005-08-02 13:00:00	IWM	ETF	68.22	68.31	68.13	68.21	1112400.0
2005-08-02 14:00:00	IWM	ETF	68.21	68.48	68.2	68.42	2523300.0
2005-08-02 15:00:00	IWM	ETF	68.41	68.52	68.3	68.46	3677900.0
2005-08-02 16:00:00	IWM	ETF	68.45	68.46	68.3	68.32	111300.0
2005-08-02 17:00:00	IWM	ETF	68.33	68.35	68.32	68.32	3600.0
2005-08-02 18:00:00	IWM	ETF	68.32	68.32	68.32	68.32	500.0
2005-08-02 07:00:00	DIA	ETF	106.37	106.44	106.33	106.44	20600.0
2005-08-02 08:00:00	DIA	ETF	106.44	106.47	106.39	106.46	44400.0
2005-08-02 09:00:00	DIA	ETF	106.46	106.62	106.36	106.56	518600.0
2005-08-02 10:00:00	DIA	ETF	106.56	106.86	106.52	106.74	1181500.0
2005-08-02 11:00:00	DIA	ETF	106.73	107.0	106.68	106.91	356300.0
2005-08-02 12:00:00	DIA	ETF	106.89	106.99	106.76	106.81	379000.0
2005-08-02 13:00:00	DIA	ETF	106.81	106.86	106.63	106.64	333500.0
2005-08-02 14:00:00	DIA	ETF	106.65	106.82	106.63	106.7	704000.0
2005-08-02 15:00:00	DIA	ETF	106.7	106.89	106.58	106.81	789200.0
2005-08-02 16:00:00	DIA	ETF	106.81	106.81	106.7	106.73	8300.0
2005-08-02 09:00:00	GLD	ETF	43.1	43.12	43.03	43.03	105700.0
2005-08-02 10:00:00	GLD	ETF	43.03	43.09	42.99	43.08	113700.0
2005-08-02 11:00:00	GLD	ETF	43.08	43.15	43.07	43.11	90500.0
2005-08-02 12:00:00	GLD	ETF	43.12	43.12	43.01	43.07	96700.0
2005-08-02 13:00:00	GLD	ETF	43.09	43.13	43.07	43.09	26200.0
2005-08-02 14:00:00	GLD	ETF	43.1	43.14	43.08	43.09	56700.0
2005-08-02 15:00:00	GLD	ETF	43.09	43.15	43.08	43.14	65000.0
2005-08-02 08:00:00	TLT	ETF	92.13	92.26	92.12	92.12	57800.0
2005-08-02 09:00:00	TLT	ETF	92.15	92.38	92.15	92.3	241900.0

> showing 50 of 934 rows — these rows as CSV

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