PREVIEW / etf_1hour / 2016-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-21.parquet
  size:    258 KB
  rows:    8,311

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-21 04:00:00	SPY	ETF	214.2	214.35	214.03	214.24	2708.0
2016-09-21 05:00:00	SPY	ETF	214.2	214.27	214.09	214.13	26544.0
2016-09-21 06:00:00	SPY	ETF	214.18	214.34	214.17	214.28	30919.0
2016-09-21 07:00:00	SPY	ETF	214.3	214.37	214.1	214.15	234620.0
2016-09-21 08:00:00	SPY	ETF	214.22	214.33	213.93	213.93	488713.0
2016-09-21 09:00:00	SPY	ETF	213.93	214.57	213.9	214.565	7347849.0
2016-09-21 10:00:00	SPY	ETF	214.57	214.705	214.2	214.21	8668803.0
2016-09-21 11:00:00	SPY	ETF	214.21	214.33	214.0	214.1399	6962535.0
2016-09-21 12:00:00	SPY	ETF	214.135	214.2	213.44	213.87	10305678.0
2016-09-21 13:00:00	SPY	ETF	213.87	214.06	213.64	213.85	7975006.0
2016-09-21 14:00:00	SPY	ETF	213.88	215.001	213.58	214.93	31319010.0
2016-09-21 15:00:00	SPY	ETF	214.93	216.03	214.73	215.79	29107978.0
2016-09-21 16:00:00	SPY	ETF	215.79	215.93	213.4772	215.88	5551976.0
2016-09-21 17:00:00	SPY	ETF	215.88	215.91	215.82	215.88	396325.0
2016-09-21 18:00:00	SPY	ETF	215.83	215.85	215.69	215.69	161653.0
2016-09-21 19:00:00	SPY	ETF	215.69	215.74	215.66	215.74	57435.0
2016-09-21 04:00:00	QQQ	ETF	117.51	117.59	117.43	117.48	2000.0
2016-09-21 05:00:00	QQQ	ETF	117.53	117.53	117.51	117.51	200.0
2016-09-21 06:00:00	QQQ	ETF	117.52	117.61	117.49	117.58	52699.0
2016-09-21 07:00:00	QQQ	ETF	117.57	117.6	117.46	117.46	49987.0
2016-09-21 08:00:00	QQQ	ETF	117.55	117.55	117.4	117.41	36127.0
2016-09-21 09:00:00	QQQ	ETF	117.36	117.62	117.36	117.61	1571534.0
2016-09-21 10:00:00	QQQ	ETF	117.6193	117.71	117.398	117.398	1989264.0
2016-09-21 11:00:00	QQQ	ETF	117.41	117.45	117.025	117.1	3437142.0
2016-09-21 12:00:00	QQQ	ETF	117.09	117.18	116.81	117.09	2395646.0
2016-09-21 13:00:00	QQQ	ETF	117.08	117.2111	116.9737	117.11	1403332.0
2016-09-21 14:00:00	QQQ	ETF	117.1	117.87	116.91	117.82	7742766.0
2016-09-21 15:00:00	QQQ	ETF	117.84	118.32	117.73	118.15	7579864.0
2016-09-21 16:00:00	QQQ	ETF	118.15	118.23	116.8771	118.21	885808.0
2016-09-21 17:00:00	QQQ	ETF	118.2	118.24	118.13	118.13	8445.0
2016-09-21 18:00:00	QQQ	ETF	118.15	118.17	118.09	118.09	37651.0
2016-09-21 19:00:00	QQQ	ETF	118.12	118.12	118.09	118.11	14426.0
2016-09-21 04:00:00	IWM	ETF	122.49	122.49	122.49	122.49	230.0
2016-09-21 05:00:00	IWM	ETF	122.67	122.67	122.67	122.67	5000.0
2016-09-21 06:00:00	IWM	ETF	122.68	122.68	122.68	122.68	200.0
2016-09-21 07:00:00	IWM	ETF	122.7	122.76	122.58	122.61	55302.0
2016-09-21 08:00:00	IWM	ETF	122.7	122.7	122.49	122.49	112907.0
2016-09-21 09:00:00	IWM	ETF	122.48	123.32	122.46	123.29	2710659.0
2016-09-21 10:00:00	IWM	ETF	123.31	123.43	122.92	122.92	2810873.0
2016-09-21 11:00:00	IWM	ETF	122.93	123.05	122.57	122.73	1668287.0
2016-09-21 12:00:00	IWM	ETF	122.72	122.75	122.1	122.59	1932067.0
2016-09-21 13:00:00	IWM	ETF	122.59	122.86	122.31	122.39	1868073.0
2016-09-21 14:00:00	IWM	ETF	122.37	123.27	122.33	123.22	6966014.0
2016-09-21 15:00:00	IWM	ETF	123.23	123.97	123.12	123.92	7885291.0
2016-09-21 16:00:00	IWM	ETF	123.92	124.11	123.9	124.04	1722223.0
2016-09-21 17:00:00	IWM	ETF	124.07	124.08	123.92	124.0	981603.0
2016-09-21 18:00:00	IWM	ETF	123.98	123.98	123.95	123.95	868.0
2016-09-21 19:00:00	IWM	ETF	123.95	123.95	123.87	123.95	1530.0
2016-09-21 05:00:00	DIA	ETF	181.56	181.56	181.56	181.56	300.0
2016-09-21 06:00:00	DIA	ETF	181.7	181.7	181.7	181.7	100.0

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

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