PREVIEW / etf_1hour / 2014-12-30

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-12-30.parquet
  size:    237 KB
  rows:    7,580

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-12-30 04:00:00	SPY	ETF	208.3	208.3	208.03	208.24	40321.0
2014-12-30 05:00:00	SPY	ETF	208.22	208.34	208.17	208.24	14605.0
2014-12-30 06:00:00	SPY	ETF	208.22	208.24	208.13	208.13	218036.0
2014-12-30 07:00:00	SPY	ETF	208.18	208.42	208.09	208.19	197358.0
2014-12-30 08:00:00	SPY	ETF	208.2	208.72	207.93	208.15	589719.0
2014-12-30 09:00:00	SPY	ETF	208.15	208.37	207.97	208.12	10323446.0
2014-12-30 10:00:00	SPY	ETF	208.13	208.22	207.77	208.14	12242147.0
2014-12-30 11:00:00	SPY	ETF	208.15	208.21	207.87	208.06	11571365.0
2014-12-30 12:00:00	SPY	ETF	208.05	208.14	207.8	207.901	5339832.0
2014-12-30 13:00:00	SPY	ETF	207.9	208.04	207.51	207.59	7473211.0
2014-12-30 14:00:00	SPY	ETF	207.595	207.92	207.54	207.79	7224303.0
2014-12-30 15:00:00	SPY	ETF	207.79	207.99	207.59	207.61	13818626.0
2014-12-30 16:00:00	SPY	ETF	207.6	207.89	207.54	207.85	3850667.0
2014-12-30 17:00:00	SPY	ETF	207.85	207.89	207.82	207.83	57495.0
2014-12-30 18:00:00	SPY	ETF	207.86	207.97	207.85	207.96	43211.0
2014-12-30 19:00:00	SPY	ETF	207.94	207.95	207.84	207.89	15925.0
2014-12-30 04:00:00	QQQ	ETF	104.85	104.86	104.85	104.86	4000.0
2014-12-30 05:00:00	QQQ	ETF	104.91	104.91	104.91	104.91	1000.0
2014-12-30 06:00:00	QQQ	ETF	104.89	104.92	104.87	104.89	6000.0
2014-12-30 07:00:00	QQQ	ETF	104.98	105.01	104.86	104.86	17900.0
2014-12-30 08:00:00	QQQ	ETF	104.9	105.02	104.72	104.75	61320.0
2014-12-30 09:00:00	QQQ	ETF	104.82	104.96	104.61	104.6922	3853693.0
2014-12-30 10:00:00	QQQ	ETF	104.7	104.7	104.5	104.67	2392516.0
2014-12-30 11:00:00	QQQ	ETF	104.67	104.69	104.5335	104.62	1573404.0
2014-12-30 12:00:00	QQQ	ETF	104.62	104.67	104.37	104.45	1233207.0
2014-12-30 13:00:00	QQQ	ETF	104.44	104.49	104.21	104.236	1293183.0
2014-12-30 14:00:00	QQQ	ETF	104.23	104.445	104.175	104.37	1404954.0
2014-12-30 15:00:00	QQQ	ETF	104.374	104.47	104.3	104.31	3037309.0
2014-12-30 16:00:00	QQQ	ETF	104.3	104.6046	104.3	104.42	755847.0
2014-12-30 17:00:00	QQQ	ETF	104.37	104.44	104.32	104.32	251216.0
2014-12-30 18:00:00	QQQ	ETF	104.43	104.5	104.43	104.49	6766.0
2014-12-30 19:00:00	QQQ	ETF	104.49	104.49	104.46	104.46	3470.0
2014-12-30 05:00:00	IWM	ETF	120.88	120.88	120.88	120.88	100.0
2014-12-30 07:00:00	IWM	ETF	120.85	121.01	120.8	120.8	10000.0
2014-12-30 08:00:00	IWM	ETF	120.85	120.88	120.67	120.75	170300.0
2014-12-30 09:00:00	IWM	ETF	120.8	121.24	120.65	120.88	2886988.0
2014-12-30 10:00:00	IWM	ETF	120.895	121.0	120.49	120.89	3195212.0
2014-12-30 11:00:00	IWM	ETF	120.89	120.93	120.63	120.84	2155486.0
2014-12-30 12:00:00	IWM	ETF	120.845	120.96	120.61	120.72	1771482.0
2014-12-30 13:00:00	IWM	ETF	120.71	120.81	120.32	120.37	2231245.0
2014-12-30 14:00:00	IWM	ETF	120.37	120.69	120.32	120.59	2370062.0
2014-12-30 15:00:00	IWM	ETF	120.59	120.72	120.34	120.35	3723526.0
2014-12-30 16:00:00	IWM	ETF	120.34	120.53	120.27	120.5	552250.0
2014-12-30 17:00:00	IWM	ETF	120.5	120.5	120.34	120.34	201648.0
2014-12-30 18:00:00	IWM	ETF	120.45	120.5	120.4	120.5	702.0
2014-12-30 19:00:00	IWM	ETF	120.45	120.49	120.37	120.49	2465.0
2014-12-30 08:00:00	DIA	ETF	179.81	179.82	179.6	179.6	3400.0
2014-12-30 09:00:00	DIA	ETF	179.64	179.87	179.55	179.71	493556.0
2014-12-30 10:00:00	DIA	ETF	179.67	179.69	179.38	179.57	553972.0
2014-12-30 11:00:00	DIA	ETF	179.58	179.62	179.43	179.54	324997.0

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

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