PREVIEW / etf_1hour / 2006-12-14

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-14.parquet
  size:    57 KB
  rows:    1,814

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-12-14 07:00:00	SPY	ETF	141.71	141.78	141.71	141.72	108900.0
2006-12-14 08:00:00	SPY	ETF	141.75	142.04	141.68	141.89	3075700.0
2006-12-14 09:00:00	SPY	ETF	141.91	142.81	141.84	142.69	11947200.0
2006-12-14 10:00:00	SPY	ETF	142.7	142.98	142.53	142.77	17472400.0
2006-12-14 11:00:00	SPY	ETF	142.76	142.86	142.68	142.76	5744700.0
2006-12-14 12:00:00	SPY	ETF	142.76	142.9	142.68	142.86	4802100.0
2006-12-14 13:00:00	SPY	ETF	142.85	143.0	142.77	142.91	4107600.0
2006-12-14 14:00:00	SPY	ETF	142.91	143.19	142.84	143.15	6064400.0
2006-12-14 15:00:00	SPY	ETF	143.14	143.24	142.96	142.98	8814800.0
2006-12-14 16:00:00	SPY	ETF	142.99	143.19	142.8221	143.15	1048300.0
2006-12-14 17:00:00	SPY	ETF	143.16	143.18	143.06	143.1	23800.0
2006-12-14 18:00:00	SPY	ETF	143.1	143.19	143.1	143.15	23500.0
2006-12-14 19:00:00	SPY	ETF	143.14	143.15	143.13	143.15	1400.0
2006-12-14 09:00:00	QQQ	ETF	43.97	44.44	43.94	44.41	21100900.0
2006-12-14 10:00:00	QQQ	ETF	44.41	44.57	44.35	44.52	33537900.0
2006-12-14 11:00:00	QQQ	ETF	44.52	44.55	44.42	44.46	6648500.0
2006-12-14 12:00:00	QQQ	ETF	44.46	44.49	44.37	44.42	7474300.0
2006-12-14 13:00:00	QQQ	ETF	44.43	44.5	44.4	44.44	6636200.0
2006-12-14 14:00:00	QQQ	ETF	44.44	44.53	44.41	44.53	7460600.0
2006-12-14 15:00:00	QQQ	ETF	44.53	44.53	44.34	44.37	15563300.0
2006-12-14 08:00:00	IWM	ETF	78.52	78.73	78.52	78.73	1006900.0
2006-12-14 09:00:00	IWM	ETF	78.69	79.45	78.56	79.34	8539800.0
2006-12-14 10:00:00	IWM	ETF	79.33	79.59	79.17	79.26	19514200.0
2006-12-14 11:00:00	IWM	ETF	79.24	79.32	79.15	79.16	2072200.0
2006-12-14 12:00:00	IWM	ETF	79.16	79.27	79.1	79.19	4375900.0
2006-12-14 13:00:00	IWM	ETF	79.2	79.32	79.13	79.2	2684600.0
2006-12-14 14:00:00	IWM	ETF	79.2	79.32	79.16	79.28	3841100.0
2006-12-14 15:00:00	IWM	ETF	79.27	79.3	79.0	79.05	5878600.0
2006-12-14 16:00:00	IWM	ETF	79.07	79.2	78.7408	79.04	3429600.0
2006-12-14 18:00:00	IWM	ETF	79.02	79.05	79.02	79.05	7900.0
2006-12-14 07:00:00	DIA	ETF	123.3	123.3	123.3	123.3	400.0
2006-12-14 08:00:00	DIA	ETF	123.3	123.37	123.22	123.22	4900.0
2006-12-14 09:00:00	DIA	ETF	123.33	124.13	123.2	123.83	881600.0
2006-12-14 10:00:00	DIA	ETF	123.83	124.05	123.73	123.93	1889100.0
2006-12-14 11:00:00	DIA	ETF	123.92	123.97	123.82	123.86	512000.0
2006-12-14 12:00:00	DIA	ETF	123.87	123.94	123.79	123.91	386900.0
2006-12-14 13:00:00	DIA	ETF	123.91	124.09	123.85	124.06	709600.0
2006-12-14 14:00:00	DIA	ETF	124.06	124.36	123.98	124.3	1057800.0
2006-12-14 15:00:00	DIA	ETF	124.3	124.38	124.16	124.21	1274400.0
2006-12-14 16:00:00	DIA	ETF	124.21	124.27	123.835	124.27	43900.0
2006-12-14 17:00:00	DIA	ETF	124.3	124.3	124.3	124.3	100.0
2006-12-14 07:00:00	GLD	ETF	62.42	62.43	62.42	62.43	2000.0
2006-12-14 08:00:00	GLD	ETF	62.34	62.45	62.22	62.32	23800.0
2006-12-14 09:00:00	GLD	ETF	62.36	62.38	62.22	62.27	476900.0
2006-12-14 10:00:00	GLD	ETF	62.25	62.47	62.07	62.4	537500.0
2006-12-14 11:00:00	GLD	ETF	62.39	62.45	62.3	62.43	316000.0
2006-12-14 12:00:00	GLD	ETF	62.43	62.44	62.17	62.21	235800.0
2006-12-14 13:00:00	GLD	ETF	62.21	62.25	62.17	62.2	107800.0
2006-12-14 14:00:00	GLD	ETF	62.2	62.27	62.04	62.16	275600.0
2006-12-14 15:00:00	GLD	ETF	62.16	62.2	62.08	62.08	250600.0

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

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