PREVIEW / etf_30min / 2018-08-31

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-31.parquet
  size:    463 KB
  rows:    15,814

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
2018-08-31 04:00:00	SPY	ETF	289.86	290.09	289.86	289.99	5030.0
2018-08-31 04:30:00	SPY	ETF	289.99	290.11	289.99	290.06	13500.0
2018-08-31 05:00:00	SPY	ETF	290.14	290.17	289.97	290.17	3900.0
2018-08-31 05:30:00	SPY	ETF	290.15	290.15	289.8	289.87	17357.0
2018-08-31 06:00:00	SPY	ETF	289.77	289.87	289.7	289.84	9421.0
2018-08-31 06:30:00	SPY	ETF	289.85	289.99	289.82	289.91	28820.0
2018-08-31 07:00:00	SPY	ETF	289.94	289.95	289.76	289.76	59553.0
2018-08-31 07:30:00	SPY	ETF	289.74	289.81	289.66	289.67	100335.0
2018-08-31 08:00:00	SPY	ETF	289.7301	290.0	289.7	289.92	37387.0
2018-08-31 08:30:00	SPY	ETF	289.81	289.83	289.6	289.63	117576.0
2018-08-31 09:00:00	SPY	ETF	289.65	289.89	289.6	289.82	167497.0
2018-08-31 09:30:00	SPY	ETF	289.84	290.291	289.79	290.19	3352794.0
2018-08-31 10:00:00	SPY	ETF	290.185	290.81	290.17	290.47	4348461.0
2018-08-31 10:30:00	SPY	ETF	290.47	290.61	290.31	290.47	2802113.0
2018-08-31 11:00:00	SPY	ETF	290.47	290.635	289.93	289.95	3642732.0
2018-08-31 11:30:00	SPY	ETF	289.96	290.1799	289.69	289.71	4105832.0
2018-08-31 12:00:00	SPY	ETF	289.71	289.7599	289.42	289.68	3557106.0
2018-08-31 12:30:00	SPY	ETF	289.67	289.77	289.29	289.74	2863834.0
2018-08-31 13:00:00	SPY	ETF	289.75	289.88	289.595	289.745	1489601.0
2018-08-31 13:30:00	SPY	ETF	289.75	289.88	289.54	289.8	2664113.0
2018-08-31 14:00:00	SPY	ETF	289.81	289.83	289.33	289.495	2617623.0
2018-08-31 14:30:00	SPY	ETF	289.5	289.8	289.42	289.58	2396666.0
2018-08-31 15:00:00	SPY	ETF	289.59	290.0	289.5	289.55	3996846.0
2018-08-31 15:30:00	SPY	ETF	289.56	290.48	289.56	290.22	12217588.0
2018-08-31 16:00:00	SPY	ETF	290.23	290.66	290.0	290.63	11800729.0
2018-08-31 16:30:00	SPY	ETF	290.63	290.76	290.3002	290.76	663656.0
2018-08-31 17:00:00	SPY	ETF	290.74	290.79	290.6	290.6	95223.0
2018-08-31 17:30:00	SPY	ETF	290.69	290.79	290.31	290.79	818324.0
2018-08-31 18:00:00	SPY	ETF	290.79	290.98	290.79	290.9	47048.0
2018-08-31 18:30:00	SPY	ETF	290.89	290.93	290.85	290.87	5543.0
2018-08-31 19:00:00	SPY	ETF	290.94	290.94	290.31	290.93	5987.0
2018-08-31 19:30:00	SPY	ETF	290.95	291.0	290.9	291.0	24647.0
2018-08-31 04:00:00	QQQ	ETF	186.12	186.26	186.12	186.25	2905.0
2018-08-31 04:30:00	QQQ	ETF	186.23	186.25	186.2	186.25	5600.0
2018-08-31 05:00:00	QQQ	ETF	186.37	186.39	186.37	186.39	400.0
2018-08-31 05:30:00	QQQ	ETF	186.28	186.28	186.16	186.16	1200.0
2018-08-31 06:00:00	QQQ	ETF	186.1	186.17	186.07	186.17	3100.0
2018-08-31 06:30:00	QQQ	ETF	186.2	186.28	186.2	186.2	2050.0
2018-08-31 07:00:00	QQQ	ETF	186.22	186.3	186.16	186.17	11854.0
2018-08-31 07:30:00	QQQ	ETF	186.18	186.2	186.08	186.145	62410.0
2018-08-31 08:00:00	QQQ	ETF	186.1001	186.64	186.09	186.21	31563.0
2018-08-31 08:30:00	QQQ	ETF	186.19	186.21	186.06	186.07	75076.0
2018-08-31 09:00:00	QQQ	ETF	186.11	186.21	186.03	186.18	59510.0
2018-08-31 09:30:00	QQQ	ETF	186.18	186.91	186.15	186.72	2866126.0
2018-08-31 10:00:00	QQQ	ETF	186.73	187.18	186.69	186.95	2088291.0
2018-08-31 10:30:00	QQQ	ETF	186.95	187.06	186.82	186.96	892545.0
2018-08-31 11:00:00	QQQ	ETF	186.95	187.1185	186.57	186.585	1638943.0
2018-08-31 11:30:00	QQQ	ETF	186.59	186.72	186.265	186.34	2053233.0
2018-08-31 12:00:00	QQQ	ETF	186.33	186.56	186.19	186.47	1530895.0
2018-08-31 12:30:00	QQQ	ETF	186.46	186.58	186.21	186.5401	1178306.0

> showing 50 of 15,814 rows — these rows as CSV

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