PREVIEW / etf_1hour / 2006-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-21.parquet
  size:    59 KB
  rows:    1,823

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-21 06:00:00	SPY	ETF	142.37	142.37	142.37	142.37	1300.0
2006-12-21 08:00:00	SPY	ETF	142.34	142.5	141.95	142.27	1108800.0
2006-12-21 09:00:00	SPY	ETF	142.29	142.43	142.17	142.26	6619600.0
2006-12-21 10:00:00	SPY	ETF	142.26	142.33	141.95	141.96	7469000.0
2006-12-21 11:00:00	SPY	ETF	141.96	142.19	141.95	142.03	3515900.0
2006-12-21 12:00:00	SPY	ETF	142.03	142.04	141.46	141.57	8425500.0
2006-12-21 13:00:00	SPY	ETF	141.57	141.71	141.38	141.41	6568900.0
2006-12-21 14:00:00	SPY	ETF	141.4	141.7	141.32	141.57	4803200.0
2006-12-21 15:00:00	SPY	ETF	141.57	141.79	141.53	141.63	6479300.0
2006-12-21 16:00:00	SPY	ETF	141.63	141.7	141.52	141.69	1078900.0
2006-12-21 17:00:00	SPY	ETF	141.69	141.73	141.6	141.63	53000.0
2006-12-21 18:00:00	SPY	ETF	141.67	141.67	141.67	141.67	100.0
2006-12-21 19:00:00	SPY	ETF	141.68	141.68	141.68	141.68	300.0
2006-12-21 09:00:00	QQQ	ETF	43.75	43.78	43.62	43.65	18440700.0
2006-12-21 10:00:00	QQQ	ETF	43.66	43.78	43.61	43.67	12534800.0
2006-12-21 11:00:00	QQQ	ETF	43.67	43.79	43.66	43.7	7058400.0
2006-12-21 12:00:00	QQQ	ETF	43.69	43.7	43.3	43.38	21582300.0
2006-12-21 13:00:00	QQQ	ETF	43.38	43.46	43.28	43.29	12258600.0
2006-12-21 14:00:00	QQQ	ETF	43.29	43.45	43.21	43.4	12992200.0
2006-12-21 15:00:00	QQQ	ETF	43.4	43.49	43.37	43.38	12262300.0
2006-12-21 08:00:00	IWM	ETF	78.1	78.1	77.93	77.99	108400.0
2006-12-21 09:00:00	IWM	ETF	78.0	78.35	77.8	78.21	6344500.0
2006-12-21 10:00:00	IWM	ETF	78.2	78.35	78.09	78.21	7261600.0
2006-12-21 11:00:00	IWM	ETF	78.21	78.35	78.21	78.24	4496100.0
2006-12-21 12:00:00	IWM	ETF	78.24	78.24	77.62	77.66	12194300.0
2006-12-21 13:00:00	IWM	ETF	77.65	77.65	77.41	77.44	5823200.0
2006-12-21 14:00:00	IWM	ETF	77.45	77.65	77.31	77.49	8135100.0
2006-12-21 15:00:00	IWM	ETF	77.49	77.66	77.47	77.62	4175500.0
2006-12-21 16:00:00	IWM	ETF	77.62	77.74	77.53	77.63	993800.0
2006-12-21 17:00:00	IWM	ETF	77.63	77.63	77.55	77.55	1400.0
2006-12-21 08:00:00	DIA	ETF	124.51	124.54	124.42	124.49	19300.0
2006-12-21 09:00:00	DIA	ETF	124.48	124.6	124.39	124.45	762700.0
2006-12-21 10:00:00	DIA	ETF	124.44	124.5	124.27	124.28	904000.0
2006-12-21 11:00:00	DIA	ETF	124.28	124.44	124.25	124.34	397000.0
2006-12-21 12:00:00	DIA	ETF	124.33	124.33	123.83	123.85	1453400.0
2006-12-21 13:00:00	DIA	ETF	123.85	124.04	123.72	123.83	824500.0
2006-12-21 14:00:00	DIA	ETF	123.81	124.08	123.76	123.97	620800.0
2006-12-21 15:00:00	DIA	ETF	123.96	124.14	123.93	124.02	811600.0
2006-12-21 16:00:00	DIA	ETF	124.04	124.1	123.99	124.08	171700.0
2006-12-21 08:00:00	GLD	ETF	61.49	61.73	61.48	61.58	50000.0
2006-12-21 09:00:00	GLD	ETF	61.6	61.67	61.48	61.52	352800.0
2006-12-21 10:00:00	GLD	ETF	61.5128	61.7	61.48	61.6209	489200.0
2006-12-21 11:00:00	GLD	ETF	61.6398	61.66	61.51	61.55	216700.0
2006-12-21 12:00:00	GLD	ETF	61.55	61.61	61.27	61.31	568900.0
2006-12-21 13:00:00	GLD	ETF	61.31	61.43	61.29	61.36	274800.0
2006-12-21 14:00:00	GLD	ETF	61.33	61.39	61.31	61.375	212300.0
2006-12-21 15:00:00	GLD	ETF	61.39	61.46	61.29	61.33	304800.0
2006-12-21 16:00:00	GLD	ETF	61.38	61.38	61.35	61.35	500.0
2006-12-21 08:00:00	TLT	ETF	89.78	89.78	89.7	89.72	10800.0
2006-12-21 09:00:00	TLT	ETF	89.71	89.72	89.67	89.69	37100.0

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

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