PREVIEW / etf_1hour / 2010-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-21.parquet
  size:    170 KB
  rows:    5,148

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-10-21 04:00:00	SPY	ETF	118.22	118.33	118.22	118.25	8537.0
2010-10-21 05:00:00	SPY	ETF	118.3	118.35	118.3	118.35	3500.0
2010-10-21 06:00:00	SPY	ETF	118.4	118.5	118.4	118.49	4880.0
2010-10-21 07:00:00	SPY	ETF	118.51	118.7	118.22	118.49	479725.0
2010-10-21 08:00:00	SPY	ETF	118.5	118.65	118.3	118.44	1805773.0
2010-10-21 09:00:00	SPY	ETF	118.41	118.64	118.2	118.62	19962073.0
2010-10-21 10:00:00	SPY	ETF	118.61	119.09	118.33	119.0105	34942861.0
2010-10-21 11:00:00	SPY	ETF	119.02	119.07	118.07	118.43	36343049.0
2010-10-21 12:00:00	SPY	ETF	118.4379	118.48	117.93	118.08	22195094.0
2010-10-21 13:00:00	SPY	ETF	118.08	118.33	117.26	117.35	31740700.0
2010-10-21 14:00:00	SPY	ETF	117.35	117.87	117.21	117.8	29599227.0
2010-10-21 15:00:00	SPY	ETF	117.8	118.2	117.69	118.11	36716748.0
2010-10-21 16:00:00	SPY	ETF	118.11	118.965	117.3086	117.96	6261281.0
2010-10-21 17:00:00	SPY	ETF	117.97	118.53	117.9321	117.98	286862.0
2010-10-21 18:00:00	SPY	ETF	118.0	118.12	117.98	118.0	70680.0
2010-10-21 19:00:00	SPY	ETF	118.01	118.05	117.99	118.05	38715.0
2010-10-21 04:00:00	QQQ	ETF	51.41	51.41	51.41	51.41	100.0
2010-10-21 05:00:00	QQQ	ETF	51.44	51.47	51.44	51.47	300.0
2010-10-21 06:00:00	QQQ	ETF	51.49	51.55	51.49	51.54	5700.0
2010-10-21 07:00:00	QQQ	ETF	51.56	51.66	51.53	51.6	142713.0
2010-10-21 08:00:00	QQQ	ETF	51.6	51.61	51.45	51.52	636470.0
2010-10-21 09:00:00	QQQ	ETF	51.52	51.65	51.38	51.61	8333364.0
2010-10-21 10:00:00	QQQ	ETF	51.6	51.7	51.43	51.68	12166937.0
2010-10-21 11:00:00	QQQ	ETF	51.6701	51.7101	51.25	51.42	13342181.0
2010-10-21 12:00:00	QQQ	ETF	51.42	51.43	51.2	51.2762	7265839.0
2010-10-21 13:00:00	QQQ	ETF	51.275	51.4	50.82	50.89	12631023.0
2010-10-21 14:00:00	QQQ	ETF	50.87	51.14	50.79	51.1099	10022976.0
2010-10-21 15:00:00	QQQ	ETF	51.12	51.34	51.06	51.2908	11516548.0
2010-10-21 16:00:00	QQQ	ETF	51.28	51.29	51.11	51.16	3345575.0
2010-10-21 17:00:00	QQQ	ETF	51.16	51.2	51.11	51.18	197913.0
2010-10-21 18:00:00	QQQ	ETF	51.17	51.2	51.16	51.16	24400.0
2010-10-21 19:00:00	QQQ	ETF	51.18	51.18	51.14	51.14	25190.0
2010-10-21 05:00:00	IWM	ETF	70.49	70.51	70.49	70.51	5300.0
2010-10-21 06:00:00	IWM	ETF	70.65	70.65	70.61	70.61	5100.0
2010-10-21 07:00:00	IWM	ETF	70.49	70.84	70.49	70.77	48800.0
2010-10-21 08:00:00	IWM	ETF	70.8	70.81	70.59	70.65	117703.0
2010-10-21 09:00:00	IWM	ETF	70.64	70.81	70.4399	70.74	4954234.0
2010-10-21 10:00:00	IWM	ETF	70.7453	71.09	70.52	70.99	7228079.0
2010-10-21 11:00:00	IWM	ETF	70.99	71.01	69.78	70.09	11426682.0
2010-10-21 12:00:00	IWM	ETF	70.08	70.1	69.42	69.58	6800203.0
2010-10-21 13:00:00	IWM	ETF	69.58	69.78	68.97	69.05	7708982.0
2010-10-21 14:00:00	IWM	ETF	69.05	69.43	68.96	69.33	6583073.0
2010-10-21 15:00:00	IWM	ETF	69.34	70.95	69.31	69.88	11641138.0
2010-10-21 16:00:00	IWM	ETF	69.88	71.0	69.05	69.79	1856466.0
2010-10-21 17:00:00	IWM	ETF	69.78	69.85	69.75	69.85	26649.0
2010-10-21 18:00:00	IWM	ETF	69.83	69.83	69.69	69.69	13716.0
2010-10-21 19:00:00	IWM	ETF	69.69	69.77	69.69	69.72	2200.0
2010-10-21 06:00:00	DIA	ETF	111.6	111.6	111.6	111.6	10000.0
2010-10-21 07:00:00	DIA	ETF	111.6	111.84	111.6	111.7	17100.0
2010-10-21 08:00:00	DIA	ETF	111.71	111.83	111.56	111.56	127160.0

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

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