PREVIEW / etf_30min / 2017-04-26

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-26.parquet
  size:    433 KB
  rows:    14,824

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
2017-04-26 04:00:00	SPY	ETF	238.47	238.47	238.38	238.38	5850.0
2017-04-26 04:30:00	SPY	ETF	238.4	238.49	238.4	238.49	1800.0
2017-04-26 05:00:00	SPY	ETF	238.46	238.49	238.43	238.49	3100.0
2017-04-26 05:30:00	SPY	ETF	238.49	238.65	238.48	238.65	10165.0
2017-04-26 06:00:00	SPY	ETF	238.67	238.72	238.56	238.56	3500.0
2017-04-26 06:30:00	SPY	ETF	238.58	238.58	238.53	238.53	3647.0
2017-04-26 07:00:00	SPY	ETF	238.41	238.45	238.32	238.32	62380.0
2017-04-26 07:30:00	SPY	ETF	238.32	238.48	238.3	238.35	83014.0
2017-04-26 08:00:00	SPY	ETF	238.43	238.48	238.29	238.38	75148.0
2017-04-26 08:30:00	SPY	ETF	238.38	238.71	238.38	238.63	236407.0
2017-04-26 09:00:00	SPY	ETF	238.63	238.64	238.52	238.535	584471.0
2017-04-26 09:30:00	SPY	ETF	238.51	238.84	238.5	238.7808	6655038.0
2017-04-26 10:00:00	SPY	ETF	238.78	238.91	238.68	238.87	3999657.0
2017-04-26 10:30:00	SPY	ETF	238.88	239.1	238.85	239.05	4087632.0
2017-04-26 11:00:00	SPY	ETF	239.05	239.53	238.91	239.47	4702333.0
2017-04-26 11:30:00	SPY	ETF	239.48	239.48	238.7	238.91	6576875.0
2017-04-26 12:00:00	SPY	ETF	238.91	239.24	238.8	239.02	2930913.0
2017-04-26 12:30:00	SPY	ETF	239.0211	239.36	238.98	239.33	2988365.0
2017-04-26 13:00:00	SPY	ETF	239.33	239.42	239.19	239.2	2625373.0
2017-04-26 13:30:00	SPY	ETF	239.21	239.5	238.83	238.99	6047274.0
2017-04-26 14:00:00	SPY	ETF	239.0	239.19	238.79	239.0	4408878.0
2017-04-26 14:30:00	SPY	ETF	239.0	239.23	238.98	239.06	4900772.0
2017-04-26 15:00:00	SPY	ETF	239.065	239.28	238.98	239.08	3512319.0
2017-04-26 15:30:00	SPY	ETF	239.07	239.09	238.35	238.44	15028327.0
2017-04-26 16:00:00	SPY	ETF	238.45	238.5	238.27	238.31	11408995.0
2017-04-26 16:30:00	SPY	ETF	238.33	238.4455	238.25	238.25	1057907.0
2017-04-26 17:00:00	SPY	ETF	238.25	238.3	238.18	238.29	113211.0
2017-04-26 17:30:00	SPY	ETF	238.29	238.4	238.26	238.26	162270.0
2017-04-26 18:00:00	SPY	ETF	238.26	238.37	238.24	238.27	192849.0
2017-04-26 18:30:00	SPY	ETF	238.27	239.3701	238.27	238.37	23864.0
2017-04-26 19:00:00	SPY	ETF	238.37	238.54	238.37	238.49	85671.0
2017-04-26 19:30:00	SPY	ETF	238.48	238.51	238.44	238.44	30133.0
2017-04-26 04:00:00	QQQ	ETF	135.18	135.2	135.16	135.16	940.0
2017-04-26 04:30:00	QQQ	ETF	135.23	135.23	135.23	135.23	400.0
2017-04-26 05:00:00	QQQ	ETF	135.21	135.21	135.21	135.21	1430.0
2017-04-26 06:00:00	QQQ	ETF	135.28	135.28	135.28	135.28	200.0
2017-04-26 07:00:00	QQQ	ETF	135.2	135.2	135.2	135.2	500.0
2017-04-26 07:30:00	QQQ	ETF	135.11	135.2	135.11	135.15	10895.0
2017-04-26 08:00:00	QQQ	ETF	135.19	135.21	135.15	135.17	43906.0
2017-04-26 08:30:00	QQQ	ETF	135.19	135.25	135.19	135.25	22547.0
2017-04-26 09:00:00	QQQ	ETF	135.25	135.25	135.18	135.18	44245.0
2017-04-26 09:30:00	QQQ	ETF	135.17	135.51	135.07	135.17	4087843.0
2017-04-26 10:00:00	QQQ	ETF	135.16	135.23	135.05	135.1258	1021030.0
2017-04-26 10:30:00	QQQ	ETF	135.14	135.18	135.02	135.17	1175649.0
2017-04-26 11:00:00	QQQ	ETF	135.165	135.35	135.07	135.29	1420086.0
2017-04-26 11:30:00	QQQ	ETF	135.29	135.34	134.92	135.01	3522701.0
2017-04-26 12:00:00	QQQ	ETF	135.01	135.24	134.96	135.0999	850561.0
2017-04-26 12:30:00	QQQ	ETF	135.1	135.225	135.02	135.2	629659.0
2017-04-26 13:00:00	QQQ	ETF	135.2	135.27	135.15	135.17	560293.0
2017-04-26 13:30:00	QQQ	ETF	135.17	135.34	134.99	135.06	1136696.0

> showing 50 of 14,824 rows — these rows as CSV

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