PREVIEW / etf_1hour / 2006-07-14

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-07-14.parquet
  size:    50 KB
  rows:    1,578

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-07-14 06:00:00	SPY	ETF	124.32	124.35	124.25	124.25	100500.0
2006-07-14 07:00:00	SPY	ETF	124.28	124.28	123.95	124.04	123900.0
2006-07-14 08:00:00	SPY	ETF	123.5	124.4	123.5	124.31	2885500.0
2006-07-14 09:00:00	SPY	ETF	124.32	124.39	123.77	123.9	10939300.0
2006-07-14 10:00:00	SPY	ETF	123.9	124.24	123.77	123.8	15995800.0
2006-07-14 11:00:00	SPY	ETF	123.81	123.83	122.83	123.35	20380600.0
2006-07-14 12:00:00	SPY	ETF	123.35	123.66	123.09	123.47	9693900.0
2006-07-14 13:00:00	SPY	ETF	123.48	123.78	123.2	123.44	9767700.0
2006-07-14 14:00:00	SPY	ETF	123.44	123.6289	123.15	123.4	10415500.0
2006-07-14 15:00:00	SPY	ETF	123.42	123.87	123.26	123.63	14867900.0
2006-07-14 16:00:00	SPY	ETF	123.64	123.71	123.44	123.55	3136200.0
2006-07-14 17:00:00	SPY	ETF	123.55	123.6	123.5	123.6	48100.0
2006-07-14 18:00:00	SPY	ETF	123.6	123.68	123.6	123.68	11700.0
2006-07-14 09:00:00	QQQ	ETF	36.31	36.38	36.08	36.2	22351000.0
2006-07-14 10:00:00	QQQ	ETF	36.2	36.33	36.08	36.09	28562300.0
2006-07-14 11:00:00	QQQ	ETF	36.1	36.1	35.79	35.96	30737500.0
2006-07-14 12:00:00	QQQ	ETF	35.95	36.1	35.88	36.03	16393100.0
2006-07-14 13:00:00	QQQ	ETF	36.04	36.1	35.92	35.95	12483000.0
2006-07-14 14:00:00	QQQ	ETF	35.95	36.0	35.82	35.87	18348300.0
2006-07-14 15:00:00	QQQ	ETF	35.88	36.09	35.84	35.96	25639200.0
2006-07-14 08:00:00	IWM	ETF	68.1	68.13	67.71	68.13	188700.0
2006-07-14 09:00:00	IWM	ETF	68.15	68.21	67.67	67.82	11614600.0
2006-07-14 10:00:00	IWM	ETF	67.82	68.11	67.73	67.8	10208500.0
2006-07-14 11:00:00	IWM	ETF	67.8	67.8	66.95	67.59	16407800.0
2006-07-14 12:00:00	IWM	ETF	67.58	67.8	67.33	67.7	8202100.0
2006-07-14 13:00:00	IWM	ETF	67.69	67.97	67.42	67.6	6979500.0
2006-07-14 14:00:00	IWM	ETF	67.59	67.82	67.38	67.7	8292500.0
2006-07-14 15:00:00	IWM	ETF	67.7	68.07	67.5	67.65	11928200.0
2006-07-14 16:00:00	IWM	ETF	67.6	67.72	67.49	67.49	946900.0
2006-07-14 17:00:00	IWM	ETF	67.49	67.49	67.49	67.49	1400.0
2006-07-14 18:00:00	IWM	ETF	67.53	67.61	67.53	67.61	200.0
2006-07-14 07:00:00	DIA	ETF	108.35	108.35	108.35	108.35	1000.0
2006-07-14 08:00:00	DIA	ETF	108.34	108.56	108.2	108.54	197200.0
2006-07-14 09:00:00	DIA	ETF	108.55	108.6	107.85	107.92	1305700.0
2006-07-14 10:00:00	DIA	ETF	107.92	108.12	107.7	107.76	1253000.0
2006-07-14 11:00:00	DIA	ETF	107.75	107.75	107.01	107.49	1450800.0
2006-07-14 12:00:00	DIA	ETF	107.5	107.65	107.27	107.5415	744800.0
2006-07-14 13:00:00	DIA	ETF	107.54	107.66	107.29	107.36	840100.0
2006-07-14 14:00:00	DIA	ETF	107.35	107.4125	107.11	107.32	857800.0
2006-07-14 15:00:00	DIA	ETF	107.31	107.64	107.12	107.47	1409800.0
2006-07-14 16:00:00	DIA	ETF	107.47	107.47	107.3	107.44	76900.0
2006-07-14 17:00:00	DIA	ETF	107.5	107.5	107.3	107.35	1600.0
2006-07-14 18:00:00	DIA	ETF	107.45	107.45	107.45	107.45	100.0
2006-07-14 19:00:00	DIA	ETF	107.46	107.46	107.43	107.43	400.0
2006-07-14 07:00:00	GLD	ETF	65.62	65.8	65.62	65.7	4000.0
2006-07-14 08:00:00	GLD	ETF	65.77	66.12	65.73	65.87	182800.0
2006-07-14 09:00:00	GLD	ETF	65.84	66.05	65.7	65.78	1438000.0
2006-07-14 10:00:00	GLD	ETF	65.76	66.38	65.76	66.3	1963300.0
2006-07-14 11:00:00	GLD	ETF	66.28	66.32	65.88	66.15	2313500.0
2006-07-14 12:00:00	GLD	ETF	66.13	66.35	66.05	66.14	860600.0

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

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