PREVIEW / etf_1hour / 2010-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-08-24.parquet
  size:    167 KB
  rows:    5,158

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
2010-08-24 04:00:00	SPY	ETF	106.8	106.8	106.1	106.22	6000.0
2010-08-24 05:00:00	SPY	ETF	106.27	106.32	106.18	106.18	14600.0
2010-08-24 06:00:00	SPY	ETF	106.2	106.43	106.2	106.33	18800.0
2010-08-24 07:00:00	SPY	ETF	106.34	106.43	105.98	106.01	694516.0
2010-08-24 08:00:00	SPY	ETF	106.01	106.44	105.73	105.8	4431196.0
2010-08-24 09:00:00	SPY	ETF	105.81	107.13	105.54	105.69	36135896.0
2010-08-24 10:00:00	SPY	ETF	105.69	105.92	104.97	105.89	54665140.0
2010-08-24 11:00:00	SPY	ETF	105.88	106.39	105.76	106.11	31923090.0
2010-08-24 12:00:00	SPY	ETF	106.1	106.32	105.83	105.88	17456651.0
2010-08-24 13:00:00	SPY	ETF	105.88	106.17	105.54	105.611	20571635.0
2010-08-24 14:00:00	SPY	ETF	105.62	106.0	105.55	105.922	32365295.0
2010-08-24 15:00:00	SPY	ETF	105.96	106.27	105.48	105.58	55913416.0
2010-08-24 16:00:00	SPY	ETF	105.58	107.1139	105.36	105.37	23228679.0
2010-08-24 17:00:00	SPY	ETF	105.38	105.51	105.33	105.44	182827.0
2010-08-24 18:00:00	SPY	ETF	105.43	105.54	105.42	105.49	56419.0
2010-08-24 19:00:00	SPY	ETF	105.48	105.78	105.41	105.77	205654.0
2010-08-24 04:00:00	QQQ	ETF	44.25	44.25	44.12	44.2	4619.0
2010-08-24 06:00:00	QQQ	ETF	44.24	44.25	44.2	44.21	1808.0
2010-08-24 07:00:00	QQQ	ETF	44.22	44.26	44.08	44.09	127559.0
2010-08-24 08:00:00	QQQ	ETF	44.09	44.13	43.91	43.98	1486041.0
2010-08-24 09:00:00	QQQ	ETF	43.98	44.48	43.71	43.77	11948908.0
2010-08-24 10:00:00	QQQ	ETF	43.77	43.85	43.465	43.84	18440268.0
2010-08-24 11:00:00	QQQ	ETF	43.84	44.12	43.8	43.95	10105399.0
2010-08-24 12:00:00	QQQ	ETF	43.95	44.06	43.82	43.83	5323454.0
2010-08-24 13:00:00	QQQ	ETF	43.83	43.95	43.68	43.72	5408409.0
2010-08-24 14:00:00	QQQ	ETF	43.72	43.85	43.7	43.8301	7780497.0
2010-08-24 15:00:00	QQQ	ETF	43.822	43.99	43.63	43.66	12705581.0
2010-08-24 16:00:00	QQQ	ETF	43.65	44.4855	43.6	43.61	3557762.0
2010-08-24 17:00:00	QQQ	ETF	43.6	43.63	43.56	43.63	140950.0
2010-08-24 18:00:00	QQQ	ETF	43.62	43.65	43.62	43.64	29964.0
2010-08-24 19:00:00	QQQ	ETF	43.62	43.7	43.6	43.7	45481.0
2010-08-24 04:00:00	IWM	ETF	59.66	59.75	59.66	59.75	366.0
2010-08-24 07:00:00	IWM	ETF	59.86	59.87	59.44	59.5	86153.0
2010-08-24 08:00:00	IWM	ETF	59.5	59.88	59.2	59.3	1060373.0
2010-08-24 09:00:00	IWM	ETF	59.29	60.32	59.09	59.29	9211454.0
2010-08-24 10:00:00	IWM	ETF	59.3	59.62	58.8	59.55	15944488.0
2010-08-24 11:00:00	IWM	ETF	59.56	60.32	59.53	60.05	11144738.0
2010-08-24 12:00:00	IWM	ETF	60.05	60.17	59.8	59.94	3850907.0
2010-08-24 13:00:00	IWM	ETF	59.94	60.19	59.66	59.68	5130505.0
2010-08-24 14:00:00	IWM	ETF	59.69	59.98	59.65	59.98	6412380.0
2010-08-24 15:00:00	IWM	ETF	59.98	60.19	59.62	59.65	11445049.0
2010-08-24 16:00:00	IWM	ETF	59.65	60.3215	59.34	59.5	7613241.0
2010-08-24 17:00:00	IWM	ETF	59.51	59.53	59.48	59.49	45115.0
2010-08-24 18:00:00	IWM	ETF	59.5	59.55	59.49	59.53	6171.0
2010-08-24 19:00:00	IWM	ETF	59.5	59.65	59.5	59.65	3900.0
2010-08-24 04:00:00	DIA	ETF	100.99	100.99	100.99	100.99	100.0
2010-08-24 07:00:00	DIA	ETF	101.05	101.05	101.05	101.05	100.0
2010-08-24 08:00:00	DIA	ETF	100.84	100.93	100.57	100.72	33955.0
2010-08-24 09:00:00	DIA	ETF	100.65	100.9	100.43	100.5799	1372470.0
2010-08-24 10:00:00	DIA	ETF	100.56	100.73	99.91	100.7199	2812705.0

> showing 50 of 5,158 rows — these rows as CSV

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