PREVIEW / etf_1hour / 2011-05-27

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-05-27.parquet
  size:    171 KB
  rows:    5,259

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-05-27 04:00:00	SPY	ETF	133.35	133.53	133.12	133.12	3215.0
2011-05-27 05:00:00	SPY	ETF	133.18	133.24	133.0	133.16	13500.0
2011-05-27 06:00:00	SPY	ETF	133.13	133.35	133.13	133.2	31650.0
2011-05-27 07:00:00	SPY	ETF	133.17	133.4	133.16	133.27	188197.0
2011-05-27 08:00:00	SPY	ETF	133.55	133.61	133.27	133.44	1335576.0
2011-05-27 09:00:00	SPY	ETF	133.44	133.7	133.24	133.62	13940674.0
2011-05-27 10:00:00	SPY	ETF	133.62	133.69	133.19	133.66	23264496.0
2011-05-27 11:00:00	SPY	ETF	133.66	133.87	133.58	133.74	16300063.0
2011-05-27 12:00:00	SPY	ETF	133.75	133.79	133.53	133.54	9690469.0
2011-05-27 13:00:00	SPY	ETF	133.54	133.66	133.42	133.53	9881709.0
2011-05-27 14:00:00	SPY	ETF	133.53	133.85	133.3	133.33	11142227.0
2011-05-27 15:00:00	SPY	ETF	133.33	133.6	133.23	133.52	23175106.0
2011-05-27 16:00:00	SPY	ETF	133.53	133.8	133.3	133.62	9965800.0
2011-05-27 17:00:00	SPY	ETF	133.58	133.62	133.47	133.5	50103.0
2011-05-27 18:00:00	SPY	ETF	133.5	133.54	133.43	133.49	103929.0
2011-05-27 19:00:00	SPY	ETF	133.49	133.57	133.49	133.53	14500.0
2011-05-27 04:00:00	QQQ	ETF	57.29	57.29	57.29	57.29	100.0
2011-05-27 05:00:00	QQQ	ETF	57.15	57.15	57.15	57.15	100.0
2011-05-27 06:00:00	QQQ	ETF	57.24	57.24	57.22	57.22	1100.0
2011-05-27 07:00:00	QQQ	ETF	57.22	57.26	57.2	57.23	15458.0
2011-05-27 08:00:00	QQQ	ETF	57.24	57.35	57.21	57.28	125058.0
2011-05-27 09:00:00	QQQ	ETF	57.28	57.34	57.2	57.3	3795213.0
2011-05-27 10:00:00	QQQ	ETF	57.3	57.44	57.19	57.42	6702416.0
2011-05-27 11:00:00	QQQ	ETF	57.425	57.48	57.4	57.48	4934755.0
2011-05-27 12:00:00	QQQ	ETF	57.475	57.49	57.39	57.4	3444864.0
2011-05-27 13:00:00	QQQ	ETF	57.4	57.45	57.37	57.4102	2246768.0
2011-05-27 14:00:00	QQQ	ETF	57.41	57.45	57.29	57.31	2413507.0
2011-05-27 15:00:00	QQQ	ETF	57.3098	57.43	57.27	57.42	3928773.0
2011-05-27 16:00:00	QQQ	ETF	57.43	57.4451	57.3	57.36	1417073.0
2011-05-27 17:00:00	QQQ	ETF	57.38	57.45	57.38	57.45	8219.0
2011-05-27 18:00:00	QQQ	ETF	57.39	57.4	57.39	57.4	29575.0
2011-05-27 19:00:00	QQQ	ETF	57.4	57.42	57.39	57.42	4935.0
2011-05-27 04:00:00	IWM	ETF	82.89	83.4	82.89	83.32	1260.0
2011-05-27 05:00:00	IWM	ETF	83.18	83.18	83.18	83.18	2000.0
2011-05-27 06:00:00	IWM	ETF	83.38	83.39	83.38	83.39	2000.0
2011-05-27 07:00:00	IWM	ETF	83.15	83.4	83.15	83.4	2100.0
2011-05-27 08:00:00	IWM	ETF	83.56	83.66	83.32	83.45	535646.0
2011-05-27 09:00:00	IWM	ETF	83.48	83.76	83.34	83.72	5951469.0
2011-05-27 10:00:00	IWM	ETF	83.74	83.84	83.38	83.81	7000436.0
2011-05-27 11:00:00	IWM	ETF	83.81	83.93	83.66	83.83	5493961.0
2011-05-27 12:00:00	IWM	ETF	83.82	83.869	83.56	83.57	4870389.0
2011-05-27 13:00:00	IWM	ETF	83.57	83.68	83.54	83.61	2828138.0
2011-05-27 14:00:00	IWM	ETF	83.62	83.65	83.26	83.3	5286019.0
2011-05-27 15:00:00	IWM	ETF	83.29	83.68	83.26	83.63	5868736.0
2011-05-27 16:00:00	IWM	ETF	83.63	83.75	83.61	83.7	1937263.0
2011-05-27 17:00:00	IWM	ETF	83.66	83.69	83.63	83.63	10215.0
2011-05-27 18:00:00	IWM	ETF	83.63	83.69	83.62	83.69	5200.0
2011-05-27 19:00:00	IWM	ETF	83.7	83.7	83.67	83.67	700.0
2011-05-27 04:00:00	DIA	ETF	124.26	124.33	124.22	124.22	600.0
2011-05-27 05:00:00	DIA	ETF	124.03	124.03	123.87	123.87	1500.0

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

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