PREVIEW / etf_1hour / 2009-01-07

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-01-07.parquet
  size:    128 KB
  rows:    3,887

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
2009-01-07 04:00:00	SPY	ETF	92.48	92.62	92.45	92.62	4100.0
2009-01-07 05:00:00	SPY	ETF	92.62	92.84	92.55	92.77	3570.0
2009-01-07 06:00:00	SPY	ETF	92.73	92.88	92.64	92.73	77730.0
2009-01-07 07:00:00	SPY	ETF	92.7	92.73	92.46	92.52	355618.0
2009-01-07 08:00:00	SPY	ETF	92.5	92.85	91.88	92.17	3400008.0
2009-01-07 09:00:00	SPY	ETF	92.17	92.26	91.61	92.09	31271685.0
2009-01-07 10:00:00	SPY	ETF	92.08	92.2292	91.25	91.5	41272747.0
2009-01-07 11:00:00	SPY	ETF	91.5	92.11	91.36	92.01	26764399.0
2009-01-07 12:00:00	SPY	ETF	92.01	92.02	91.35	91.4	20589792.0
2009-01-07 13:00:00	SPY	ETF	91.41	91.75	90.93	90.9501	26543203.0
2009-01-07 14:00:00	SPY	ETF	90.95	91.07	90.54	90.6	40884535.0
2009-01-07 15:00:00	SPY	ETF	90.6	91.55	90.2	90.7	65096153.0
2009-01-07 16:00:00	SPY	ETF	90.69	93.4863	90.37	90.99	16576387.0
2009-01-07 17:00:00	SPY	ETF	91.0	91.05	90.93	90.97	405646.0
2009-01-07 18:00:00	SPY	ETF	90.97	90.98	90.82	90.85	123362.0
2009-01-07 19:00:00	SPY	ETF	90.85	90.98	90.85	90.87	76158.0
2009-01-07 04:00:00	QQQ	ETF	31.05	31.07	31.05	31.07	800.0
2009-01-07 05:00:00	QQQ	ETF	31.15	31.17	31.12	31.12	300.0
2009-01-07 06:00:00	QQQ	ETF	31.19	31.19	31.1	31.1	1200.0
2009-01-07 07:00:00	QQQ	ETF	31.08	31.13	30.99	31.0	32985.0
2009-01-07 08:00:00	QQQ	ETF	31.02	31.06	30.76	30.87	2236572.0
2009-01-07 09:00:00	QQQ	ETF	30.86	30.9	30.6	30.81	19914062.0
2009-01-07 10:00:00	QQQ	ETF	30.81	30.85	30.47	30.63	25545176.0
2009-01-07 11:00:00	QQQ	ETF	30.63	30.87	30.6	30.83	13446659.0
2009-01-07 12:00:00	QQQ	ETF	30.8299	30.83	30.62	30.642	11856569.0
2009-01-07 13:00:00	QQQ	ETF	30.641	30.77	30.44	30.45	11114211.0
2009-01-07 14:00:00	QQQ	ETF	30.44	30.5	30.28	30.351	16240207.0
2009-01-07 15:00:00	QQQ	ETF	30.35	30.46	30.19	30.44	27551643.0
2009-01-07 16:00:00	QQQ	ETF	30.44	30.51	30.31	30.5	3497449.0
2009-01-07 17:00:00	QQQ	ETF	30.51	30.54	30.48	30.51	146490.0
2009-01-07 18:00:00	QQQ	ETF	30.48	30.51	30.47	30.48	178704.0
2009-01-07 19:00:00	QQQ	ETF	30.48	30.49	30.47	30.47	17205.0
2009-01-07 06:00:00	IWM	ETF	50.95	50.95	50.91	50.91	200.0
2009-01-07 07:00:00	IWM	ETF	50.85	50.85	50.67	50.77	26975.0
2009-01-07 08:00:00	IWM	ETF	50.72	50.79	50.31	50.42	649910.0
2009-01-07 09:00:00	IWM	ETF	50.42	50.46	50.0	50.27	6186734.0
2009-01-07 10:00:00	IWM	ETF	50.27	50.39	49.57	49.83	10595853.0
2009-01-07 11:00:00	IWM	ETF	49.8	50.51	49.71	50.372	7100522.0
2009-01-07 12:00:00	IWM	ETF	50.38	50.425	49.989	50.01	4262405.0
2009-01-07 13:00:00	IWM	ETF	50.0	50.31	49.72	49.78	6799551.0
2009-01-07 14:00:00	IWM	ETF	49.77	49.83	49.16	49.32	9194141.0
2009-01-07 15:00:00	IWM	ETF	49.33	51.3498	49.03	49.65	16927043.0
2009-01-07 16:00:00	IWM	ETF	49.65	51.3497	49.596	49.91	9039688.0
2009-01-07 17:00:00	IWM	ETF	49.84	51.6497	49.84	49.84	4001900.0
2009-01-07 06:00:00	DIA	ETF	89.4	89.55	89.4	89.49	400.0
2009-01-07 07:00:00	DIA	ETF	89.43	89.43	89.24	89.24	9138.0
2009-01-07 08:00:00	DIA	ETF	89.3	89.45	88.83	88.98	83418.0
2009-01-07 09:00:00	DIA	ETF	89.0	89.18	88.53	88.97	3920876.0
2009-01-07 10:00:00	DIA	ETF	88.97	89.12	88.21	88.5	5017234.0
2009-01-07 11:00:00	DIA	ETF	88.49	88.9	88.35	88.7899	3144803.0

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

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