PREVIEW / etf_1hour / 2016-05-11

all etf 1-hour files

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

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-11 04:00:00	SPY	ETF	207.77	207.83	207.46	207.83	25923.0
2016-05-11 05:00:00	SPY	ETF	207.82	207.87	207.71	207.85	11372.0
2016-05-11 06:00:00	SPY	ETF	207.85	207.85	207.66	207.8	17986.0
2016-05-11 07:00:00	SPY	ETF	207.8	207.99	207.77	207.94	328973.0
2016-05-11 08:00:00	SPY	ETF	207.71	208.46	207.71	208.05	654056.0
2016-05-11 09:00:00	SPY	ETF	208.06	208.54	207.63	207.71	7203400.0
2016-05-11 10:00:00	SPY	ETF	207.7	208.33	207.56	207.945	13867822.0
2016-05-11 11:00:00	SPY	ETF	207.945	207.96	207.39	207.5735	8592357.0
2016-05-11 12:00:00	SPY	ETF	207.57	207.77	207.43	207.54	4519523.0
2016-05-11 13:00:00	SPY	ETF	207.541	207.63	207.19	207.2	7159943.0
2016-05-11 14:00:00	SPY	ETF	207.19	207.22	206.67	206.749	9467513.0
2016-05-11 15:00:00	SPY	ETF	206.75	206.9601	206.5	206.56	22472354.0
2016-05-11 16:00:00	SPY	ETF	206.56	208.5005	206.27	206.44	5226241.0
2016-05-11 17:00:00	SPY	ETF	206.44	208.5005	206.35	206.42	595440.0
2016-05-11 18:00:00	SPY	ETF	206.39	206.54	206.35	206.5	58203.0
2016-05-11 19:00:00	SPY	ETF	206.52	206.58	206.48	206.49	76717.0
2016-05-11 04:00:00	QQQ	ETF	106.91	106.92	106.91	106.92	567.0
2016-05-11 05:00:00	QQQ	ETF	106.95	106.98	106.95	106.96	11948.0
2016-05-11 06:00:00	QQQ	ETF	106.98	106.98	106.98	106.98	1000.0
2016-05-11 07:00:00	QQQ	ETF	107.04	107.06	107.0	107.0	16595.0
2016-05-11 08:00:00	QQQ	ETF	107.07	107.18	107.04	107.18	125264.0
2016-05-11 09:00:00	QQQ	ETF	107.16	107.23	106.9799	107.19	2018716.0
2016-05-11 10:00:00	QQQ	ETF	107.19	107.49	107.11	107.13	3483471.0
2016-05-11 11:00:00	QQQ	ETF	107.13	107.14	106.83	106.951	2621313.0
2016-05-11 12:00:00	QQQ	ETF	106.95	107.105	106.8702	106.9895	1090309.0
2016-05-11 13:00:00	QQQ	ETF	106.99	107.01	106.7	106.71	1421726.0
2016-05-11 14:00:00	QQQ	ETF	106.7	106.73	106.41	106.51	1994929.0
2016-05-11 15:00:00	QQQ	ETF	106.52	106.66	106.33	106.37	4212649.0
2016-05-11 16:00:00	QQQ	ETF	106.37	106.4415	106.21	106.26	549897.0
2016-05-11 17:00:00	QQQ	ETF	106.28	106.34	106.2	106.21	15548.0
2016-05-11 18:00:00	QQQ	ETF	106.25	106.31	106.16	106.28	23288.0
2016-05-11 19:00:00	QQQ	ETF	106.32	106.32	106.27	106.28	11992.0
2016-05-11 04:00:00	IWM	ETF	111.87	111.87	111.87	111.87	500.0
2016-05-11 07:00:00	IWM	ETF	112.12	112.12	112.1	112.12	500.0
2016-05-11 08:00:00	IWM	ETF	112.12	112.35	112.12	112.35	95639.0
2016-05-11 09:00:00	IWM	ETF	112.2	112.21	111.66	111.71	2071452.0
2016-05-11 10:00:00	IWM	ETF	111.7	112.27	111.57	112.02	3104472.0
2016-05-11 11:00:00	IWM	ETF	112.02	112.06	111.54	111.78	2141509.0
2016-05-11 12:00:00	IWM	ETF	111.77	111.9	111.66	111.75	851643.0
2016-05-11 13:00:00	IWM	ETF	111.76	111.87	111.48	111.52	1154133.0
2016-05-11 14:00:00	IWM	ETF	111.52	111.54	111.15	111.22	2081973.0
2016-05-11 15:00:00	IWM	ETF	111.22	111.4	110.87	110.94	4928571.0
2016-05-11 16:00:00	IWM	ETF	110.9	110.98	110.71	110.76	3123369.0
2016-05-11 17:00:00	IWM	ETF	110.78	110.79	110.69	110.71	26293.0
2016-05-11 18:00:00	IWM	ETF	110.71	110.83	110.7	110.75	7000.0
2016-05-11 19:00:00	IWM	ETF	110.8	110.82	110.76	110.77	3260.0
2016-05-11 04:00:00	DIA	ETF	178.5	178.66	178.5	178.64	16500.0
2016-05-11 05:00:00	DIA	ETF	178.74	178.74	178.68	178.68	17500.0
2016-05-11 06:00:00	DIA	ETF	178.78	178.78	178.78	178.78	1000.0
2016-05-11 07:00:00	DIA	ETF	178.78	178.78	178.75	178.76	10200.0

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

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