PREVIEW / etf_1hour / 2009-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-05-27.parquet
  size:    137 KB
  rows:    4,183

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-05-27 04:00:00	SPY	ETF	91.44	91.57	91.39	91.39	14850.0
2009-05-27 05:00:00	SPY	ETF	91.39	91.75	91.24	91.64	3600.0
2009-05-27 06:00:00	SPY	ETF	91.72	91.79	91.49	91.72	20447.0
2009-05-27 07:00:00	SPY	ETF	91.6	91.62	91.29	91.3	283860.0
2009-05-27 08:00:00	SPY	ETF	91.28	91.56	91.02	91.34	2611080.0
2009-05-27 09:00:00	SPY	ETF	91.34	91.52	91.05	91.43	21075881.0
2009-05-27 10:00:00	SPY	ETF	91.44	91.75	90.93	91.47	46604319.0
2009-05-27 11:00:00	SPY	ETF	91.47	91.65	91.13	91.5	24890926.0
2009-05-27 12:00:00	SPY	ETF	91.5	91.74	91.2	91.28	17953066.0
2009-05-27 13:00:00	SPY	ETF	91.29	91.53	90.34	90.6	27481734.0
2009-05-27 14:00:00	SPY	ETF	90.6	90.68	90.12	90.39	30661637.0
2009-05-27 15:00:00	SPY	ETF	90.39	90.66	89.53	89.68	57309609.0
2009-05-27 16:00:00	SPY	ETF	89.69	91.3807	89.55	89.57	14833776.0
2009-05-27 17:00:00	SPY	ETF	89.6	91.3807	89.55	89.67	1087013.0
2009-05-27 18:00:00	SPY	ETF	89.67	89.68	89.35	89.35	205824.0
2009-05-27 19:00:00	SPY	ETF	89.36	89.49	89.35	89.45	114843.0
2009-05-27 05:00:00	QQQ	ETF	34.75	34.78	34.75	34.78	2200.0
2009-05-27 06:00:00	QQQ	ETF	34.73	34.77	34.69	34.77	90000.0
2009-05-27 07:00:00	QQQ	ETF	34.78	34.78	34.68	34.69	227049.0
2009-05-27 08:00:00	QQQ	ETF	34.69	34.8	34.59	34.69	786671.0
2009-05-27 09:00:00	QQQ	ETF	34.68	34.98	34.59	34.92	10187614.0
2009-05-27 10:00:00	QQQ	ETF	34.92	35.17	34.77	35.14	20145002.0
2009-05-27 11:00:00	QQQ	ETF	35.15	35.15	35.01	35.11	11944359.0
2009-05-27 12:00:00	QQQ	ETF	35.1199	35.19	34.96	34.9989	9899069.0
2009-05-27 13:00:00	QQQ	ETF	34.99	35.1	34.62	34.73	14731186.0
2009-05-27 14:00:00	QQQ	ETF	34.74	34.82	34.59	34.71	13897065.0
2009-05-27 15:00:00	QQQ	ETF	34.71	34.84	34.43	34.53	24744982.0
2009-05-27 16:00:00	QQQ	ETF	34.54	35.05	34.48	34.52	8138779.0
2009-05-27 17:00:00	QQQ	ETF	34.51	34.57	34.49	34.56	43802.0
2009-05-27 18:00:00	QQQ	ETF	34.56	34.56	34.44	34.46	34012.0
2009-05-27 19:00:00	QQQ	ETF	34.45	34.5	34.44	34.46	24833.0
2009-05-27 06:00:00	IWM	ETF	50.17	50.17	50.17	50.17	100.0
2009-05-27 07:00:00	IWM	ETF	50.11	50.11	49.9	49.9	50900.0
2009-05-27 08:00:00	IWM	ETF	49.9	49.94	49.69	49.7	231592.0
2009-05-27 09:00:00	IWM	ETF	49.7	50.09	49.5	50.08	5034150.0
2009-05-27 10:00:00	IWM	ETF	50.09	50.31	49.65	50.12	7836009.0
2009-05-27 11:00:00	IWM	ETF	50.12	50.31	49.8	50.22	5066339.0
2009-05-27 12:00:00	IWM	ETF	50.22	50.37	49.9	49.96	4069107.0
2009-05-27 13:00:00	IWM	ETF	49.97	50.15	49.42	49.58	3852932.0
2009-05-27 14:00:00	IWM	ETF	49.57	49.69	49.29	49.5	6427107.0
2009-05-27 15:00:00	IWM	ETF	49.5	49.64	49.01	49.04	10871087.0
2009-05-27 16:00:00	IWM	ETF	49.04	50.0973	49.04	49.07	4725704.0
2009-05-27 17:00:00	IWM	ETF	49.07	49.16	49.04	49.16	12169.0
2009-05-27 18:00:00	IWM	ETF	49.08	49.08	49.06	49.06	900.0
2009-05-27 19:00:00	IWM	ETF	49.04	49.04	49.04	49.04	1987.0
2009-05-27 06:00:00	DIA	ETF	85.2	85.2	85.2	85.2	100.0
2009-05-27 07:00:00	DIA	ETF	85.08	85.08	84.85	84.85	24810.0
2009-05-27 08:00:00	DIA	ETF	84.83	84.99	84.59	84.88	50082.0
2009-05-27 09:00:00	DIA	ETF	84.87	85.0	84.42	84.7802	1083253.0
2009-05-27 10:00:00	DIA	ETF	84.8	85.07	84.27	84.64	2368845.0

> showing 50 of 4,183 rows — these rows as CSV

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