PREVIEW / etf_1hour / 2014-03-17

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-03-17.parquet
  size:    213 KB
  rows:    6,778

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
2014-03-17 04:00:00	SPY	ETF	184.32	185.68	184.32	185.57	53775.0
2014-03-17 05:00:00	SPY	ETF	185.58	185.77	185.42	185.57	79310.0
2014-03-17 06:00:00	SPY	ETF	185.56	185.68	185.45	185.46	54620.0
2014-03-17 07:00:00	SPY	ETF	185.42	185.55	185.35	185.47	325192.0
2014-03-17 08:00:00	SPY	ETF	184.45	185.57	183.87	185.35	1235982.0
2014-03-17 09:00:00	SPY	ETF	185.36	186.54	185.36	186.381	18274465.0
2014-03-17 10:00:00	SPY	ETF	186.38	186.77	185.94	186.05	21670497.0
2014-03-17 11:00:00	SPY	ETF	186.05	186.34	185.8	186.25	10739380.0
2014-03-17 12:00:00	SPY	ETF	186.26	186.59	186.14	186.37	8575312.0
2014-03-17 13:00:00	SPY	ETF	186.378	186.47	186.155	186.35	5959120.0
2014-03-17 14:00:00	SPY	ETF	186.3401	186.66	186.23	186.48	6583605.0
2014-03-17 15:00:00	SPY	ETF	186.48	186.615	186.13	186.34	15858874.0
2014-03-17 16:00:00	SPY	ETF	186.33	186.41	186.1814	186.41	6844364.0
2014-03-17 17:00:00	SPY	ETF	186.4	186.5	186.33	186.43	448003.0
2014-03-17 18:00:00	SPY	ETF	186.43	186.47	186.38	186.45	56678.0
2014-03-17 19:00:00	SPY	ETF	186.479	186.48	186.36	186.36	68956.0
2014-03-17 04:00:00	QQQ	ETF	88.99	89.19	88.99	89.19	12300.0
2014-03-17 05:00:00	QQQ	ETF	89.35	89.35	89.27	89.28	400.0
2014-03-17 06:00:00	QQQ	ETF	89.28	89.35	89.21	89.21	3920.0
2014-03-17 07:00:00	QQQ	ETF	89.21	89.21	89.15	89.15	19080.0
2014-03-17 08:00:00	QQQ	ETF	89.14	89.22	88.56	89.08	386650.0
2014-03-17 09:00:00	QQQ	ETF	89.11	89.77	88.65	89.66	5326097.0
2014-03-17 10:00:00	QQQ	ETF	89.66	89.91	89.395	89.55	5110139.0
2014-03-17 11:00:00	QQQ	ETF	89.54	89.7	89.35	89.64	3148980.0
2014-03-17 12:00:00	QQQ	ETF	89.64	89.85	89.57	89.75	2542169.0
2014-03-17 13:00:00	QQQ	ETF	89.7501	89.815	89.63	89.71	1366267.0
2014-03-17 14:00:00	QQQ	ETF	89.72	89.83	89.63	89.7012	1549540.0
2014-03-17 15:00:00	QQQ	ETF	89.705	89.74	89.4	89.45	5171600.0
2014-03-17 16:00:00	QQQ	ETF	89.46	89.686	88.6649	89.46	2234700.0
2014-03-17 17:00:00	QQQ	ETF	89.46	89.48	89.45	89.47	905229.0
2014-03-17 18:00:00	QQQ	ETF	89.46	89.51	89.46	89.51	5450.0
2014-03-17 19:00:00	QQQ	ETF	89.5	89.5	89.43	89.44	3765.0
2014-03-17 05:00:00	IWM	ETF	118.31	118.31	118.31	118.31	100.0
2014-03-17 06:00:00	IWM	ETF	118.21	118.21	118.2	118.2	22000.0
2014-03-17 07:00:00	IWM	ETF	118.21	118.4	118.12	118.16	112500.0
2014-03-17 08:00:00	IWM	ETF	118.18	118.26	118.02	118.07	193394.0
2014-03-17 09:00:00	IWM	ETF	118.07	119.02	118.05	118.79	6573457.0
2014-03-17 10:00:00	IWM	ETF	118.78	119.1	118.23	118.34	6390350.0
2014-03-17 11:00:00	IWM	ETF	118.35	118.55	117.878	118.22	3911658.0
2014-03-17 12:00:00	IWM	ETF	118.23	118.44	118.07	118.36	3770670.0
2014-03-17 13:00:00	IWM	ETF	118.37	118.49	118.12	118.2503	2396367.0
2014-03-17 14:00:00	IWM	ETF	118.26	118.4	118.07	118.22	4031103.0
2014-03-17 15:00:00	IWM	ETF	118.235	118.311	117.99	118.07	5305350.0
2014-03-17 16:00:00	IWM	ETF	118.07	118.2952	117.89	118.02	2095420.0
2014-03-17 17:00:00	IWM	ETF	118.03	118.07	117.4495	117.99	1046142.0
2014-03-17 18:00:00	IWM	ETF	118.069	118.069	118.069	118.069	300.0
2014-03-17 19:00:00	IWM	ETF	118.02	118.03	118.02	118.03	700.0
2014-03-17 07:00:00	DIA	ETF	161.17	161.17	161.17	161.17	100.0
2014-03-17 08:00:00	DIA	ETF	161.32	161.32	161.2	161.31	3475.0
2014-03-17 09:00:00	DIA	ETF	161.31	162.51	161.31	162.37	1228328.0

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

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