PREVIEW / etf_1hour / 2008-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-12-12.parquet
  size:    118 KB
  rows:    3,848

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-12 04:00:00	SPY	ETF	84.42	85.18	84.42	85.12	21910.0
2008-12-12 05:00:00	SPY	ETF	84.71	84.78	84.33	84.33	51900.0
2008-12-12 06:00:00	SPY	ETF	84.16	84.46	83.85	84.24	238604.0
2008-12-12 07:00:00	SPY	ETF	84.24	85.14	84.22	84.68	1940511.0
2008-12-12 08:00:00	SPY	ETF	84.63	86.6	83.95	84.79	8837291.0
2008-12-12 09:00:00	SPY	ETF	84.79	87.22	84.36	86.89	73022501.0
2008-12-12 10:00:00	SPY	ETF	86.9	87.6	86.11	87.53	59170286.0
2008-12-12 11:00:00	SPY	ETF	87.52	87.79	86.4	86.8	39717309.0
2008-12-12 12:00:00	SPY	ETF	86.8	88.54	86.8	88.34	35398624.0
2008-12-12 13:00:00	SPY	ETF	88.34	88.59	86.87	87.1901	36260825.0
2008-12-12 14:00:00	SPY	ETF	87.18	88.45	86.67	88.26	52536006.0
2008-12-12 15:00:00	SPY	ETF	88.26	88.9	87.51	88.45	70833898.0
2008-12-12 16:00:00	SPY	ETF	88.46	89.2	86.5121	89.12	28791350.0
2008-12-12 17:00:00	SPY	ETF	89.05	89.33	89.0	89.28	330925.0
2008-12-12 18:00:00	SPY	ETF	89.28	89.38	89.19	89.26	47182.0
2008-12-12 19:00:00	SPY	ETF	89.26	89.45	89.26	89.45	32959.0
2008-12-12 04:00:00	QQQ	ETF	28.34	28.46	28.34	28.39	676.0
2008-12-12 05:00:00	QQQ	ETF	28.27	28.27	28.27	28.27	400.0
2008-12-12 06:00:00	QQQ	ETF	28.07	28.16	28.05	28.16	7300.0
2008-12-12 07:00:00	QQQ	ETF	28.11	28.4	28.05	28.34	371226.0
2008-12-12 08:00:00	QQQ	ETF	28.29	28.5	28.14	28.44	2811471.0
2008-12-12 09:00:00	QQQ	ETF	28.43	29.2	28.42	29.11	26474459.0
2008-12-12 10:00:00	QQQ	ETF	29.11	29.45	28.91	29.43	24983468.0
2008-12-12 11:00:00	QQQ	ETF	29.42	29.53	29.05	29.19	17299341.0
2008-12-12 12:00:00	QQQ	ETF	29.2	29.71	29.17	29.63	11588740.0
2008-12-12 13:00:00	QQQ	ETF	29.63	29.7	29.18	29.33	14781806.0
2008-12-12 14:00:00	QQQ	ETF	29.33	29.75	29.19	29.68	20063573.0
2008-12-12 15:00:00	QQQ	ETF	29.67	29.86	29.43	29.67	26140134.0
2008-12-12 16:00:00	QQQ	ETF	29.66	29.9	27.79	29.87	9468534.0
2008-12-12 17:00:00	QQQ	ETF	29.86	29.94	29.86	29.94	19345.0
2008-12-12 18:00:00	QQQ	ETF	29.92	29.95	29.9	29.9	6370.0
2008-12-12 19:00:00	QQQ	ETF	29.91	29.96	29.91	29.95	7350.0
2008-12-12 04:00:00	IWM	ETF	43.9	43.9	43.9	43.9	180.0
2008-12-12 06:00:00	IWM	ETF	43.42	43.42	43.42	43.42	920.0
2008-12-12 07:00:00	IWM	ETF	43.66	43.87	43.55	43.65	7850.0
2008-12-12 08:00:00	IWM	ETF	43.6	44.22	43.6	44.14	339831.0
2008-12-12 09:00:00	IWM	ETF	44.05	45.31	43.95	45.15	17618349.0
2008-12-12 10:00:00	IWM	ETF	45.15	45.75	44.72	45.59	14770803.0
2008-12-12 11:00:00	IWM	ETF	45.57	45.91	45.11	45.42	9808393.0
2008-12-12 12:00:00	IWM	ETF	45.45	46.77	45.45	46.57	8067874.0
2008-12-12 13:00:00	IWM	ETF	46.57	46.71	45.4	45.71	9453603.0
2008-12-12 14:00:00	IWM	ETF	45.7	46.73	45.5	46.59	11355822.0
2008-12-12 15:00:00	IWM	ETF	46.57	47.0	45.24	46.88	17219929.0
2008-12-12 16:00:00	IWM	ETF	46.89	47.53	45.26	47.42	5354237.0
2008-12-12 17:00:00	IWM	ETF	47.42	47.51	47.32	47.41	35470.0
2008-12-12 18:00:00	IWM	ETF	47.4	47.47	47.4	47.41	2205.0
2008-12-12 19:00:00	IWM	ETF	47.46	47.54	47.35	47.54	1904.0
2008-12-12 04:00:00	DIA	ETF	84.2	84.2	84.2	84.2	100.0
2008-12-12 05:00:00	DIA	ETF	83.7	83.7	83.7	83.7	200.0
2008-12-12 06:00:00	DIA	ETF	83.2	83.3	82.91	83.3	2200.0

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

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