PREVIEW / etf_1hour / 2006-12-18

all etf 1-hour files

  file:    by_date/etf_1hour/2006/2006-12-18.parquet
  size:    58 KB
  rows:    1,819

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-18 07:00:00	SPY	ETF	142.7	142.72	142.61	142.63	31500.0
2006-12-18 08:00:00	SPY	ETF	142.66	142.72	142.34	142.64	1058600.0
2006-12-18 09:00:00	SPY	ETF	142.65	142.87	142.47	142.81	7010300.0
2006-12-18 10:00:00	SPY	ETF	142.8	142.88	142.51	142.56	5270700.0
2006-12-18 11:00:00	SPY	ETF	142.57	142.6	142.3	142.35	4308700.0
2006-12-18 12:00:00	SPY	ETF	142.34	142.42	142.09	142.32	5974400.0
2006-12-18 13:00:00	SPY	ETF	142.31	142.49	142.18	142.39	7698000.0
2006-12-18 14:00:00	SPY	ETF	142.38	142.43	141.87	141.98	5105300.0
2006-12-18 15:00:00	SPY	ETF	141.98	142.01	141.75	141.93	9167000.0
2006-12-18 16:00:00	SPY	ETF	141.95	142.06	141.92	142.0	725000.0
2006-12-18 17:00:00	SPY	ETF	142.0	142.0	141.92	141.95	83700.0
2006-12-18 18:00:00	SPY	ETF	141.95	141.99	141.95	141.97	2200.0
2006-12-18 19:00:00	SPY	ETF	141.97	141.97	141.95	141.95	600.0
2006-12-18 09:00:00	QQQ	ETF	44.58	44.73	44.52	44.7	14347000.0
2006-12-18 10:00:00	QQQ	ETF	44.71	44.75	44.51	44.54	15775800.0
2006-12-18 11:00:00	QQQ	ETF	44.55	44.57	44.38	44.43	11167900.0
2006-12-18 12:00:00	QQQ	ETF	44.43	44.44	44.22	44.29	11564400.0
2006-12-18 13:00:00	QQQ	ETF	44.29	44.38	44.22	44.32	7481500.0
2006-12-18 14:00:00	QQQ	ETF	44.32	44.35	43.91	44.0	24266600.0
2006-12-18 15:00:00	QQQ	ETF	44.01	44.04	43.8	43.98	22208600.0
2006-12-18 08:00:00	IWM	ETF	79.1	79.17	79.08	79.15	55300.0
2006-12-18 09:00:00	IWM	ETF	79.14	79.23	78.85	79.11	3764500.0
2006-12-18 10:00:00	IWM	ETF	79.12	79.21	78.86	78.92	3467000.0
2006-12-18 11:00:00	IWM	ETF	78.92	78.95	78.53	78.54	4271400.0
2006-12-18 12:00:00	IWM	ETF	78.54	78.54	78.13	78.19	5440400.0
2006-12-18 13:00:00	IWM	ETF	78.18	78.31	78.06	78.2	4405600.0
2006-12-18 14:00:00	IWM	ETF	78.2	78.26	77.82	77.94	9954900.0
2006-12-18 15:00:00	IWM	ETF	77.93	77.93	77.63	77.81	13048000.0
2006-12-18 16:00:00	IWM	ETF	77.83	77.98	77.83	77.93	552200.0
2006-12-18 17:00:00	IWM	ETF	77.95	77.95	77.88	77.88	10500.0
2006-12-18 18:00:00	IWM	ETF	77.89	77.89	77.87	77.87	5000.0
2006-12-18 19:00:00	IWM	ETF	77.88	77.88	77.88	77.88	7500.0
2006-12-18 08:00:00	DIA	ETF	124.42	124.46	124.36	124.4	13000.0
2006-12-18 09:00:00	DIA	ETF	124.41	124.57	124.15	124.53	794900.0
2006-12-18 10:00:00	DIA	ETF	124.54	124.63	124.45	124.52	712200.0
2006-12-18 11:00:00	DIA	ETF	124.51	124.52	124.25	124.27	651900.0
2006-12-18 12:00:00	DIA	ETF	124.27	124.42	124.1	124.33	954200.0
2006-12-18 13:00:00	DIA	ETF	124.32	124.52	124.24	124.46	806300.0
2006-12-18 14:00:00	DIA	ETF	124.45	124.49	124.18	124.25	1088600.0
2006-12-18 15:00:00	DIA	ETF	124.24	124.24	124.03	124.19	1649200.0
2006-12-18 16:00:00	DIA	ETF	124.21	124.28	124.2	124.26	29900.0
2006-12-18 17:00:00	DIA	ETF	124.26	124.26	124.26	124.26	31300.0
2006-12-18 07:00:00	GLD	ETF	61.09	61.09	61.09	61.09	500.0
2006-12-18 08:00:00	GLD	ETF	61.1	61.27	61.01	61.09	37100.0
2006-12-18 09:00:00	GLD	ETF	61.05	61.19	60.77	60.8412	878600.0
2006-12-18 10:00:00	GLD	ETF	60.83	60.99	60.65	60.77	1004600.0
2006-12-18 11:00:00	GLD	ETF	60.76	60.92	60.72	60.86	589300.0
2006-12-18 12:00:00	GLD	ETF	60.8728	60.91	60.78	60.88	349800.0
2006-12-18 13:00:00	GLD	ETF	60.88	61.07	60.84	61.01	354000.0
2006-12-18 14:00:00	GLD	ETF	61.01	61.07	60.96	61.06	230900.0

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

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