PREVIEW / etf_1hour / 2006-12-19

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-19.parquet
  size:    60 KB
  rows:    1,869

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-19 06:00:00	SPY	ETF	141.62	141.62	141.62	141.62	24800.0
2006-12-19 07:00:00	SPY	ETF	141.62	141.77	141.47	141.75	205300.0
2006-12-19 08:00:00	SPY	ETF	141.58	141.8	141.37	141.59	3151100.0
2006-12-19 09:00:00	SPY	ETF	141.59	141.68	141.19	141.51	16024700.0
2006-12-19 10:00:00	SPY	ETF	141.51	141.93	141.48	141.88	9645300.0
2006-12-19 11:00:00	SPY	ETF	141.9	142.01	141.56	141.62	6212700.0
2006-12-19 12:00:00	SPY	ETF	141.65	141.81	141.46	141.69	3775900.0
2006-12-19 13:00:00	SPY	ETF	141.69	141.94	141.55	141.89	3468300.0
2006-12-19 14:00:00	SPY	ETF	141.89	142.3	141.88	142.23	9994200.0
2006-12-19 15:00:00	SPY	ETF	142.24	142.56	142.23	142.28	8171500.0
2006-12-19 16:00:00	SPY	ETF	142.28	142.28	141.16	142.23	2648900.0
2006-12-19 17:00:00	SPY	ETF	142.24	142.33	142.24	142.33	53700.0
2006-12-19 18:00:00	SPY	ETF	142.25	142.25	142.19	142.22	56500.0
2006-12-19 09:00:00	QQQ	ETF	43.66	44.63	43.38	43.58	21306100.0
2006-12-19 10:00:00	QQQ	ETF	43.57	43.8	43.57	43.77	24936300.0
2006-12-19 11:00:00	QQQ	ETF	43.78	43.87	43.58	43.62	14170300.0
2006-12-19 12:00:00	QQQ	ETF	43.62	43.74	43.5	43.68	13871900.0
2006-12-19 13:00:00	QQQ	ETF	43.67	43.72	43.54	43.69	6425300.0
2006-12-19 14:00:00	QQQ	ETF	43.7	43.91	43.69	43.89	10369200.0
2006-12-19 15:00:00	QQQ	ETF	43.88	44.06	43.85	43.85	19499300.0
2006-12-19 07:00:00	IWM	ETF	77.61	77.69	77.6	77.69	20000.0
2006-12-19 08:00:00	IWM	ETF	77.69	78.05	77.39	77.55	1506900.0
2006-12-19 09:00:00	IWM	ETF	77.53	77.56	77.1	77.33	9623900.0
2006-12-19 10:00:00	IWM	ETF	77.33	77.77	77.3	77.7	10397000.0
2006-12-19 11:00:00	IWM	ETF	77.7	77.84	77.36	77.39	6147800.0
2006-12-19 12:00:00	IWM	ETF	77.39	77.55	77.31	77.5	3290000.0
2006-12-19 13:00:00	IWM	ETF	77.5	77.65	77.42	77.5925	3752500.0
2006-12-19 14:00:00	IWM	ETF	77.59	77.94	77.58	77.84	8911400.0
2006-12-19 15:00:00	IWM	ETF	77.85	78.11	77.75	77.94	7575500.0
2006-12-19 16:00:00	IWM	ETF	77.92	77.95	77.81	77.94	343800.0
2006-12-19 17:00:00	IWM	ETF	77.96	78.0	77.94	78.0	137400.0
2006-12-19 19:00:00	IWM	ETF	77.96	77.96	77.96	77.96	300.0
2006-12-19 07:00:00	DIA	ETF	123.91	124.01	123.89	124.01	19600.0
2006-12-19 08:00:00	DIA	ETF	123.89	124.12	123.87	123.95	84900.0
2006-12-19 09:00:00	DIA	ETF	123.95	123.96	123.7	123.88	942300.0
2006-12-19 10:00:00	DIA	ETF	123.87	124.15	123.81	124.1	1118500.0
2006-12-19 11:00:00	DIA	ETF	124.1	124.18	123.83	123.94	921100.0
2006-12-19 12:00:00	DIA	ETF	123.94	124.09	123.82	123.99	806100.0
2006-12-19 13:00:00	DIA	ETF	123.99	124.14	123.86	124.09	538600.0
2006-12-19 14:00:00	DIA	ETF	124.09	124.43	124.08	124.38	857000.0
2006-12-19 15:00:00	DIA	ETF	124.38	124.64	124.38	124.42	786900.0
2006-12-19 16:00:00	DIA	ETF	124.42	124.42	124.33	124.38	36000.0
2006-12-19 18:00:00	DIA	ETF	124.39	124.39	124.39	124.39	500.0
2006-12-19 08:00:00	GLD	ETF	61.15	61.25	61.0	61.15	139600.0
2006-12-19 09:00:00	GLD	ETF	61.15	61.6	61.14	61.59	752300.0
2006-12-19 10:00:00	GLD	ETF	61.6	61.71	61.46	61.7	691400.0
2006-12-19 11:00:00	GLD	ETF	61.71	61.71	61.47	61.665	523700.0
2006-12-19 12:00:00	GLD	ETF	61.67	61.77	61.5	61.6	343000.0
2006-12-19 13:00:00	GLD	ETF	61.6099	61.81	61.59	61.75	466600.0
2006-12-19 14:00:00	GLD	ETF	61.75	61.79	61.66	61.79	578700.0

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

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