PREVIEW / etf_1hour / 2011-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-03-28.parquet
  size:    175 KB
  rows:    5,385

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
2011-03-28 04:00:00	SPY	ETF	131.55	131.71	131.55	131.65	11000.0
2011-03-28 05:00:00	SPY	ETF	131.75	131.76	131.48	131.54	13100.0
2011-03-28 06:00:00	SPY	ETF	131.47	131.59	131.46	131.59	36600.0
2011-03-28 07:00:00	SPY	ETF	131.56	131.7	131.53	131.61	263644.0
2011-03-28 08:00:00	SPY	ETF	131.62	131.65	131.38	131.61	1282304.0
2011-03-28 09:00:00	SPY	ETF	131.61	131.85	131.46	131.7499	13507307.0
2011-03-28 10:00:00	SPY	ETF	131.75	131.92	131.59	131.62	16349255.0
2011-03-28 11:00:00	SPY	ETF	131.62	131.65	131.35	131.5	12091876.0
2011-03-28 12:00:00	SPY	ETF	131.49	131.56	131.41	131.54	8028624.0
2011-03-28 13:00:00	SPY	ETF	131.54	131.67	131.49	131.49	5391740.0
2011-03-28 14:00:00	SPY	ETF	131.5	131.61	131.38	131.42	8815876.0
2011-03-28 15:00:00	SPY	ETF	131.43	131.55	130.94	130.97	30068763.0
2011-03-28 16:00:00	SPY	ETF	130.97	131.0126	130.62	130.69	11690914.0
2011-03-28 17:00:00	SPY	ETF	130.69	130.74	130.6	130.66	131908.0
2011-03-28 18:00:00	SPY	ETF	130.65	130.94	130.61	130.67	892340.0
2011-03-28 19:00:00	SPY	ETF	130.64	130.68	130.58	130.58	76647.0
2011-03-28 04:00:00	QQQ	ETF	56.84	57.11	56.84	57.11	300.0
2011-03-28 05:00:00	QQQ	ETF	57.15	57.15	57.04	57.08	3500.0
2011-03-28 06:00:00	QQQ	ETF	57.09	57.09	57.07	57.07	300.0
2011-03-28 07:00:00	QQQ	ETF	57.08	57.14	57.05	57.1	198111.0
2011-03-28 08:00:00	QQQ	ETF	57.08	57.1	56.97	57.07	193155.0
2011-03-28 09:00:00	QQQ	ETF	57.06	57.11	56.84	56.94	6668820.0
2011-03-28 10:00:00	QQQ	ETF	56.95	57.06	56.85	56.92	5155020.0
2011-03-28 11:00:00	QQQ	ETF	56.92	56.97	56.72	56.86	3140186.0
2011-03-28 12:00:00	QQQ	ETF	56.85	56.9	56.82	56.86	1279295.0
2011-03-28 13:00:00	QQQ	ETF	56.86	56.94	56.83	56.83	2094907.0
2011-03-28 14:00:00	QQQ	ETF	56.83	56.9	56.73	56.73	5168350.0
2011-03-28 15:00:00	QQQ	ETF	56.74	56.81	56.5	56.53	9001546.0
2011-03-28 16:00:00	QQQ	ETF	56.53	56.53	56.37	56.45	1546643.0
2011-03-28 17:00:00	QQQ	ETF	56.45	56.509	56.38	56.42	144645.0
2011-03-28 18:00:00	QQQ	ETF	56.42	56.45	56.39	56.41	51363.0
2011-03-28 19:00:00	QQQ	ETF	56.41	56.42	56.39	56.4	7900.0
2011-03-28 04:00:00	IWM	ETF	82.34	82.64	82.34	82.64	11728.0
2011-03-28 05:00:00	IWM	ETF	82.74	82.78	82.57	82.57	14200.0
2011-03-28 06:00:00	IWM	ETF	82.62	82.62	82.62	82.62	100.0
2011-03-28 07:00:00	IWM	ETF	82.62	82.71	82.62	82.64	23223.0
2011-03-28 08:00:00	IWM	ETF	82.64	82.64	82.47	82.6	160100.0
2011-03-28 09:00:00	IWM	ETF	82.6	82.729	82.21	82.63	6265329.0
2011-03-28 10:00:00	IWM	ETF	82.64	82.76	82.45	82.51	4691872.0
2011-03-28 11:00:00	IWM	ETF	82.51	82.58	82.25	82.46	2550823.0
2011-03-28 12:00:00	IWM	ETF	82.46	82.49	82.34	82.379	1873729.0
2011-03-28 13:00:00	IWM	ETF	82.3775	82.5	82.34	82.39	1118337.0
2011-03-28 14:00:00	IWM	ETF	82.4	82.56	82.29	82.36	4182344.0
2011-03-28 15:00:00	IWM	ETF	82.355	82.49	81.97	82.04	10297472.0
2011-03-28 16:00:00	IWM	ETF	82.04	82.08	81.76	81.79	2413332.0
2011-03-28 17:00:00	IWM	ETF	81.81	81.86	81.78	81.79	19500.0
2011-03-28 18:00:00	IWM	ETF	81.81	81.83	81.81	81.83	213.0
2011-03-28 19:00:00	IWM	ETF	81.8	81.83	81.78	81.83	2800.0
2011-03-28 08:00:00	DIA	ETF	122.2	122.23	122.14	122.18	10400.0
2011-03-28 09:00:00	DIA	ETF	122.22	122.39	122.041	122.36	308284.0

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

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