PREVIEW / etf_1hour / 2016-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-05-02.parquet
  size:    251 KB
  rows:    8,061

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
2016-05-02 04:00:00	SPY	ETF	206.46	206.73	206.46	206.51	2205.0
2016-05-02 05:00:00	SPY	ETF	206.48	206.73	206.48	206.53	6690.0
2016-05-02 06:00:00	SPY	ETF	206.56	206.65	206.49	206.65	43905.0
2016-05-02 07:00:00	SPY	ETF	206.67	207.04	206.67	206.88	428257.0
2016-05-02 08:00:00	SPY	ETF	206.88	207.07	206.58	206.9	389458.0
2016-05-02 09:00:00	SPY	ETF	206.91	207.08	206.41	206.64	7517968.0
2016-05-02 10:00:00	SPY	ETF	206.63	207.32	206.46	206.8101	12659782.0
2016-05-02 11:00:00	SPY	ETF	206.81	207.37	206.8	206.91	7801202.0
2016-05-02 12:00:00	SPY	ETF	206.91	207.32	206.7789	207.295	5305373.0
2016-05-02 13:00:00	SPY	ETF	207.3	207.75	207.25	207.57	6009608.0
2016-05-02 14:00:00	SPY	ETF	207.575	207.84	207.565	207.75	5407509.0
2016-05-02 15:00:00	SPY	ETF	207.76	208.18	207.735	207.97	11796418.0
2016-05-02 16:00:00	SPY	ETF	207.97	208.07	207.82	208.01	2505951.0
2016-05-02 17:00:00	SPY	ETF	208.0	208.07	207.98	207.99	112234.0
2016-05-02 18:00:00	SPY	ETF	207.98	208.04	207.86	207.96	114995.0
2016-05-02 19:00:00	SPY	ETF	207.99	208.0	207.85	207.85	60319.0
2016-05-02 04:00:00	QQQ	ETF	105.79	105.79	105.79	105.79	1050.0
2016-05-02 05:00:00	QQQ	ETF	105.69	105.69	105.69	105.69	100.0
2016-05-02 06:00:00	QQQ	ETF	105.72	105.81	105.72	105.81	1149.0
2016-05-02 07:00:00	QQQ	ETF	105.84	106.02	105.84	105.93	138986.0
2016-05-02 08:00:00	QQQ	ETF	105.91	105.99	105.89	105.95	17184.0
2016-05-02 09:00:00	QQQ	ETF	106.0	106.02	105.601	105.68	2997277.0
2016-05-02 10:00:00	QQQ	ETF	105.68	106.12	105.5525	105.67	4587449.0
2016-05-02 11:00:00	QQQ	ETF	105.67	106.01	105.65	105.7945	2390629.0
2016-05-02 12:00:00	QQQ	ETF	105.8	106.12	105.7	106.04	1612151.0
2016-05-02 13:00:00	QQQ	ETF	106.04	106.405	105.96	106.28	1567513.0
2016-05-02 14:00:00	QQQ	ETF	106.28	106.65	106.26	106.6254	1819134.0
2016-05-02 15:00:00	QQQ	ETF	106.63	106.87	106.605	106.71	4439286.0
2016-05-02 16:00:00	QQQ	ETF	106.73	106.74	106.0001	106.73	671552.0
2016-05-02 17:00:00	QQQ	ETF	106.71	106.77	106.7	106.77	1958.0
2016-05-02 18:00:00	QQQ	ETF	106.72	106.73	106.68	106.7	1999.0
2016-05-02 19:00:00	QQQ	ETF	106.73	106.73	106.63	106.66	6508.0
2016-05-02 07:00:00	IWM	ETF	112.84	113.0	112.82	112.97	58501.0
2016-05-02 08:00:00	IWM	ETF	112.92	112.98	112.36	112.88	37340.0
2016-05-02 09:00:00	IWM	ETF	112.89	112.97	112.175	112.36	2219178.0
2016-05-02 10:00:00	IWM	ETF	112.36	112.95	112.28	112.48	3359760.0
2016-05-02 11:00:00	IWM	ETF	112.48	113.01	112.44	112.62	2137209.0
2016-05-02 12:00:00	IWM	ETF	112.625	112.85	112.5275	112.81	1511660.0
2016-05-02 13:00:00	IWM	ETF	112.82	113.28	112.79	113.11	1715109.0
2016-05-02 14:00:00	IWM	ETF	113.12	113.28	112.97	113.11	1975419.0
2016-05-02 15:00:00	IWM	ETF	113.12	113.5	113.09	113.4989	4236550.0
2016-05-02 16:00:00	IWM	ETF	113.48	113.51	112.484	113.47	766557.0
2016-05-02 17:00:00	IWM	ETF	113.49	113.55	113.47	113.51	40376.0
2016-05-02 18:00:00	IWM	ETF	113.48	113.48	113.46	113.46	1464.0
2016-05-02 08:00:00	DIA	ETF	177.81	178.08	177.81	178.05	1875.0
2016-05-02 09:00:00	DIA	ETF	177.99	178.1	177.51	177.69	303901.0
2016-05-02 10:00:00	DIA	ETF	177.7	178.34	177.58	178.0232	405282.0
2016-05-02 11:00:00	DIA	ETF	178.04	178.49	178.01	178.04	237443.0
2016-05-02 12:00:00	DIA	ETF	178.0	178.36	177.94	178.34	134320.0
2016-05-02 13:00:00	DIA	ETF	178.34	178.548	178.27	178.41	207763.0

> showing 50 of 8,061 rows — these rows as CSV

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