PREVIEW / etf_1hour / 2005-08-03

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-03.parquet
  size:    30 KB
  rows:    936

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-03 06:00:00	SPY	ETF	124.31	124.31	124.31	124.31	500.0
2005-08-03 07:00:00	SPY	ETF	124.32	124.34	124.3	124.34	27400.0
2005-08-03 08:00:00	SPY	ETF	124.33	124.35	124.16	124.17	378800.0
2005-08-03 09:00:00	SPY	ETF	124.18	124.35	124.14	124.18	3645100.0
2005-08-03 10:00:00	SPY	ETF	124.17	124.5	124.12	124.4	6651000.0
2005-08-03 11:00:00	SPY	ETF	124.41	124.58	124.33	124.49	3014600.0
2005-08-03 12:00:00	SPY	ETF	124.48	124.74	124.44	124.54	3896100.0
2005-08-03 13:00:00	SPY	ETF	124.54	124.66	124.46	124.55	2212000.0
2005-08-03 14:00:00	SPY	ETF	124.55	124.63	124.26	124.36	7625600.0
2005-08-03 15:00:00	SPY	ETF	124.35	124.7	124.24	124.64	6697200.0
2005-08-03 16:00:00	SPY	ETF	124.65	124.74	124.6	124.7	1425000.0
2005-08-03 17:00:00	SPY	ETF	124.7	124.77	124.7	124.71	11900.0
2005-08-03 18:00:00	SPY	ETF	124.73	124.73	124.73	124.73	8700.0
2005-08-03 19:00:00	SPY	ETF	124.73	124.74	124.73	124.73	1400.0
2005-08-03 09:00:00	QQQ	ETF	39.91	39.95	39.88	39.89	7641700.0
2005-08-03 10:00:00	QQQ	ETF	39.89	40.04	39.88	39.97	14666200.0
2005-08-03 11:00:00	QQQ	ETF	39.97	40.01	39.92	39.98	5970800.0
2005-08-03 12:00:00	QQQ	ETF	39.98	40.13	39.97	40.06	9236500.0
2005-08-03 13:00:00	QQQ	ETF	40.06	40.11	40.03	40.08	3369200.0
2005-08-03 14:00:00	QQQ	ETF	40.08	40.11	39.94	39.99	8893200.0
2005-08-03 15:00:00	QQQ	ETF	40.0	40.07	39.94	40.06	8133200.0
2005-08-03 08:00:00	IWM	ETF	68.35	68.35	68.29	68.29	2000.0
2005-08-03 09:00:00	IWM	ETF	68.24	68.25	68.07	68.08	1585100.0
2005-08-03 10:00:00	IWM	ETF	68.08	68.15	67.87	67.98	4873800.0
2005-08-03 11:00:00	IWM	ETF	67.98	68.15	67.94	68.11	1148800.0
2005-08-03 12:00:00	IWM	ETF	68.11	68.31	68.08	68.2	1431900.0
2005-08-03 13:00:00	IWM	ETF	68.2	68.24	68.09	68.18	1119100.0
2005-08-03 14:00:00	IWM	ETF	68.18	68.25	67.94	67.98	1628400.0
2005-08-03 15:00:00	IWM	ETF	67.98	68.09	67.9	67.99	2944300.0
2005-08-03 16:00:00	IWM	ETF	67.95	68.04	67.94	67.97	858100.0
2005-08-03 17:00:00	IWM	ETF	68.0	68.0	68.0	68.0	100.0
2005-08-03 18:00:00	IWM	ETF	68.04	68.04	68.04	68.04	4000.0
2005-08-03 07:00:00	DIA	ETF	106.64	106.64	106.64	106.64	3300.0
2005-08-03 08:00:00	DIA	ETF	106.6	106.6	106.5	106.5	6300.0
2005-08-03 09:00:00	DIA	ETF	106.51	106.57	106.4	106.42	600400.0
2005-08-03 10:00:00	DIA	ETF	106.41	106.68	106.37	106.61	686800.0
2005-08-03 11:00:00	DIA	ETF	106.61	106.77	106.57	106.68	310900.0
2005-08-03 12:00:00	DIA	ETF	106.68	106.92	106.68	106.79	314900.0
2005-08-03 13:00:00	DIA	ETF	106.79	106.89	106.75	106.81	213300.0
2005-08-03 14:00:00	DIA	ETF	106.8	106.86	106.64	106.69	335200.0
2005-08-03 15:00:00	DIA	ETF	106.7	106.98	106.59	106.95	725400.0
2005-08-03 16:00:00	DIA	ETF	106.95	107.09	106.95	107.09	30600.0
2005-08-03 17:00:00	DIA	ETF	107.05	107.1	107.05	107.1	2000.0
2005-08-03 18:00:00	DIA	ETF	107.14	107.18	107.14	107.18	700.0
2005-08-03 19:00:00	DIA	ETF	107.15	107.15	107.15	107.15	100.0
2005-08-03 08:00:00	GLD	ETF	43.42	43.42	43.42	43.42	19700.0
2005-08-03 09:00:00	GLD	ETF	43.37	43.41	43.35	43.36	247800.0
2005-08-03 10:00:00	GLD	ETF	43.36	43.44	43.35	43.42	423000.0
2005-08-03 11:00:00	GLD	ETF	43.43	43.58	43.42	43.55	231200.0
2005-08-03 12:00:00	GLD	ETF	43.55	43.62	43.53	43.6	337300.0

> showing 50 of 936 rows — these rows as CSV

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