PREVIEW / etf_1hour / 2011-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-04-06.parquet
  size:    179 KB
  rows:    5,499

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-04-06 04:00:00	SPY	ETF	133.29	133.44	133.29	133.4	5515.0
2011-04-06 05:00:00	SPY	ETF	133.42	133.65	133.42	133.65	4055.0
2011-04-06 06:00:00	SPY	ETF	133.71	134.04	133.7	134.03	241507.0
2011-04-06 07:00:00	SPY	ETF	134.0	134.05	133.84	133.95	425628.0
2011-04-06 08:00:00	SPY	ETF	133.92	134.08	133.82	133.84	1282557.0
2011-04-06 09:00:00	SPY	ETF	133.85	134.0	133.71	133.79	13928729.0
2011-04-06 10:00:00	SPY	ETF	133.79	133.88	133.51	133.77	18407545.0
2011-04-06 11:00:00	SPY	ETF	133.77	133.78	133.18	133.19	22705669.0
2011-04-06 12:00:00	SPY	ETF	133.19	133.38	133.12	133.29	11225014.0
2011-04-06 13:00:00	SPY	ETF	133.29	133.46	133.25	133.45	7441497.0
2011-04-06 14:00:00	SPY	ETF	133.46	133.65	133.39	133.58	9567409.0
2011-04-06 15:00:00	SPY	ETF	133.58	133.71	133.53	133.62	22903405.0
2011-04-06 16:00:00	SPY	ETF	133.62	133.6802	133.03	133.26	10823752.0
2011-04-06 17:00:00	SPY	ETF	133.25	133.37	133.25	133.35	118262.0
2011-04-06 18:00:00	SPY	ETF	133.37	133.66	133.35	133.39	171193.0
2011-04-06 19:00:00	SPY	ETF	133.38	133.39	133.32	133.33	55921.0
2011-04-06 05:00:00	QQQ	ETF	57.29	57.37	57.29	57.37	3600.0
2011-04-06 06:00:00	QQQ	ETF	57.39	57.59	57.38	57.58	73812.0
2011-04-06 07:00:00	QQQ	ETF	57.57	57.63	57.53	57.58	191947.0
2011-04-06 08:00:00	QQQ	ETF	57.55	57.58	57.46	57.48	495978.0
2011-04-06 09:00:00	QQQ	ETF	57.48	57.73	57.46	57.59	7263294.0
2011-04-06 10:00:00	QQQ	ETF	57.5901	57.66	57.34	57.45	8790691.0
2011-04-06 11:00:00	QQQ	ETF	57.45	57.459	56.98	56.985	7523869.0
2011-04-06 12:00:00	QQQ	ETF	56.99	57.12	56.93	57.03	5623384.0
2011-04-06 13:00:00	QQQ	ETF	57.03	57.19	57.02	57.1808	2096200.0
2011-04-06 14:00:00	QQQ	ETF	57.1802	57.3	57.16	57.24	2682101.0
2011-04-06 15:00:00	QQQ	ETF	57.25	57.29	57.18	57.23	4910643.0
2011-04-06 16:00:00	QQQ	ETF	57.23	57.3029	57.12	57.12	3827777.0
2011-04-06 17:00:00	QQQ	ETF	57.15	57.2	57.15	57.18	13162.0
2011-04-06 18:00:00	QQQ	ETF	57.23	57.23	57.18	57.19	26926.0
2011-04-06 19:00:00	QQQ	ETF	57.19	57.23	57.18	57.23	3734.0
2011-04-06 04:00:00	IWM	ETF	85.18	85.18	85.18	85.18	1000.0
2011-04-06 05:00:00	IWM	ETF	85.41	85.41	85.41	85.41	3000.0
2011-04-06 06:00:00	IWM	ETF	85.56	85.71	85.56	85.7	56700.0
2011-04-06 07:00:00	IWM	ETF	85.66	85.72	85.59	85.63	43761.0
2011-04-06 08:00:00	IWM	ETF	85.63	85.72	85.62	85.64	213953.0
2011-04-06 09:00:00	IWM	ETF	85.64	85.88	85.49	85.7	6374997.0
2011-04-06 10:00:00	IWM	ETF	85.708	85.83	85.43	85.48	7529846.0
2011-04-06 11:00:00	IWM	ETF	85.48	85.49	85.03	85.031	10958145.0
2011-04-06 12:00:00	IWM	ETF	85.03	85.2201	84.91	85.01	6313230.0
2011-04-06 13:00:00	IWM	ETF	85.0	85.23	84.975	85.22	2566110.0
2011-04-06 14:00:00	IWM	ETF	85.23	85.46	85.14	85.41	5056146.0
2011-04-06 15:00:00	IWM	ETF	85.41	85.45	85.25	85.32	10428424.0
2011-04-06 16:00:00	IWM	ETF	85.32	85.42	85.13	85.15	1056234.0
2011-04-06 17:00:00	IWM	ETF	85.15	85.24	85.13	85.22	6500.0
2011-04-06 18:00:00	IWM	ETF	85.22	85.26	85.21	85.25	3100.0
2011-04-06 19:00:00	IWM	ETF	85.25	85.25	85.23	85.23	800.0
2011-04-06 04:00:00	DIA	ETF	123.89	123.89	123.89	123.89	225.0
2011-04-06 07:00:00	DIA	ETF	124.39	124.39	124.28	124.28	2300.0
2011-04-06 08:00:00	DIA	ETF	124.31	124.39	124.22	124.23	32770.0

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

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