PREVIEW / etf_1hour / 2006-05-08

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-08.parquet
  size:    42 KB
  rows:    1,350

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-05-08 07:00:00	SPY	ETF	132.61	132.62	132.5	132.6	49600.0
2006-05-08 08:00:00	SPY	ETF	132.59	132.66	132.54	132.62	295200.0
2006-05-08 09:00:00	SPY	ETF	132.6	132.77	132.46	132.69	3898700.0
2006-05-08 10:00:00	SPY	ETF	132.69	132.77	132.45	132.49	5004000.0
2006-05-08 11:00:00	SPY	ETF	132.47	132.57	132.37	132.47	5132100.0
2006-05-08 12:00:00	SPY	ETF	132.46	132.66	132.42	132.6	2505700.0
2006-05-08 13:00:00	SPY	ETF	132.6	132.65	132.55	132.62	1089300.0
2006-05-08 14:00:00	SPY	ETF	132.62	132.77	132.57	132.71	2427400.0
2006-05-08 15:00:00	SPY	ETF	132.72	132.73	132.51	132.56	3644600.0
2006-05-08 16:00:00	SPY	ETF	132.55	132.57	132.34	132.36	2860100.0
2006-05-08 17:00:00	SPY	ETF	132.37	132.38	132.36	132.38	5700.0
2006-05-08 18:00:00	SPY	ETF	132.39	132.39	132.39	132.39	600.0
2006-05-08 19:00:00	SPY	ETF	132.37	132.38	132.37	132.38	800.0
2006-05-08 09:00:00	QQQ	ETF	42.1	42.26	42.07	42.23	9907600.0
2006-05-08 10:00:00	QQQ	ETF	42.24	42.28	42.13	42.15	7868700.0
2006-05-08 11:00:00	QQQ	ETF	42.15	42.21	42.1	42.16	5778100.0
2006-05-08 12:00:00	QQQ	ETF	42.15	42.25	42.13	42.22	3575300.0
2006-05-08 13:00:00	QQQ	ETF	42.22	42.23	42.17	42.18	1499400.0
2006-05-08 14:00:00	QQQ	ETF	42.19	42.25	42.18	42.23	4117700.0
2006-05-08 15:00:00	QQQ	ETF	42.22	42.23	42.16	42.19	4969300.0
2006-05-08 06:00:00	IWM	ETF	77.5	77.5	77.5	77.5	500.0
2006-05-08 07:00:00	IWM	ETF	77.15	77.5	77.15	77.5	600.0
2006-05-08 08:00:00	IWM	ETF	77.52	77.62	77.52	77.59	15900.0
2006-05-08 09:00:00	IWM	ETF	77.59	77.74	77.39	77.59	4020100.0
2006-05-08 10:00:00	IWM	ETF	77.59	77.78	77.45	77.48	3609100.0
2006-05-08 11:00:00	IWM	ETF	77.48	77.64	77.33	77.5	3700900.0
2006-05-08 12:00:00	IWM	ETF	77.49	77.74	77.47	77.69	2720800.0
2006-05-08 13:00:00	IWM	ETF	77.69	77.72	77.61	77.67	2539800.0
2006-05-08 14:00:00	IWM	ETF	77.67	77.81	77.63	77.71	2090400.0
2006-05-08 15:00:00	IWM	ETF	77.71	77.72	77.53	77.64	4366000.0
2006-05-08 16:00:00	IWM	ETF	77.64	77.67	77.4	77.62	1301200.0
2006-05-08 17:00:00	IWM	ETF	77.52	77.59	77.52	77.59	5100.0
2006-05-08 19:00:00	IWM	ETF	77.53	77.58	77.53	77.58	10700.0
2006-05-08 07:00:00	DIA	ETF	115.72	115.72	115.72	115.72	5000.0
2006-05-08 08:00:00	DIA	ETF	115.72	115.76	115.67	115.73	10400.0
2006-05-08 09:00:00	DIA	ETF	115.74	116.0	115.63	115.89	1326400.0
2006-05-08 10:00:00	DIA	ETF	115.89	116.0	115.75	115.77	543900.0
2006-05-08 11:00:00	DIA	ETF	115.78	115.83	115.65	115.74	502900.0
2006-05-08 12:00:00	DIA	ETF	115.72	115.91	115.72	115.86	245400.0
2006-05-08 13:00:00	DIA	ETF	115.86	115.91	115.84	115.87	120900.0
2006-05-08 14:00:00	DIA	ETF	115.88	115.98	115.84	115.92	226100.0
2006-05-08 15:00:00	DIA	ETF	115.91	115.91	115.76	115.79	464900.0
2006-05-08 16:00:00	DIA	ETF	115.78	115.8	115.76	115.76	37600.0
2006-05-08 07:00:00	GLD	ETF	67.4	67.4	67.27	67.27	13500.0
2006-05-08 08:00:00	GLD	ETF	67.34	67.62	67.13	67.59	347700.0
2006-05-08 09:00:00	GLD	ETF	67.6	67.67	67.14	67.18	1331100.0
2006-05-08 10:00:00	GLD	ETF	67.19	67.31	66.75	67.23	1979800.0
2006-05-08 11:00:00	GLD	ETF	67.22	67.58	67.2	67.54	1040000.0
2006-05-08 12:00:00	GLD	ETF	67.54	67.59	67.22	67.3701	613500.0
2006-05-08 13:00:00	GLD	ETF	67.39	67.53	67.3	67.39	422700.0

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

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