PREVIEW / etf_1hour / 2006-12-13

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-13.parquet
  size:    56 KB
  rows:    1,783

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-13 05:00:00	SPY	ETF	141.95	141.95	141.95	141.95	400.0
2006-12-13 07:00:00	SPY	ETF	142.02	142.1	141.97	142.1	40800.0
2006-12-13 08:00:00	SPY	ETF	142.1	142.3	141.97	142.28	2472800.0
2006-12-13 09:00:00	SPY	ETF	142.26	142.34	141.96	142.07	8400300.0
2006-12-13 10:00:00	SPY	ETF	142.08	142.11	141.56	141.85	11498600.0
2006-12-13 11:00:00	SPY	ETF	141.84	142.17	141.76	142.0	4451800.0
2006-12-13 12:00:00	SPY	ETF	142.02	142.02	141.7	141.84	3562100.0
2006-12-13 13:00:00	SPY	ETF	141.82	141.94	141.61	141.76	3334000.0
2006-12-13 14:00:00	SPY	ETF	141.75	141.87	141.62	141.67	8809900.0
2006-12-13 15:00:00	SPY	ETF	141.6706	141.99	141.63	141.85	8227600.0
2006-12-13 16:00:00	SPY	ETF	141.87	142.0707	141.79	141.86	2372800.0
2006-12-13 17:00:00	SPY	ETF	141.85	141.87	141.78	141.81	104600.0
2006-12-13 18:00:00	SPY	ETF	141.82	141.88	141.82	141.88	6800.0
2006-12-13 19:00:00	SPY	ETF	141.86	141.86	141.86	141.86	1000.0
2006-12-13 09:00:00	QQQ	ETF	44.1	44.11	43.9	43.91	13250200.0
2006-12-13 10:00:00	QQQ	ETF	43.92	43.93	43.62	43.78	17216900.0
2006-12-13 11:00:00	QQQ	ETF	43.78	43.87	43.72	43.83	7481500.0
2006-12-13 12:00:00	QQQ	ETF	43.83	43.84	43.63	43.73	8257700.0
2006-12-13 13:00:00	QQQ	ETF	43.73	43.8	43.62	43.76	6408900.0
2006-12-13 14:00:00	QQQ	ETF	43.76	43.82	43.67	43.75	8717100.0
2006-12-13 15:00:00	QQQ	ETF	43.75	43.89	43.72	43.88	9289400.0
2006-12-13 07:00:00	IWM	ETF	78.77	78.79	78.77	78.77	10500.0
2006-12-13 08:00:00	IWM	ETF	78.77	78.94	78.71	78.93	168300.0
2006-12-13 09:00:00	IWM	ETF	78.93	79.0	78.76	78.84	4370500.0
2006-12-13 10:00:00	IWM	ETF	78.84	78.95	78.34	78.52	7547900.0
2006-12-13 11:00:00	IWM	ETF	78.53	78.65	78.47	78.63	3187500.0
2006-12-13 12:00:00	IWM	ETF	78.63	78.63	78.34	78.44	2935100.0
2006-12-13 13:00:00	IWM	ETF	78.44	78.58	78.15	78.43	3958900.0
2006-12-13 14:00:00	IWM	ETF	78.43	78.54	78.3	78.41	8993400.0
2006-12-13 15:00:00	IWM	ETF	78.4	78.55	78.35	78.54	5053900.0
2006-12-13 16:00:00	IWM	ETF	78.54	78.67	78.4718	78.65	6591500.0
2006-12-13 17:00:00	IWM	ETF	78.64	78.65	78.64	78.64	30400.0
2006-12-13 19:00:00	IWM	ETF	78.65	78.65	78.65	78.65	500.0
2006-12-13 07:00:00	DIA	ETF	123.47	123.47	123.47	123.47	3000.0
2006-12-13 08:00:00	DIA	ETF	123.48	123.65	123.46	123.63	70300.0
2006-12-13 09:00:00	DIA	ETF	123.64	123.74	123.54	123.6	890600.0
2006-12-13 10:00:00	DIA	ETF	123.6	123.61	123.11	123.38	921800.0
2006-12-13 11:00:00	DIA	ETF	123.39	123.45	123.3	123.45	311700.0
2006-12-13 12:00:00	DIA	ETF	123.45	123.48	123.2095	123.3	327400.0
2006-12-13 13:00:00	DIA	ETF	123.3	123.39	123.06	123.2	502500.0
2006-12-13 14:00:00	DIA	ETF	123.21	123.31	123.11	123.17	431000.0
2006-12-13 15:00:00	DIA	ETF	123.16	123.35	123.12	123.24	935900.0
2006-12-13 16:00:00	DIA	ETF	123.27	123.5431	123.26	123.33	30500.0
2006-12-13 17:00:00	DIA	ETF	123.35	123.35	123.35	123.35	1900.0
2006-12-13 08:00:00	GLD	ETF	62.31	62.39	62.15	62.21	125600.0
2006-12-13 09:00:00	GLD	ETF	62.26	62.28	61.88	61.91	1284400.0
2006-12-13 10:00:00	GLD	ETF	61.9	62.34	61.88	62.26	695600.0
2006-12-13 11:00:00	GLD	ETF	62.27	62.57	62.23	62.47	532800.0
2006-12-13 12:00:00	GLD	ETF	62.4612	62.4888	62.38	62.38	380900.0
2006-12-13 13:00:00	GLD	ETF	62.38	62.43	62.32	62.3644	170300.0

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

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