PREVIEW / etf_1hour / 2009-06-02

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-06-02.parquet
  size:    136 KB
  rows:    4,267

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-06-02 04:00:00	SPY	ETF	94.26	94.26	94.05	94.24	1300.0
2009-06-02 05:00:00	SPY	ETF	94.18	94.5	94.11	94.49	43832.0
2009-06-02 06:00:00	SPY	ETF	94.56	94.72	94.41	94.72	44100.0
2009-06-02 07:00:00	SPY	ETF	94.59	94.7	94.42	94.69	617295.0
2009-06-02 08:00:00	SPY	ETF	94.69	94.71	94.04	94.41	2928104.0
2009-06-02 09:00:00	SPY	ETF	94.41	94.88	87.53	94.88	29471969.0
2009-06-02 10:00:00	SPY	ETF	94.85	95.37	87.97	94.85	55979448.0
2009-06-02 11:00:00	SPY	ETF	94.8483	95.0	94.47	94.6094	27668042.0
2009-06-02 12:00:00	SPY	ETF	94.6	94.76	94.41	94.672	20092561.0
2009-06-02 13:00:00	SPY	ETF	94.68	95.01	94.56	94.9301	18348605.0
2009-06-02 14:00:00	SPY	ETF	94.94	95.2	94.72	94.94	22449139.0
2009-06-02 15:00:00	SPY	ETF	94.96	95.22	94.76	94.86	42263477.0
2009-06-02 16:00:00	SPY	ETF	94.87	95.1692	94.55	94.65	9741164.0
2009-06-02 17:00:00	SPY	ETF	94.65	94.87	94.63	94.71	262579.0
2009-06-02 18:00:00	SPY	ETF	94.7	94.7	94.5	94.53	266245.0
2009-06-02 19:00:00	SPY	ETF	94.53	94.57	94.49	94.54	81155.0
2009-06-02 04:00:00	QQQ	ETF	36.21	36.21	36.17	36.17	1100.0
2009-06-02 06:00:00	QQQ	ETF	36.3	36.33	36.25	36.3	4406.0
2009-06-02 07:00:00	QQQ	ETF	36.28	36.34	36.27	36.33	138126.0
2009-06-02 08:00:00	QQQ	ETF	36.32	36.33	36.0	36.17	513307.0
2009-06-02 09:00:00	QQQ	ETF	36.17	36.52	36.11	36.52	15105557.0
2009-06-02 10:00:00	QQQ	ETF	36.48	36.79	36.38	36.4267	30994667.0
2009-06-02 11:00:00	QQQ	ETF	36.42	36.54	36.32	36.37	13881798.0
2009-06-02 12:00:00	QQQ	ETF	36.38	36.43	36.25	36.4	11235882.0
2009-06-02 13:00:00	QQQ	ETF	36.3999	36.49	36.3	36.49	9017189.0
2009-06-02 14:00:00	QQQ	ETF	36.48	36.58	36.41	36.48	10146390.0
2009-06-02 15:00:00	QQQ	ETF	36.49	36.59	36.37	36.42	24334138.0
2009-06-02 16:00:00	QQQ	ETF	36.42	36.4736	36.36	36.39	1444159.0
2009-06-02 17:00:00	QQQ	ETF	36.41	36.44	36.4	36.43	80284.0
2009-06-02 18:00:00	QQQ	ETF	36.42	36.42	36.37	36.39	33699.0
2009-06-02 19:00:00	QQQ	ETF	36.38	36.4	36.35	36.38	32523.0
2009-06-02 07:00:00	IWM	ETF	51.87	52.02	51.87	52.01	44800.0
2009-06-02 08:00:00	IWM	ETF	52.01	52.02	51.59	51.95	129453.0
2009-06-02 09:00:00	IWM	ETF	51.94	52.34	51.6799	52.31	6256881.0
2009-06-02 10:00:00	IWM	ETF	52.31	52.78	52.3	52.59	11859754.0
2009-06-02 11:00:00	IWM	ETF	52.6	52.735	52.37	52.54	3994010.0
2009-06-02 12:00:00	IWM	ETF	52.54	52.63	52.27	52.62	4356555.0
2009-06-02 13:00:00	IWM	ETF	52.62	52.9	52.57	52.83	4952195.0
2009-06-02 14:00:00	IWM	ETF	52.82	53.0	52.0	52.81	6391745.0
2009-06-02 15:00:00	IWM	ETF	52.81	52.95	52.72	52.77	11030274.0
2009-06-02 16:00:00	IWM	ETF	52.78	52.8049	52.56	52.7	1108259.0
2009-06-02 17:00:00	IWM	ETF	52.2176	52.7	52.2176	52.66	1002681.0
2009-06-02 18:00:00	IWM	ETF	52.7	52.74	52.61	52.7	4000.0
2009-06-02 19:00:00	IWM	ETF	52.63	52.63	52.62	52.62	200.0
2009-06-02 06:00:00	DIA	ETF	87.1	87.19	87.1	87.19	775.0
2009-06-02 07:00:00	DIA	ETF	87.25	87.31	87.22	87.31	4169.0
2009-06-02 08:00:00	DIA	ETF	87.28	87.3	86.83	87.04	38760.0
2009-06-02 09:00:00	DIA	ETF	87.05	87.58	86.88	87.57	860656.0
2009-06-02 10:00:00	DIA	ETF	87.54	87.97	87.42	87.49	2364980.0
2009-06-02 11:00:00	DIA	ETF	87.51	87.68	87.24	87.35	1551894.0

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

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