PREVIEW / etf_1hour / 2014-07-21

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-21.parquet
  size:    225 KB
  rows:    7,358

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-07-21 04:00:00	SPY	ETF	197.51	197.51	197.13	197.21	45548.0
2014-07-21 05:00:00	SPY	ETF	197.25	197.49	197.25	197.41	12221.0
2014-07-21 06:00:00	SPY	ETF	197.32	197.4	197.13	197.13	101216.0
2014-07-21 07:00:00	SPY	ETF	197.19	197.31	197.14	197.22	184234.0
2014-07-21 08:00:00	SPY	ETF	197.22	197.61	197.17	197.23	407637.0
2014-07-21 09:00:00	SPY	ETF	197.22	197.29	196.84	197.1974	10156452.0
2014-07-21 10:00:00	SPY	ETF	197.2	197.221	196.43	196.56	13519366.0
2014-07-21 11:00:00	SPY	ETF	196.55	197.03	196.46	197.0	9419016.0
2014-07-21 12:00:00	SPY	ETF	197.01	197.04	196.83	196.915	6818418.0
2014-07-21 13:00:00	SPY	ETF	196.91	197.45	196.88	197.38	5332039.0
2014-07-21 14:00:00	SPY	ETF	197.37	197.475	197.2	197.4	4830019.0
2014-07-21 15:00:00	SPY	ETF	197.4	197.5	197.23	197.3	10849578.0
2014-07-21 16:00:00	SPY	ETF	197.32	197.34	197.0226	197.09	4811449.0
2014-07-21 17:00:00	SPY	ETF	197.08	197.12	197.05	197.08	126745.0
2014-07-21 18:00:00	SPY	ETF	197.08	197.13	197.06	197.09	67598.0
2014-07-21 19:00:00	SPY	ETF	197.09	197.12	197.08	197.08	52012.0
2014-07-21 04:00:00	QQQ	ETF	95.87	96.0	95.76	95.91	16600.0
2014-07-21 06:00:00	QQQ	ETF	95.96	96.0	95.9	95.9	6240.0
2014-07-21 07:00:00	QQQ	ETF	95.92	95.98	95.9	95.95	39333.0
2014-07-21 08:00:00	QQQ	ETF	95.95	96.0	95.91	95.93	72156.0
2014-07-21 09:00:00	QQQ	ETF	95.94	96.04	95.745	95.92	3952028.0
2014-07-21 10:00:00	QQQ	ETF	95.92	95.939	95.56	95.6	4419973.0
2014-07-21 11:00:00	QQQ	ETF	95.6	95.88	95.55	95.855	3083689.0
2014-07-21 12:00:00	QQQ	ETF	95.86	95.88	95.74	95.85	1635467.0
2014-07-21 13:00:00	QQQ	ETF	95.85	96.16	95.825	96.11	2017850.0
2014-07-21 14:00:00	QQQ	ETF	96.105	96.15	95.97	96.0801	1919631.0
2014-07-21 15:00:00	QQQ	ETF	96.08	96.14	95.94	95.98	4439423.0
2014-07-21 16:00:00	QQQ	ETF	95.99	96.0439	95.8907	95.92	6270875.0
2014-07-21 17:00:00	QQQ	ETF	95.88	95.93	95.87	95.89	13799.0
2014-07-21 18:00:00	QQQ	ETF	95.89	95.92	95.89	95.92	6701.0
2014-07-21 19:00:00	QQQ	ETF	95.93	95.93	95.91	95.93	2564.0
2014-07-21 04:00:00	IWM	ETF	114.19	114.19	113.7	113.7	1152.0
2014-07-21 07:00:00	IWM	ETF	113.8	113.85	113.75	113.75	22300.0
2014-07-21 08:00:00	IWM	ETF	113.8	113.85	113.67	113.69	98925.0
2014-07-21 09:00:00	IWM	ETF	113.68	113.96	113.14	113.67	5144356.0
2014-07-21 10:00:00	IWM	ETF	113.68	113.77	113.01	113.16	4916822.0
2014-07-21 11:00:00	IWM	ETF	113.15	113.6	113.03	113.46	3050953.0
2014-07-21 12:00:00	IWM	ETF	113.47	113.51	113.23	113.28	1478951.0
2014-07-21 13:00:00	IWM	ETF	113.28	113.97	113.25	113.86	3140906.0
2014-07-21 14:00:00	IWM	ETF	113.86	113.99	113.63	113.79	1869023.0
2014-07-21 15:00:00	IWM	ETF	113.8	113.97	113.72	113.77	4613585.0
2014-07-21 16:00:00	IWM	ETF	113.77	114.2911	113.66	113.66	1049122.0
2014-07-21 17:00:00	IWM	ETF	113.66	114.21	113.58	114.21	105193.0
2014-07-21 19:00:00	IWM	ETF	113.59	113.59	113.3	113.3	1980.0
2014-07-21 06:00:00	DIA	ETF	170.26	170.26	170.21	170.21	1545.0
2014-07-21 07:00:00	DIA	ETF	170.2	170.2	170.17	170.17	6200.0
2014-07-21 08:00:00	DIA	ETF	170.19	170.39	170.18	170.28	3450.0
2014-07-21 09:00:00	DIA	ETF	170.17	170.29	169.78	170.0	661479.0
2014-07-21 10:00:00	DIA	ETF	170.02	170.02	169.36	169.48	591714.0
2014-07-21 11:00:00	DIA	ETF	169.48	170.01	169.4	169.98	338430.0

> showing 50 of 7,358 rows — these rows as CSV

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