PREVIEW / etf_1hour / 2016-09-30

all etf 1-hour files

  file:    by_date/etf_1hour/2016/2016-09-30.parquet
  size:    259 KB
  rows:    8,337

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-30 04:00:00	SPY	ETF	214.3	214.8	214.14	214.8	65525.0
2016-09-30 05:00:00	SPY	ETF	214.83	215.07	214.69	215.01	14776.0
2016-09-30 06:00:00	SPY	ETF	214.86	215.25	214.65	215.12	230106.0
2016-09-30 07:00:00	SPY	ETF	215.15	215.21	214.91	215.04	522422.0
2016-09-30 08:00:00	SPY	ETF	214.95	215.54	213.93	215.38	1236881.0
2016-09-30 09:00:00	SPY	ETF	215.39	216.13	213.93	215.48	13002536.0
2016-09-30 10:00:00	SPY	ETF	215.49	216.02	215.41	216.0	11917295.0
2016-09-30 11:00:00	SPY	ETF	216.0	216.74	215.99	216.42	14800834.0
2016-09-30 12:00:00	SPY	ETF	216.42	216.75	216.345	216.5	6613026.0
2016-09-30 13:00:00	SPY	ETF	216.5	216.7	216.32	216.67	5024542.0
2016-09-30 14:00:00	SPY	ETF	216.68	216.94	216.62	216.87	10214448.0
2016-09-30 15:00:00	SPY	ETF	216.87	217.12	216.29	216.36	31148842.0
2016-09-30 16:00:00	SPY	ETF	216.34	216.59	214.65	216.04	15839734.0
2016-09-30 17:00:00	SPY	ETF	216.14	216.3	215.99	216.16	634341.0
2016-09-30 18:00:00	SPY	ETF	216.16	216.92	216.16	216.51	1727851.0
2016-09-30 19:00:00	SPY	ETF	216.3	216.55	216.3	216.5	201017.0
2016-09-30 04:00:00	QQQ	ETF	117.67	117.79	117.64	117.79	3050.0
2016-09-30 05:00:00	QQQ	ETF	117.78	117.92	117.75	117.92	3599.0
2016-09-30 06:00:00	QQQ	ETF	117.75	118.03	117.75	118.03	3896.0
2016-09-30 07:00:00	QQQ	ETF	118.0	118.03	117.9	117.96	16000.0
2016-09-30 08:00:00	QQQ	ETF	118.03	118.19	118.03	118.14	70109.0
2016-09-30 09:00:00	QQQ	ETF	118.12	118.43	118.06	118.199	1922477.0
2016-09-30 10:00:00	QQQ	ETF	118.2	118.54	118.03	118.52	1813931.0
2016-09-30 11:00:00	QQQ	ETF	118.51	118.84	118.5	118.69	3440375.0
2016-09-30 12:00:00	QQQ	ETF	118.69	118.94	118.68	118.818	3309215.0
2016-09-30 13:00:00	QQQ	ETF	118.81	118.94	118.7201	118.91	1856210.0
2016-09-30 14:00:00	QQQ	ETF	118.91	119.02	118.88	118.98	1874033.0
2016-09-30 15:00:00	QQQ	ETF	118.975	119.07	118.68	118.69	5393229.0
2016-09-30 16:00:00	QQQ	ETF	118.68	118.78	118.56	118.61	1203622.0
2016-09-30 17:00:00	QQQ	ETF	118.62	118.72	118.58	118.58	89219.0
2016-09-30 18:00:00	QQQ	ETF	118.61	118.86	118.61	118.79	112758.0
2016-09-30 19:00:00	QQQ	ETF	118.77	118.78	118.73	118.75	5209.0
2016-09-30 04:00:00	IWM	ETF	122.82	122.82	122.55	122.55	700.0
2016-09-30 05:00:00	IWM	ETF	122.95	122.95	122.95	122.95	100.0
2016-09-30 06:00:00	IWM	ETF	122.9	122.9	122.86	122.86	200.0
2016-09-30 07:00:00	IWM	ETF	123.11	123.11	122.9	123.02	31878.0
2016-09-30 08:00:00	IWM	ETF	122.9	123.3	122.9	123.22	48598.0
2016-09-30 09:00:00	IWM	ETF	123.17	123.73	122.86	123.04	2459648.0
2016-09-30 10:00:00	IWM	ETF	123.045	123.69	123.04	123.67	2698220.0
2016-09-30 11:00:00	IWM	ETF	123.67	124.43	123.67	124.164	4908879.0
2016-09-30 12:00:00	IWM	ETF	124.16	124.41	124.08	124.2	1496822.0
2016-09-30 13:00:00	IWM	ETF	124.2	124.33	124.01	124.3	1785860.0
2016-09-30 14:00:00	IWM	ETF	124.3073	124.55	124.26	124.4448	1638179.0
2016-09-30 15:00:00	IWM	ETF	124.445	124.78	124.18	124.2	7398285.0
2016-09-30 16:00:00	IWM	ETF	124.21	124.24	123.93	123.95	2437563.0
2016-09-30 17:00:00	IWM	ETF	123.99	124.21	123.97	123.99	733573.0
2016-09-30 18:00:00	IWM	ETF	124.21	124.3	124.03	124.3	311169.0
2016-09-30 19:00:00	IWM	ETF	124.21	124.21	124.17	124.17	3699.0
2016-09-30 05:00:00	DIA	ETF	181.38	181.38	181.38	181.38	100.0
2016-09-30 06:00:00	DIA	ETF	181.33	181.33	181.33	181.33	200.0

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

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