PREVIEW / etf_1hour / 2016-10-24

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-10-24.parquet
  size:    254 KB
  rows:    8,239

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-10-24 04:00:00	SPY	ETF	214.91	215.12	214.88	214.9	9974.0
2016-10-24 05:00:00	SPY	ETF	214.92	214.92	214.84	214.84	4002.0
2016-10-24 06:00:00	SPY	ETF	214.89	214.94	214.81	214.81	40510.0
2016-10-24 07:00:00	SPY	ETF	214.8	214.86	214.75	214.84	160536.0
2016-10-24 08:00:00	SPY	ETF	214.82	214.94	214.131	214.93	569096.0
2016-10-24 09:00:00	SPY	ETF	214.92	215.32	214.84	215.197	8248701.0
2016-10-24 10:00:00	SPY	ETF	215.2	215.24	214.7	215.0	9019965.0
2016-10-24 11:00:00	SPY	ETF	214.99	215.14	214.78	214.79	5299294.0
2016-10-24 12:00:00	SPY	ETF	214.79	214.88	214.48	214.695	5439924.0
2016-10-24 13:00:00	SPY	ETF	214.69	214.89	214.66	214.79	3589506.0
2016-10-24 14:00:00	SPY	ETF	214.79	214.94	214.7536	214.91	5296343.0
2016-10-24 15:00:00	SPY	ETF	214.905	215.04	214.75	214.85	13200526.0
2016-10-24 16:00:00	SPY	ETF	214.86	215.0	214.75	214.96	7660455.0
2016-10-24 17:00:00	SPY	ETF	214.93	214.97	214.89	214.9	137805.0
2016-10-24 18:00:00	SPY	ETF	214.9	214.97	214.82	214.85	71092.0
2016-10-24 19:00:00	SPY	ETF	214.86	214.95	214.85	214.9	18958.0
2016-10-24 20:00:00	SPY	ETF	214.89	214.938	214.89	214.938	1100000.0
2016-10-24 04:00:00	QQQ	ETF	118.8	118.8	118.8	118.8	100.0
2016-10-24 05:00:00	QQQ	ETF	118.8	118.8	118.8	118.8	200.0
2016-10-24 06:00:00	QQQ	ETF	118.8	118.8	118.8	118.8	166.0
2016-10-24 07:00:00	QQQ	ETF	118.81	118.84	118.78	118.81	37010.0
2016-10-24 08:00:00	QQQ	ETF	118.8	118.92	118.77	118.92	124552.0
2016-10-24 09:00:00	QQQ	ETF	118.92	119.25	118.87	119.24	2204606.0
2016-10-24 10:00:00	QQQ	ETF	119.24	119.39	119.09	119.33	2576074.0
2016-10-24 11:00:00	QQQ	ETF	119.32	119.45	119.29	119.3	1423276.0
2016-10-24 12:00:00	QQQ	ETF	119.3	119.335	119.22	119.2858	1247635.0
2016-10-24 13:00:00	QQQ	ETF	119.28	119.49	119.2799	119.44	763991.0
2016-10-24 14:00:00	QQQ	ETF	119.4479	119.47	119.391	119.43	1362314.0
2016-10-24 15:00:00	QQQ	ETF	119.435	119.65	119.36	119.56	4517476.0
2016-10-24 16:00:00	QQQ	ETF	119.56	119.66	119.5	119.66	766043.0
2016-10-24 17:00:00	QQQ	ETF	119.6	119.65	119.55	119.65	550190.0
2016-10-24 18:00:00	QQQ	ETF	119.62	119.62	119.59	119.59	4454.0
2016-10-24 19:00:00	QQQ	ETF	119.61	119.63	119.59	119.61	3290.0
2016-10-24 04:00:00	IWM	ETF	121.88	122.09	121.88	122.09	1260.0
2016-10-24 05:00:00	IWM	ETF	122.11	122.11	122.11	122.11	510.0
2016-10-24 07:00:00	IWM	ETF	121.96	122.05	121.94	122.02	9094.0
2016-10-24 08:00:00	IWM	ETF	122.03	122.06	121.87	122.06	47339.0
2016-10-24 09:00:00	IWM	ETF	122.06	122.61	121.97	122.52	3778339.0
2016-10-24 10:00:00	IWM	ETF	122.53	122.58	121.99	122.18	2294050.0
2016-10-24 11:00:00	IWM	ETF	122.18	122.29	121.71	121.77	1478482.0
2016-10-24 12:00:00	IWM	ETF	121.77	121.83	121.4499	121.615	1334159.0
2016-10-24 13:00:00	IWM	ETF	121.605	121.8	121.52	121.69	988552.0
2016-10-24 14:00:00	IWM	ETF	121.68	121.91	121.64	121.81	779218.0
2016-10-24 15:00:00	IWM	ETF	121.81	121.95	121.685	121.85	2519359.0
2016-10-24 16:00:00	IWM	ETF	121.84	121.93	121.75	121.92	565226.0
2016-10-24 17:00:00	IWM	ETF	121.84	121.84	121.84	121.84	160500.0
2016-10-24 18:00:00	IWM	ETF	121.85	121.85	121.77	121.77	1434.0
2016-10-24 07:00:00	DIA	ETF	182.0	182.0	182.0	182.0	100.0
2016-10-24 08:00:00	DIA	ETF	182.0	182.11	182.0	182.11	2100.0
2016-10-24 09:00:00	DIA	ETF	182.16	182.5	182.16	182.32	509609.0

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

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