PREVIEW / etf_1hour / 2013-07-23

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-07-23.parquet
  size:    205 KB
  rows:    6,436

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
2013-07-23 04:00:00	SPY	ETF	169.71	169.8	169.65	169.8	9250.0
2013-07-23 05:00:00	SPY	ETF	169.75	169.8	169.7	169.79	11000.0
2013-07-23 06:00:00	SPY	ETF	169.75	169.85	169.72	169.84	76800.0
2013-07-23 07:00:00	SPY	ETF	169.81	169.84	169.65	169.8	122434.0
2013-07-23 08:00:00	SPY	ETF	169.81	169.82	169.67	169.7	364211.0
2013-07-23 09:00:00	SPY	ETF	169.7	169.87	169.4976	169.63	11364895.0
2013-07-23 10:00:00	SPY	ETF	169.63	169.64	169.12	169.145	15654103.0
2013-07-23 11:00:00	SPY	ETF	169.145	169.4	169.05	169.3	8850223.0
2013-07-23 12:00:00	SPY	ETF	169.29	169.38	169.17	169.23	4933684.0
2013-07-23 13:00:00	SPY	ETF	169.235	169.52	169.23	169.37	6820976.0
2013-07-23 14:00:00	SPY	ETF	169.37	169.6	169.35	169.55	7193166.0
2013-07-23 15:00:00	SPY	ETF	169.55	169.55	169.09	169.23	15059023.0
2013-07-23 16:00:00	SPY	ETF	169.23	169.54	169.14	169.47	6846189.0
2013-07-23 17:00:00	SPY	ETF	169.48	169.48	169.32	169.33	591871.0
2013-07-23 18:00:00	SPY	ETF	169.39	169.4	169.21	169.36	43895.0
2013-07-23 19:00:00	SPY	ETF	169.33	169.39	169.33	169.38	20241.0
2013-07-23 04:00:00	QQQ	ETF	74.89	74.95	74.87	74.95	8000.0
2013-07-23 05:00:00	QQQ	ETF	74.93	74.95	74.91	74.95	5122.0
2013-07-23 06:00:00	QQQ	ETF	74.93	75.0	74.93	75.0	3777.0
2013-07-23 07:00:00	QQQ	ETF	74.99	75.0	74.93	74.96	14415.0
2013-07-23 08:00:00	QQQ	ETF	74.97	74.97	74.87	74.89	56600.0
2013-07-23 09:00:00	QQQ	ETF	74.9	74.96	74.72	74.72	2081498.0
2013-07-23 10:00:00	QQQ	ETF	74.725	74.725	74.39	74.42	3486284.0
2013-07-23 11:00:00	QQQ	ETF	74.42	74.56	74.3801	74.51	1886920.0
2013-07-23 12:00:00	QQQ	ETF	74.505	74.54	74.4	74.446	1753369.0
2013-07-23 13:00:00	QQQ	ETF	74.45	74.63	74.45	74.54	1316384.0
2013-07-23 14:00:00	QQQ	ETF	74.54	74.58	74.43	74.54	1698291.0
2013-07-23 15:00:00	QQQ	ETF	74.54	74.54	74.2	74.27	6037455.0
2013-07-23 16:00:00	QQQ	ETF	74.27	74.8434	74.18	74.7	2896727.0
2013-07-23 17:00:00	QQQ	ETF	74.71	74.71	74.3192	74.55	1310685.0
2013-07-23 18:00:00	QQQ	ETF	74.6	74.6	74.49	74.58	15837.0
2013-07-23 19:00:00	QQQ	ETF	74.59	74.62	74.58	74.6	5400.0
2013-07-23 04:00:00	IWM	ETF	104.75	104.75	104.75	104.75	100.0
2013-07-23 05:00:00	IWM	ETF	104.9	104.9	104.9	104.9	100.0
2013-07-23 07:00:00	IWM	ETF	104.95	104.95	104.79	104.9	17100.0
2013-07-23 08:00:00	IWM	ETF	104.89	105.13	104.8	104.8	216980.0
2013-07-23 09:00:00	IWM	ETF	104.78	104.95	104.68	104.78	1964726.0
2013-07-23 10:00:00	IWM	ETF	104.77	104.78	104.32	104.34	6730837.0
2013-07-23 11:00:00	IWM	ETF	104.345	104.6	104.25	104.53	3296208.0
2013-07-23 12:00:00	IWM	ETF	104.53	104.59	104.459	104.52	1492588.0
2013-07-23 13:00:00	IWM	ETF	104.53	104.69	104.52	104.53	1362198.0
2013-07-23 14:00:00	IWM	ETF	104.5365	104.67	104.51	104.64	2138040.0
2013-07-23 15:00:00	IWM	ETF	104.635	104.64	104.29	104.45	4595631.0
2013-07-23 16:00:00	IWM	ETF	104.46	104.93	104.3195	104.66	1024554.0
2013-07-23 17:00:00	IWM	ETF	104.66	104.69	104.51	104.69	9169.0
2013-07-23 19:00:00	IWM	ETF	104.58	104.59	104.58	104.59	1400.0
2013-07-23 08:00:00	DIA	ETF	155.5	155.55	155.5	155.5	2797.0
2013-07-23 09:00:00	DIA	ETF	155.57	155.67	155.42	155.59	253813.0
2013-07-23 10:00:00	DIA	ETF	155.59	155.59	155.17	155.2	569890.0
2013-07-23 11:00:00	DIA	ETF	155.19	155.39	155.08	155.28	426777.0

> showing 50 of 6,436 rows — these rows as CSV

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