PREVIEW / etf_1hour / 2010-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-04.parquet
  size:    166 KB
  rows:    5,111

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-04 04:00:00	SPY	ETF	114.49	114.49	113.96	114.09	2532.0
2010-10-04 05:00:00	SPY	ETF	114.09	114.09	113.93	113.93	34869.0
2010-10-04 06:00:00	SPY	ETF	114.09	114.24	114.04	114.1	33300.0
2010-10-04 07:00:00	SPY	ETF	114.16	114.43	114.1	114.42	206218.0
2010-10-04 08:00:00	SPY	ETF	114.42	114.46	114.0	114.28	637443.0
2010-10-04 09:00:00	SPY	ETF	114.29	114.85	114.27	114.46	28814858.0
2010-10-04 10:00:00	SPY	ETF	114.46	114.7	114.11	114.23	24721270.0
2010-10-04 11:00:00	SPY	ETF	114.23	114.23	113.42	113.44	26671796.0
2010-10-04 12:00:00	SPY	ETF	113.44	113.52	113.18	113.47	17571421.0
2010-10-04 13:00:00	SPY	ETF	113.46	113.62	113.35	113.54	12644614.0
2010-10-04 14:00:00	SPY	ETF	113.55	113.61	113.24	113.45	14084365.0
2010-10-04 15:00:00	SPY	ETF	113.45	113.78	113.4	113.74	33288240.0
2010-10-04 16:00:00	SPY	ETF	113.74	114.17	113.74	113.97	5836844.0
2010-10-04 17:00:00	SPY	ETF	113.98	114.0	113.92	113.94	51263.0
2010-10-04 18:00:00	SPY	ETF	113.94	113.96	113.75	113.96	79252.0
2010-10-04 19:00:00	SPY	ETF	113.93	113.95	113.85	113.91	94353.0
2010-10-04 04:00:00	QQQ	ETF	48.95	48.95	48.68	48.68	2500.0
2010-10-04 05:00:00	QQQ	ETF	48.72	48.73	48.72	48.72	5500.0
2010-10-04 06:00:00	QQQ	ETF	48.81	48.81	48.75	48.75	5500.0
2010-10-04 07:00:00	QQQ	ETF	48.78	48.91	48.78	48.88	63655.0
2010-10-04 08:00:00	QQQ	ETF	48.88	48.91	48.78	48.83	406937.0
2010-10-04 09:00:00	QQQ	ETF	48.83	49.05	48.78	48.81	11651820.0
2010-10-04 10:00:00	QQQ	ETF	48.82	48.96	48.6901	48.7701	10488753.0
2010-10-04 11:00:00	QQQ	ETF	48.77	48.77	48.29	48.3	10893408.0
2010-10-04 12:00:00	QQQ	ETF	48.29	48.35	48.2	48.325	7033689.0
2010-10-04 13:00:00	QQQ	ETF	48.33	48.45	48.3	48.41	5542347.0
2010-10-04 14:00:00	QQQ	ETF	48.41	48.49	48.305	48.45	5925123.0
2010-10-04 15:00:00	QQQ	ETF	48.44	48.57	48.41	48.49	10615696.0
2010-10-04 16:00:00	QQQ	ETF	48.48	48.63	48.34	48.62	4895912.0
2010-10-04 17:00:00	QQQ	ETF	48.62	48.64	48.58	48.61	35651.0
2010-10-04 18:00:00	QQQ	ETF	48.61	48.61	48.59	48.61	21230.0
2010-10-04 19:00:00	QQQ	ETF	48.61	48.63	48.55	48.6	90596.0
2010-10-04 04:00:00	IWM	ETF	67.43	67.43	67.43	67.43	100.0
2010-10-04 05:00:00	IWM	ETF	67.4	67.4	67.4	67.4	400.0
2010-10-04 06:00:00	IWM	ETF	67.48	67.59	67.45	67.45	6100.0
2010-10-04 07:00:00	IWM	ETF	67.51	67.73	67.49	67.73	51968.0
2010-10-04 08:00:00	IWM	ETF	67.12	67.8	67.12	67.63	71906.0
2010-10-04 09:00:00	IWM	ETF	67.63	68.1	67.6	67.62	7819313.0
2010-10-04 10:00:00	IWM	ETF	67.6	67.87	67.28	67.44	9448799.0
2010-10-04 11:00:00	IWM	ETF	67.44	67.44	66.59	66.61	8908212.0
2010-10-04 12:00:00	IWM	ETF	66.6	66.79	66.48	66.78	4557762.0
2010-10-04 13:00:00	IWM	ETF	66.78	67.01	66.77	66.96	2966644.0
2010-10-04 14:00:00	IWM	ETF	66.95	67.0	66.68	66.91	4043517.0
2010-10-04 15:00:00	IWM	ETF	66.91	67.18	66.81	66.93	9128485.0
2010-10-04 16:00:00	IWM	ETF	66.92	67.9185	66.8958	67.07	4268842.0
2010-10-04 17:00:00	IWM	ETF	67.05	67.05	67.03	67.03	460.0
2010-10-04 18:00:00	IWM	ETF	67.01	67.01	66.99	66.99	400.0
2010-10-04 19:00:00	IWM	ETF	66.95	66.95	66.92	66.92	4580.0
2010-10-04 07:00:00	DIA	ETF	107.96	108.11	107.96	108.11	1700.0
2010-10-04 08:00:00	DIA	ETF	108.17	108.17	107.96	108.0	5050.0

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

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