PREVIEW / etf_1hour / 2006-08-17

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-08-17.parquet
  size:    52 KB
  rows:    1,622

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-08-17 07:00:00	SPY	ETF	129.74	129.74	129.58	129.58	17300.0
2006-08-17 08:00:00	SPY	ETF	129.61	129.76	129.49	129.62	1262100.0
2006-08-17 09:00:00	SPY	ETF	129.6	129.8	129.49	129.75	7185500.0
2006-08-17 10:00:00	SPY	ETF	129.75	129.94	129.66	129.91	9506500.0
2006-08-17 11:00:00	SPY	ETF	129.91	130.16	129.83	130.05	8224400.0
2006-08-17 12:00:00	SPY	ETF	130.05	130.3	129.92	130.26	8829700.0
2006-08-17 13:00:00	SPY	ETF	130.25	130.37	129.91	129.96	9091200.0
2006-08-17 14:00:00	SPY	ETF	129.96	130.08	129.64	129.92	11665600.0
2006-08-17 15:00:00	SPY	ETF	129.92	130.1	129.88	130.0	9076300.0
2006-08-17 16:00:00	SPY	ETF	130.01	130.07	129.8118	129.97	3717700.0
2006-08-17 17:00:00	SPY	ETF	129.98	129.99	128.8933	128.8933	1392900.0
2006-08-17 18:00:00	SPY	ETF	129.92	129.98	129.91	129.95	41300.0
2006-08-17 19:00:00	SPY	ETF	129.92	129.92	129.9	129.9	38700.0
2006-08-17 09:00:00	QQQ	ETF	38.47	38.63	38.44	38.6	13318600.0
2006-08-17 10:00:00	QQQ	ETF	38.61	38.8	38.59	38.79	20802600.0
2006-08-17 11:00:00	QQQ	ETF	38.78	38.91	38.74	38.83	17055500.0
2006-08-17 12:00:00	QQQ	ETF	38.82	38.97	38.65	38.95	11582800.0
2006-08-17 13:00:00	QQQ	ETF	38.95	38.98	38.72	38.73	12963400.0
2006-08-17 14:00:00	QQQ	ETF	38.72	38.76	38.5	38.65	27393000.0
2006-08-17 15:00:00	QQQ	ETF	38.65	38.77	38.61	38.72	17137000.0
2006-08-17 07:00:00	IWM	ETF	70.3	70.4	70.2	70.3	900.0
2006-08-17 08:00:00	IWM	ETF	70.33	70.34	70.16	70.24	48200.0
2006-08-17 09:00:00	IWM	ETF	70.23	70.51	70.13	70.3695	4042200.0
2006-08-17 10:00:00	IWM	ETF	70.37	70.7	70.34	70.7	7033500.0
2006-08-17 11:00:00	IWM	ETF	70.7	71.04	70.64	70.84	13415700.0
2006-08-17 12:00:00	IWM	ETF	70.84	71.04	70.74	71.02	4360100.0
2006-08-17 13:00:00	IWM	ETF	71.02	71.1	70.69	70.74	3596300.0
2006-08-17 14:00:00	IWM	ETF	70.74	70.93	70.44	70.56	5891600.0
2006-08-17 15:00:00	IWM	ETF	70.56	70.8	70.56	70.66	5082700.0
2006-08-17 16:00:00	IWM	ETF	70.66	70.73	70.53	70.53	358900.0
2006-08-17 17:00:00	IWM	ETF	70.64	70.64	70.58	70.58	6600.0
2006-08-17 18:00:00	IWM	ETF	70.62	70.63	70.57	70.57	37000.0
2006-08-17 19:00:00	IWM	ETF	70.55	70.55	70.5	70.5	39400.0
2006-08-17 08:00:00	DIA	ETF	113.32	113.38	113.23	113.38	62700.0
2006-08-17 09:00:00	DIA	ETF	113.33	113.53	113.19	113.52	484600.0
2006-08-17 10:00:00	DIA	ETF	113.53	113.64	113.44	113.63	1040300.0
2006-08-17 11:00:00	DIA	ETF	113.63	113.77	113.57	113.67	697700.0
2006-08-17 12:00:00	DIA	ETF	113.68	113.86	113.57	113.85	800900.0
2006-08-17 13:00:00	DIA	ETF	113.86	113.88	113.5	113.54	500700.0
2006-08-17 14:00:00	DIA	ETF	113.54	113.62	113.29	113.53	707600.0
2006-08-17 15:00:00	DIA	ETF	113.54	113.67	113.46	113.5	591400.0
2006-08-17 16:00:00	DIA	ETF	113.49	113.52	113.36	113.47	605800.0
2006-08-17 17:00:00	DIA	ETF	113.49	113.5	113.4	113.45	8700.0
2006-08-17 18:00:00	DIA	ETF	113.45	113.45	113.45	113.45	400.0
2006-08-17 19:00:00	DIA	ETF	113.4	113.4	113.4	113.4	100.0
2006-08-17 08:00:00	GLD	ETF	62.7	62.78	62.5	62.52	33600.0
2006-08-17 09:00:00	GLD	ETF	62.51	62.55	62.01	62.15	487000.0
2006-08-17 10:00:00	GLD	ETF	62.16	62.24	61.84	61.959	687500.0
2006-08-17 11:00:00	GLD	ETF	61.972	62.12	61.68	61.88	630900.0
2006-08-17 12:00:00	GLD	ETF	61.87	61.97	61.16	61.16	892100.0

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

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