PREVIEW / etf_1hour / 2008-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-08.parquet
  size:    121 KB
  rows:    3,975

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
2008-12-08 04:00:00	SPY	ETF	89.96	90.01	89.66	89.66	4696.0
2008-12-08 05:00:00	SPY	ETF	89.68	89.86	89.33	89.86	26782.0
2008-12-08 06:00:00	SPY	ETF	89.88	90.35	89.81	90.35	107132.0
2008-12-08 07:00:00	SPY	ETF	90.39	90.53	89.9	90.34	1347752.0
2008-12-08 08:00:00	SPY	ETF	90.35	91.04	89.55	90.57	5173906.0
2008-12-08 09:00:00	SPY	ETF	90.57	91.23	90.02	90.34	51048647.0
2008-12-08 10:00:00	SPY	ETF	90.34	91.64	90.09	91.4625	64381554.0
2008-12-08 11:00:00	SPY	ETF	91.45	91.62	90.31	90.47	42525618.0
2008-12-08 12:00:00	SPY	ETF	90.48	90.98	90.15	90.38	30848197.0
2008-12-08 13:00:00	SPY	ETF	90.39	90.92	89.8	90.26	42923851.0
2008-12-08 14:00:00	SPY	ETF	90.29	91.97	90.19	91.97	51885832.0
2008-12-08 15:00:00	SPY	ETF	91.96	92.38	90.64	91.25	103805912.0
2008-12-08 16:00:00	SPY	ETF	91.2	91.5	90.3	90.43	16419596.0
2008-12-08 17:00:00	SPY	ETF	90.46	90.56	90.32	90.4	1436858.0
2008-12-08 18:00:00	SPY	ETF	90.39	90.64	90.26	90.34	234567.0
2008-12-08 19:00:00	SPY	ETF	90.36	90.75	90.31	90.57	87264.0
2008-12-08 04:00:00	QQQ	ETF	29.65	29.65	29.5	29.5	2047.0
2008-12-08 05:00:00	QQQ	ETF	29.45	29.45	29.45	29.45	100.0
2008-12-08 06:00:00	QQQ	ETF	29.54	29.64	29.52	29.64	5331.0
2008-12-08 07:00:00	QQQ	ETF	29.68	29.84	29.53	29.8	215020.0
2008-12-08 08:00:00	QQQ	ETF	29.79	29.94	29.72	29.74	2446628.0
2008-12-08 09:00:00	QQQ	ETF	29.73	29.79	29.44	29.59	21637045.0
2008-12-08 10:00:00	QQQ	ETF	29.58	30.18	29.54	29.95	32955795.0
2008-12-08 11:00:00	QQQ	ETF	29.952	30.09	29.82	29.92	26407375.0
2008-12-08 12:00:00	QQQ	ETF	29.91	30.05	29.82	29.91	8195878.0
2008-12-08 13:00:00	QQQ	ETF	29.91	30.09	29.7	29.79	15148718.0
2008-12-08 14:00:00	QQQ	ETF	29.79	30.38	29.77	30.36	22474888.0
2008-12-08 15:00:00	QQQ	ETF	30.36	30.46	29.86	30.069	41368556.0
2008-12-08 16:00:00	QQQ	ETF	30.06	30.1955	29.68	29.7	7230357.0
2008-12-08 17:00:00	QQQ	ETF	29.73	29.76	29.65	29.68	223485.0
2008-12-08 18:00:00	QQQ	ETF	29.68	29.75	29.64	29.68	84390.0
2008-12-08 19:00:00	QQQ	ETF	29.68	29.8	29.68	29.71	49460.0
2008-12-08 05:00:00	IWM	ETF	46.86	46.89	46.86	46.89	1100.0
2008-12-08 06:00:00	IWM	ETF	47.26	47.26	47.26	47.26	100.0
2008-12-08 07:00:00	IWM	ETF	47.44	47.5	47.23	47.49	23234.0
2008-12-08 08:00:00	IWM	ETF	47.39	47.77	47.35	47.61	323135.0
2008-12-08 09:00:00	IWM	ETF	47.6	47.96	47.17	47.29	10252446.0
2008-12-08 10:00:00	IWM	ETF	47.3	48.06	46.97	47.88	15803380.0
2008-12-08 11:00:00	IWM	ETF	47.87	48.24	47.7	47.95	13133259.0
2008-12-08 12:00:00	IWM	ETF	47.96	48.24	47.68	47.82	7460075.0
2008-12-08 13:00:00	IWM	ETF	47.82	48.06	47.31	47.51	11114313.0
2008-12-08 14:00:00	IWM	ETF	47.51	48.43	47.44	48.42	13485282.0
2008-12-08 15:00:00	IWM	ETF	48.43	48.57	47.43	48.13	20381164.0
2008-12-08 16:00:00	IWM	ETF	48.14	48.53	46.22	47.74	5454369.0
2008-12-08 17:00:00	IWM	ETF	47.77	47.87	46.22	47.78	1046097.0
2008-12-08 18:00:00	IWM	ETF	47.72	47.81	47.71	47.8	2200.0
2008-12-08 19:00:00	IWM	ETF	47.81	47.81	47.74	47.8	3100.0
2008-12-08 04:00:00	DIA	ETF	87.58	87.58	87.58	87.58	100.0
2008-12-08 05:00:00	DIA	ETF	87.78	87.78	87.78	87.78	100.0
2008-12-08 06:00:00	DIA	ETF	88.02	88.38	88.02	88.38	1100.0

> showing 50 of 3,975 rows — these rows as CSV

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