PREVIEW / etf_30min / 2017-04-10

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-04-10.parquet
  size:    421 KB
  rows:    14,498

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-10 04:00:00	SPY	ETF	235.26	235.4	235.26	235.4	500.0
2017-04-10 04:30:00	SPY	ETF	235.39	235.42	235.29	235.29	4000.0
2017-04-10 05:00:00	SPY	ETF	235.35	235.35	235.34	235.34	789.0
2017-04-10 05:30:00	SPY	ETF	235.29	235.29	235.19	235.19	502.0
2017-04-10 06:00:00	SPY	ETF	235.0	235.14	234.92	235.09	12667.0
2017-04-10 06:30:00	SPY	ETF	235.08	235.2	235.08	235.13	21677.0
2017-04-10 07:00:00	SPY	ETF	235.22	235.35	235.21	235.35	40185.0
2017-04-10 07:30:00	SPY	ETF	235.38	235.48	235.38	235.45	149477.0
2017-04-10 08:00:00	SPY	ETF	235.45	235.49	235.13	235.41	114786.0
2017-04-10 08:30:00	SPY	ETF	235.41	235.42	235.21	235.21	71980.0
2017-04-10 09:00:00	SPY	ETF	235.22	235.38	235.22	235.35	118272.0
2017-04-10 09:30:00	SPY	ETF	235.36	235.97	235.28	235.96	4648692.0
2017-04-10 10:00:00	SPY	ETF	235.95	236.09	235.86	235.9501	3719721.0
2017-04-10 10:30:00	SPY	ETF	235.96	236.255	235.81	235.83	3934760.0
2017-04-10 11:00:00	SPY	ETF	235.83	235.99	235.73	235.82	4423009.0
2017-04-10 11:30:00	SPY	ETF	235.82	235.86	235.04	235.28	6498970.0
2017-04-10 12:00:00	SPY	ETF	235.28	235.36	234.73	234.9856	4733324.0
2017-04-10 12:30:00	SPY	ETF	234.985	235.69	234.92	235.66	5212961.0
2017-04-10 13:00:00	SPY	ETF	235.66	235.79	235.59	235.69	2398691.0
2017-04-10 13:30:00	SPY	ETF	235.69	235.96	235.67	235.785	1943429.0
2017-04-10 14:00:00	SPY	ETF	235.79	235.7985	235.41	235.5	2755754.0
2017-04-10 14:30:00	SPY	ETF	235.49	235.87	235.42	235.8	3221234.0
2017-04-10 15:00:00	SPY	ETF	235.8	235.97	235.36	235.5	4340653.0
2017-04-10 15:30:00	SPY	ETF	235.51	235.62	235.14	235.32	9939599.0
2017-04-10 16:00:00	SPY	ETF	235.32	235.38	235.07	235.21	6062202.0
2017-04-10 16:30:00	SPY	ETF	235.2	235.35	235.16	235.33	539188.0
2017-04-10 17:00:00	SPY	ETF	235.32	235.38	235.29	235.35	217466.0
2017-04-10 17:30:00	SPY	ETF	235.35	235.39	235.35	235.39	6754.0
2017-04-10 18:00:00	SPY	ETF	235.38	235.51	235.32	235.49	47090.0
2017-04-10 18:30:00	SPY	ETF	235.47	235.47	235.34	235.38	8731.0
2017-04-10 19:00:00	SPY	ETF	235.39	235.39	235.36	235.36	5214.0
2017-04-10 19:30:00	SPY	ETF	235.38	235.43	235.26	235.28	21045.0
2017-04-10 04:00:00	QQQ	ETF	132.1	132.13	132.1	132.13	1500.0
2017-04-10 04:30:00	QQQ	ETF	132.07	132.07	132.07	132.07	600.0
2017-04-10 05:00:00	QQQ	ETF	132.07	132.08	132.07	132.08	700.0
2017-04-10 05:30:00	QQQ	ETF	132.02	132.02	131.95	131.95	18100.0
2017-04-10 06:00:00	QQQ	ETF	131.9	131.98	131.9	131.98	600.0
2017-04-10 07:00:00	QQQ	ETF	132.0	132.12	132.0	132.12	17179.0
2017-04-10 07:30:00	QQQ	ETF	132.15	132.15	132.12	132.15	46529.0
2017-04-10 08:00:00	QQQ	ETF	132.15	132.17	132.09	132.13	36856.0
2017-04-10 08:30:00	QQQ	ETF	132.11	132.11	132.03	132.03	24290.0
2017-04-10 09:00:00	QQQ	ETF	132.04	132.11	132.04	132.1	41958.0
2017-04-10 09:30:00	QQQ	ETF	132.11	132.45	132.05	132.39	1577961.0
2017-04-10 10:00:00	QQQ	ETF	132.39	132.43	132.29	132.37	700407.0
2017-04-10 10:30:00	QQQ	ETF	132.37	132.565	132.22	132.2395	1157273.0
2017-04-10 11:00:00	QQQ	ETF	132.24	132.3401	132.2	132.255	677049.0
2017-04-10 11:30:00	QQQ	ETF	132.26	132.27	131.83	131.95	1547468.0
2017-04-10 12:00:00	QQQ	ETF	131.96	132.03	131.6564	131.81	1311300.0
2017-04-10 12:30:00	QQQ	ETF	131.81	132.26	131.77	132.23	1102114.0
2017-04-10 13:00:00	QQQ	ETF	132.22	132.3663	132.2	132.28	692415.0

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

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