PREVIEW / etf_1hour / 2008-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-22.parquet
  size:    114 KB
  rows:    3,773

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-10-22 04:00:00	SPY	ETF	95.2	95.36	94.55	94.55	17000.0
2008-10-22 05:00:00	SPY	ETF	94.7	94.73	93.9	94.1	6400.0
2008-10-22 06:00:00	SPY	ETF	94.37	94.55	93.7	93.7	201149.0
2008-10-22 07:00:00	SPY	ETF	93.7	93.8	92.79	93.7	1773067.0
2008-10-22 08:00:00	SPY	ETF	93.68	96.85	92.55	92.86	8223773.0
2008-10-22 09:00:00	SPY	ETF	92.86	93.5001	91.84	91.91	51414858.0
2008-10-22 10:00:00	SPY	ETF	91.91	93.13	91.25	92.96	76344645.0
2008-10-22 11:00:00	SPY	ETF	92.96	95.86	91.8	92.53	43377089.0
2008-10-22 12:00:00	SPY	ETF	92.53	93.3	92.19	92.47	29930929.0
2008-10-22 13:00:00	SPY	ETF	92.4692	95.5564	90.83	91.54	59517016.0
2008-10-22 14:00:00	SPY	ETF	91.54	92.7701	90.4	90.89	57200755.0
2008-10-22 15:00:00	SPY	ETF	90.9	95.5564	87.53	89.88	146192261.0
2008-10-22 16:00:00	SPY	ETF	90.27	95.5564	88.3	90.87	31311723.0
2008-10-22 17:00:00	SPY	ETF	90.84	91.24	90.74	91.02	379742.0
2008-10-22 18:00:00	SPY	ETF	90.99	91.45	90.97	91.2	547732.0
2008-10-22 19:00:00	SPY	ETF	91.17	91.36	90.9	91.21	50956.0
2008-10-22 04:00:00	QQQ	ETF	31.9	31.98	31.77	31.77	21912.0
2008-10-22 05:00:00	QQQ	ETF	31.63	31.63	31.4	31.47	4600.0
2008-10-22 06:00:00	QQQ	ETF	31.55	31.64	31.3	31.3	196121.0
2008-10-22 07:00:00	QQQ	ETF	31.35	31.58	31.2	31.49	1816502.0
2008-10-22 08:00:00	QQQ	ETF	31.5	31.75	31.19	31.22	4226628.0
2008-10-22 09:00:00	QQQ	ETF	31.22	31.5	31.09	31.13	38550686.0
2008-10-22 10:00:00	QQQ	ETF	31.12	31.6	30.86	31.48	50321353.0
2008-10-22 11:00:00	QQQ	ETF	31.47	31.478	31.07	31.32	24116543.0
2008-10-22 12:00:00	QQQ	ETF	31.32	31.55	31.2	31.43	18620393.0
2008-10-22 13:00:00	QQQ	ETF	31.42	31.42	30.85	31.07	25605370.0
2008-10-22 14:00:00	QQQ	ETF	31.07	31.09	30.55	30.6999	25380369.0
2008-10-22 15:00:00	QQQ	ETF	30.7	30.77	29.71	30.62	75085317.0
2008-10-22 16:00:00	QQQ	ETF	30.62	31.5524	30.1798	30.66	13964707.0
2008-10-22 17:00:00	QQQ	ETF	30.66	31.5524	30.34	30.72	2233701.0
2008-10-22 18:00:00	QQQ	ETF	30.71	30.81	30.71	30.74	56907.0
2008-10-22 19:00:00	QQQ	ETF	30.72	30.75	30.62	30.71	36473.0
2008-10-22 07:00:00	IWM	ETF	52.28	52.33	52.1	52.25	9900.0
2008-10-22 08:00:00	IWM	ETF	52.25	53.58	51.54	51.7	512956.0
2008-10-22 09:00:00	IWM	ETF	51.71	52.39	51.44	51.87	12083677.0
2008-10-22 10:00:00	IWM	ETF	51.88	52.46	51.16	52.26	14797831.0
2008-10-22 11:00:00	IWM	ETF	52.24	52.4	51.55	51.87	7103137.0
2008-10-22 12:00:00	IWM	ETF	51.87	52.15	51.58	51.6	4193024.0
2008-10-22 13:00:00	IWM	ETF	51.59	51.8	50.76	51.14	9113354.0
2008-10-22 14:00:00	IWM	ETF	51.14	51.28	50.38	50.65	8913804.0
2008-10-22 15:00:00	IWM	ETF	50.65	51.1	49.31	50.48	27556627.0
2008-10-22 16:00:00	IWM	ETF	50.49	53.08	50.07	53.08	6085992.0
2008-10-22 17:00:00	IWM	ETF	50.9	51.12	50.85	50.85	11900.0
2008-10-22 18:00:00	IWM	ETF	50.59	50.93	50.58	50.93	6200.0
2008-10-22 19:00:00	IWM	ETF	50.75	50.75	50.75	50.75	200.0
2008-10-22 04:00:00	DIA	ETF	90.0	90.0	90.0	90.0	100.0
2008-10-22 07:00:00	DIA	ETF	88.35	88.73	88.25	88.73	8729.0
2008-10-22 08:00:00	DIA	ETF	88.76	89.35	87.85	87.95	95208.0
2008-10-22 09:00:00	DIA	ETF	87.96	88.42	86.81	86.88	3997724.0
2008-10-22 10:00:00	DIA	ETF	86.88	88.01	86.21	87.86	6554215.0

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

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