PREVIEW / etf_1hour / 2014-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-09-26.parquet
  size:    221 KB
  rows:    6,971

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-09-26 04:00:00	SPY	ETF	196.52	196.77	196.48	196.56	63814.0
2014-09-26 05:00:00	SPY	ETF	196.55	197.03	196.5	196.88	94152.0
2014-09-26 06:00:00	SPY	ETF	196.9	196.93	196.68	196.8	86742.0
2014-09-26 07:00:00	SPY	ETF	196.82	196.94	196.69	196.75	278185.0
2014-09-26 08:00:00	SPY	ETF	196.83	197.2	196.52	196.53	1628622.0
2014-09-26 09:00:00	SPY	ETF	196.52	196.95	196.14	196.73	15474173.0
2014-09-26 10:00:00	SPY	ETF	196.73	197.33	196.65	197.03	18719179.0
2014-09-26 11:00:00	SPY	ETF	197.02	197.18	196.485	196.7	11578338.0
2014-09-26 12:00:00	SPY	ETF	196.7	197.03	196.695	196.864	5721908.0
2014-09-26 13:00:00	SPY	ETF	196.86	197.32	196.85	197.27	6004424.0
2014-09-26 14:00:00	SPY	ETF	197.27	198.39	197.255	198.13	18036979.0
2014-09-26 15:00:00	SPY	ETF	198.13	198.28	197.8	197.95	15935244.0
2014-09-26 16:00:00	SPY	ETF	197.94	198.12	197.0739	198.07	7241639.0
2014-09-26 17:00:00	SPY	ETF	198.07	198.07	197.89	198.0	1904604.0
2014-09-26 18:00:00	SPY	ETF	197.99	198.0	197.85	197.88	18420.0
2014-09-26 19:00:00	SPY	ETF	197.89	197.92	197.86	197.9	16958.0
2014-09-26 04:00:00	QQQ	ETF	97.78	97.78	97.78	97.78	100.0
2014-09-26 05:00:00	QQQ	ETF	98.07	98.23	98.04	98.18	40400.0
2014-09-26 06:00:00	QQQ	ETF	98.19	98.19	97.89	98.01	82851.0
2014-09-26 07:00:00	QQQ	ETF	98.01	98.11	97.98	97.98	70500.0
2014-09-26 08:00:00	QQQ	ETF	98.11	98.23	97.98	97.98	425458.0
2014-09-26 09:00:00	QQQ	ETF	97.99	98.22	97.84	98.14	6633374.0
2014-09-26 10:00:00	QQQ	ETF	98.12	98.38	97.98	98.18	8578787.0
2014-09-26 11:00:00	QQQ	ETF	98.19	98.25	97.89	98.0	10815829.0
2014-09-26 12:00:00	QQQ	ETF	98.01	98.179	98.0	98.1072	5837280.0
2014-09-26 13:00:00	QQQ	ETF	98.11	98.31	98.11	98.3	3659507.0
2014-09-26 14:00:00	QQQ	ETF	98.3	98.96	98.295	98.84	5364099.0
2014-09-26 15:00:00	QQQ	ETF	98.84	98.92	98.68	98.81	5902660.0
2014-09-26 16:00:00	QQQ	ETF	98.8099	98.93	98.0	98.87	2785226.0
2014-09-26 17:00:00	QQQ	ETF	98.82	98.83	98.75	98.75	3228753.0
2014-09-26 18:00:00	QQQ	ETF	98.86	98.86	98.86	98.86	250.0
2014-09-26 19:00:00	QQQ	ETF	98.77	98.8	98.75	98.8	327.0
2014-09-26 04:00:00	IWM	ETF	110.28	110.4	110.28	110.36	1200.0
2014-09-26 05:00:00	IWM	ETF	110.38	110.4	110.38	110.4	200.0
2014-09-26 07:00:00	IWM	ETF	110.4	110.53	110.4	110.52	6375.0
2014-09-26 08:00:00	IWM	ETF	110.53	110.73	110.43	110.45	338337.0
2014-09-26 09:00:00	IWM	ETF	110.49	110.68	110.2	110.56	5005125.0
2014-09-26 10:00:00	IWM	ETF	110.55	110.89	110.32	110.57	4938279.0
2014-09-26 11:00:00	IWM	ETF	110.57	110.75	110.51	110.57	2129915.0
2014-09-26 12:00:00	IWM	ETF	110.57	110.68	110.42	110.48	1745997.0
2014-09-26 13:00:00	IWM	ETF	110.49	110.6399	110.45	110.61	1385992.0
2014-09-26 14:00:00	IWM	ETF	110.6	111.22	110.6	111.07	3241820.0
2014-09-26 15:00:00	IWM	ETF	111.06	111.17	110.84	111.1	4472403.0
2014-09-26 16:00:00	IWM	ETF	111.09	111.1585	110.5062	111.04	1037176.0
2014-09-26 17:00:00	IWM	ETF	111.06	111.12	110.98	111.12	895357.0
2014-09-26 08:00:00	DIA	ETF	169.93	170.0	169.6	169.62	6027.0
2014-09-26 09:00:00	DIA	ETF	169.55	169.95	169.47	169.67	880518.0
2014-09-26 10:00:00	DIA	ETF	169.66	170.14	169.6	169.91	895296.0
2014-09-26 11:00:00	DIA	ETF	169.92	170.04	169.51	169.68	511327.0
2014-09-26 12:00:00	DIA	ETF	169.69	169.95	169.68	169.83	299656.0

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

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