PREVIEW / etf_1hour / 2006-05-17

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-05-17.parquet
  size:    47 KB
  rows:    1,397

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-17 04:00:00	SPY	ETF	129.59	129.59	129.59	129.59	500.0
2006-05-17 07:00:00	SPY	ETF	129.47	129.63	129.46	129.6	119400.0
2006-05-17 08:00:00	SPY	ETF	129.4	129.73	128.49	128.63	6849400.0
2006-05-17 09:00:00	SPY	ETF	128.63	129.1	128.43	128.83	15843200.0
2006-05-17 10:00:00	SPY	ETF	128.82	128.92	128.35	128.62	16895600.0
2006-05-17 11:00:00	SPY	ETF	128.63	128.65	127.29	127.76	26986300.0
2006-05-17 12:00:00	SPY	ETF	127.75	128.81	127.66	127.9	12055800.0
2006-05-17 13:00:00	SPY	ETF	127.91	128.08	127.46	127.82	14290900.0
2006-05-17 14:00:00	SPY	ETF	127.81	127.84	126.95	127.18	17865000.0
2006-05-17 15:00:00	SPY	ETF	127.18	127.79	127.16	127.2	22164400.0
2006-05-17 16:00:00	SPY	ETF	127.19	129.4	126.76	126.79	3389600.0
2006-05-17 17:00:00	SPY	ETF	126.82	126.88	126.8	126.86	44500.0
2006-05-17 18:00:00	SPY	ETF	126.86	126.89	126.84	126.89	4300.0
2006-05-17 19:00:00	SPY	ETF	126.9	127.05	126.9	127.05	9100.0
2006-05-17 09:00:00	QQQ	ETF	39.67	39.81	39.58	39.69	28708600.0
2006-05-17 10:00:00	QQQ	ETF	39.69	39.74	39.55	39.61	21778700.0
2006-05-17 11:00:00	QQQ	ETF	39.6	39.63	39.23	39.4	41310300.0
2006-05-17 12:00:00	QQQ	ETF	39.4	39.58	39.4	39.49	20586700.0
2006-05-17 13:00:00	QQQ	ETF	39.48	39.56	39.36	39.52	16422400.0
2006-05-17 14:00:00	QQQ	ETF	39.52	39.54	39.25	39.34	19955900.0
2006-05-17 15:00:00	QQQ	ETF	39.34	39.98	39.31	39.32	34261600.0
2006-05-17 08:00:00	IWM	ETF	73.48	73.48	72.62	72.65	1464600.0
2006-05-17 09:00:00	IWM	ETF	72.66	73.14	72.38	72.83	10375400.0
2006-05-17 10:00:00	IWM	ETF	72.82	72.89	72.44	72.67	9664900.0
2006-05-17 11:00:00	IWM	ETF	72.66	72.69	71.85	72.03	12570500.0
2006-05-17 12:00:00	IWM	ETF	72.03	72.65	72.03	72.46	7856100.0
2006-05-17 13:00:00	IWM	ETF	72.46	72.65	72.18	72.59	7402400.0
2006-05-17 14:00:00	IWM	ETF	72.61	72.63	71.94	72.14	6907900.0
2006-05-17 15:00:00	IWM	ETF	72.15	72.46	72.1	72.18	11266400.0
2006-05-17 16:00:00	IWM	ETF	72.17	72.19	71.9	71.9	2897300.0
2006-05-17 17:00:00	IWM	ETF	71.88	71.96	71.88	71.9	2529400.0
2006-05-17 18:00:00	IWM	ETF	71.92	71.92	71.92	71.92	3400.0
2006-05-17 19:00:00	IWM	ETF	71.97	71.97	71.97	71.97	5000.0
2006-05-17 07:00:00	DIA	ETF	114.53	114.53	114.53	114.53	600.0
2006-05-17 08:00:00	DIA	ETF	114.55	114.6	113.66	113.75	57100.0
2006-05-17 09:00:00	DIA	ETF	113.7	113.84	113.55	113.61	1471000.0
2006-05-17 10:00:00	DIA	ETF	113.56	113.61	113.18	113.38	1815500.0
2006-05-17 11:00:00	DIA	ETF	113.4	113.43	112.42	112.72	4687100.0
2006-05-17 12:00:00	DIA	ETF	112.72	112.94	112.59	112.69	1344300.0
2006-05-17 13:00:00	DIA	ETF	112.69	112.83	112.28	112.61	1803500.0
2006-05-17 14:00:00	DIA	ETF	112.61	112.62	111.93	112.1	2519300.0
2006-05-17 15:00:00	DIA	ETF	112.1	112.64	112.1	112.23	3164500.0
2006-05-17 16:00:00	DIA	ETF	112.23	112.23	111.92	112.0	294300.0
2006-05-17 17:00:00	DIA	ETF	112.12	112.13	112.12	112.13	1200.0
2006-05-17 04:00:00	GLD	ETF	68.83	70.0	68.83	70.0	1700.0
2006-05-17 06:00:00	GLD	ETF	70.7	70.7	70.7	70.7	400.0
2006-05-17 07:00:00	GLD	ETF	70.7	70.8	70.41	70.48	148100.0
2006-05-17 08:00:00	GLD	ETF	70.5	70.77	69.97	70.41	807200.0
2006-05-17 09:00:00	GLD	ETF	70.4	70.42	69.24	69.98	3594400.0
2006-05-17 10:00:00	GLD	ETF	70.0	70.0	68.64	69.31	2997200.0

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

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