PREVIEW / etf_1hour / 2016-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-23.parquet
  size:    252 KB
  rows:    8,160

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-09-23 04:00:00	SPY	ETF	216.91	216.91	216.65	216.7	44147.0
2016-09-23 05:00:00	SPY	ETF	216.72	216.92	216.7	216.82	26034.0
2016-09-23 06:00:00	SPY	ETF	216.79	216.9	216.66	216.66	26702.0
2016-09-23 07:00:00	SPY	ETF	216.73	216.8	216.61	216.69	221777.0
2016-09-23 08:00:00	SPY	ETF	216.7	216.92	216.64	216.92	433117.0
2016-09-23 09:00:00	SPY	ETF	216.91	216.97	216.45	216.58	7989911.0
2016-09-23 10:00:00	SPY	ETF	216.575	216.79	216.46	216.69	7170855.0
2016-09-23 11:00:00	SPY	ETF	216.69	216.8	216.41	216.48	5208023.0
2016-09-23 12:00:00	SPY	ETF	216.47	216.63	216.42	216.51	5661717.0
2016-09-23 13:00:00	SPY	ETF	216.5	216.515	215.88	215.94	9357455.0
2016-09-23 14:00:00	SPY	ETF	215.94	216.325	215.9	216.29	10123147.0
2016-09-23 15:00:00	SPY	ETF	216.28	216.57	215.97	215.98	17190885.0
2016-09-23 16:00:00	SPY	ETF	216.0	216.22	215.965	216.01	8231397.0
2016-09-23 17:00:00	SPY	ETF	215.99	216.04	215.87	215.89	882505.0
2016-09-23 18:00:00	SPY	ETF	215.9	215.95	215.85	215.92	40191.0
2016-09-23 19:00:00	SPY	ETF	215.9	215.93	215.84	215.84	38978.0
2016-09-23 04:00:00	QQQ	ETF	118.97	118.97	118.91	118.91	7450.0
2016-09-23 05:00:00	QQQ	ETF	118.89	119.01	118.89	118.95	2563.0
2016-09-23 06:00:00	QQQ	ETF	118.95	118.95	118.89	118.91	12050.0
2016-09-23 07:00:00	QQQ	ETF	118.9	118.93	118.8	118.85	192956.0
2016-09-23 08:00:00	QQQ	ETF	118.86	118.98	118.83	118.96	50403.0
2016-09-23 09:00:00	QQQ	ETF	118.95	119.01	118.68	118.69	2881190.0
2016-09-23 10:00:00	QQQ	ETF	118.69	118.76	118.525	118.67	1864717.0
2016-09-23 11:00:00	QQQ	ETF	118.6763	118.84	118.64	118.72	1584334.0
2016-09-23 12:00:00	QQQ	ETF	118.715	118.85	118.69	118.78	1360352.0
2016-09-23 13:00:00	QQQ	ETF	118.785	118.79	118.16	118.2593	2730473.0
2016-09-23 14:00:00	QQQ	ETF	118.2562	118.51	118.19	118.46	2702927.0
2016-09-23 15:00:00	QQQ	ETF	118.46	118.625	118.3	118.31	2827233.0
2016-09-23 16:00:00	QQQ	ETF	118.33	118.4	118.3	118.36	647515.0
2016-09-23 17:00:00	QQQ	ETF	118.32	118.37	118.28	118.29	9500.0
2016-09-23 18:00:00	QQQ	ETF	118.3	118.3	118.29	118.29	1210.0
2016-09-23 19:00:00	QQQ	ETF	118.3	118.3	118.2	118.25	7506.0
2016-09-23 05:00:00	IWM	ETF	125.57	125.57	125.57	125.57	130.0
2016-09-23 06:00:00	IWM	ETF	125.56	125.65	125.55	125.61	6946.0
2016-09-23 07:00:00	IWM	ETF	125.58	125.58	125.47	125.56	165389.0
2016-09-23 08:00:00	IWM	ETF	125.57	125.66	125.54	125.65	235829.0
2016-09-23 09:00:00	IWM	ETF	125.7	125.882	125.19	125.39	2522125.0
2016-09-23 10:00:00	IWM	ETF	125.38	125.51	125.12	125.44	2519702.0
2016-09-23 11:00:00	IWM	ETF	125.44	125.6	125.17	125.22	1652617.0
2016-09-23 12:00:00	IWM	ETF	125.21	125.3	125.08	125.12	1324583.0
2016-09-23 13:00:00	IWM	ETF	125.12	125.17	124.89	124.93	2306830.0
2016-09-23 14:00:00	IWM	ETF	124.92	125.23	124.91	125.13	1589343.0
2016-09-23 15:00:00	IWM	ETF	125.12	125.32	124.82	124.85	4636121.0
2016-09-23 16:00:00	IWM	ETF	124.81	124.97	124.74	124.74	1522189.0
2016-09-23 17:00:00	IWM	ETF	124.81	124.81	124.66	124.81	1210714.0
2016-09-23 18:00:00	IWM	ETF	124.74	124.74	124.74	124.74	300.0
2016-09-23 19:00:00	IWM	ETF	124.73	124.8716	124.7	124.8656	1530650.0
2016-09-23 08:00:00	DIA	ETF	183.45	183.47	183.45	183.47	4300.0
2016-09-23 09:00:00	DIA	ETF	183.58	183.58	183.19	183.27	166033.0
2016-09-23 10:00:00	DIA	ETF	183.29	183.3001	183.09	183.16	134711.0

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

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