PREVIEW / etf_1hour / 2010-10-22

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-22.parquet
  size:    158 KB
  rows:    4,912

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-22 04:00:00	SPY	ETF	118.1	118.1	117.85	117.89	6300.0
2010-10-22 05:00:00	SPY	ETF	117.95	117.95	117.93	117.93	1000.0
2010-10-22 06:00:00	SPY	ETF	117.97	118.0	117.97	118.0	1500.0
2010-10-22 07:00:00	SPY	ETF	118.16	118.4	118.06	118.35	272310.0
2010-10-22 08:00:00	SPY	ETF	118.38	118.47	117.99	118.44	1458006.0
2010-10-22 09:00:00	SPY	ETF	118.44	118.57	118.06	118.1	18844198.0
2010-10-22 10:00:00	SPY	ETF	118.1	118.41	118.0	118.32	18369148.0
2010-10-22 11:00:00	SPY	ETF	118.32	118.38	118.07	118.12	15567196.0
2010-10-22 12:00:00	SPY	ETF	118.13	118.36	118.11	118.27	8059828.0
2010-10-22 13:00:00	SPY	ETF	118.28	118.35	118.09	118.11	7114180.0
2010-10-22 14:00:00	SPY	ETF	118.11	118.34	118.1	118.205	9823908.0
2010-10-22 15:00:00	SPY	ETF	118.2	118.42	118.15	118.38	23771754.0
2010-10-22 16:00:00	SPY	ETF	118.38	118.59	118.085	118.51	4515292.0
2010-10-22 17:00:00	SPY	ETF	118.52	118.57	118.5	118.52	173672.0
2010-10-22 18:00:00	SPY	ETF	118.52	118.55	118.45	118.54	60136.0
2010-10-22 19:00:00	SPY	ETF	118.5	118.55	118.48	118.55	15315.0
2010-10-22 05:00:00	QQQ	ETF	51.15	51.15	51.15	51.15	200.0
2010-10-22 06:00:00	QQQ	ETF	51.15	51.15	51.15	51.15	500.0
2010-10-22 07:00:00	QQQ	ETF	51.2	51.34	51.2	51.3	368724.0
2010-10-22 08:00:00	QQQ	ETF	51.33	51.4	51.22	51.38	928564.0
2010-10-22 09:00:00	QQQ	ETF	51.39	51.54	51.21	51.39	9517194.0
2010-10-22 10:00:00	QQQ	ETF	51.38	51.54	51.29	51.52	7317504.0
2010-10-22 11:00:00	QQQ	ETF	51.5138	51.6	51.46	51.519	5120812.0
2010-10-22 12:00:00	QQQ	ETF	51.51	51.66	51.5	51.61	4377746.0
2010-10-22 13:00:00	QQQ	ETF	51.61	51.66	51.53	51.53	3547434.0
2010-10-22 14:00:00	QQQ	ETF	51.535	51.69	51.525	51.61	3812174.0
2010-10-22 15:00:00	QQQ	ETF	51.61	51.69	51.55	51.64	9085703.0
2010-10-22 16:00:00	QQQ	ETF	51.64	51.74	51.61	51.74	1683757.0
2010-10-22 17:00:00	QQQ	ETF	51.72	51.74	51.69	51.73	13306.0
2010-10-22 18:00:00	QQQ	ETF	51.72	51.74	51.68	51.71	2200.0
2010-10-22 19:00:00	QQQ	ETF	51.67	51.71	51.67	51.71	1300.0
2010-10-22 06:00:00	IWM	ETF	69.82	69.9	69.82	69.9	1260.0
2010-10-22 07:00:00	IWM	ETF	69.96	70.09	69.95	70.01	12800.0
2010-10-22 08:00:00	IWM	ETF	70.06	70.15	70.01	70.13	213281.0
2010-10-22 09:00:00	IWM	ETF	70.12	70.37	69.88	69.88	5367459.0
2010-10-22 10:00:00	IWM	ETF	69.89	70.2601	69.76	70.13	3299348.0
2010-10-22 11:00:00	IWM	ETF	70.14	70.21	69.91	69.96	2186244.0
2010-10-22 12:00:00	IWM	ETF	69.96	70.25	69.92	70.19	1960891.0
2010-10-22 13:00:00	IWM	ETF	70.2	70.25	70.09	70.09	1311040.0
2010-10-22 14:00:00	IWM	ETF	70.1	70.36	70.06	70.201	3168182.0
2010-10-22 15:00:00	IWM	ETF	70.21	70.39	70.17	70.3	5682327.0
2010-10-22 16:00:00	IWM	ETF	70.3	70.43	70.2665	70.37	2088803.0
2010-10-22 17:00:00	IWM	ETF	70.33	70.38	70.3	70.33	30700.0
2010-10-22 18:00:00	IWM	ETF	70.3	70.35	70.29	70.32	24922.0
2010-10-22 19:00:00	IWM	ETF	70.36	70.37	70.36	70.36	3300.0
2010-10-22 05:00:00	DIA	ETF	111.36	111.36	111.36	111.36	100.0
2010-10-22 07:00:00	DIA	ETF	111.65	111.69	111.65	111.69	7400.0
2010-10-22 08:00:00	DIA	ETF	111.65	111.7	111.59	111.7	3900.0
2010-10-22 09:00:00	DIA	ETF	111.7	111.77	111.26	111.29	953309.0
2010-10-22 10:00:00	DIA	ETF	111.28	111.5	111.19	111.42	590476.0

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

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