PREVIEW / etf_30min / 2018-10-18

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-18.parquet
  size:    488 KB
  rows:    16,848

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-10-18 04:00:00	SPY	ETF	280.43	280.5	280.21	280.26	20084.0
2018-10-18 04:30:00	SPY	ETF	280.16	280.47	280.16	280.35	10156.0
2018-10-18 05:00:00	SPY	ETF	280.12	280.13	279.93	280.13	7661.0
2018-10-18 05:30:00	SPY	ETF	280.15	280.39	279.84	280.33	22458.0
2018-10-18 06:00:00	SPY	ETF	280.31	280.35	280.17	280.22	4180.0
2018-10-18 06:30:00	SPY	ETF	280.2	280.2	279.7	279.76	60351.0
2018-10-18 07:00:00	SPY	ETF	279.77	280.08	279.77	279.78	90162.0
2018-10-18 07:30:00	SPY	ETF	279.86	279.98	279.49	279.61	94051.0
2018-10-18 08:00:00	SPY	ETF	279.85	280.43	279.39	279.86	184422.0
2018-10-18 08:30:00	SPY	ETF	279.88	279.93	279.74	279.85	176589.0
2018-10-18 09:00:00	SPY	ETF	279.8	279.88	279.37	279.4	252236.0
2018-10-18 09:30:00	SPY	ETF	279.4	279.47	278.485	278.74	7427748.0
2018-10-18 10:00:00	SPY	ETF	278.72	279.34	278.33	279.18	6199856.0
2018-10-18 10:30:00	SPY	ETF	279.17	280.07	279.03	279.89	6064595.0
2018-10-18 11:00:00	SPY	ETF	279.89	280.0	278.12	278.23	5969320.0
2018-10-18 11:30:00	SPY	ETF	278.23	278.28	276.09	276.54	15140492.0
2018-10-18 12:00:00	SPY	ETF	276.53	277.46	276.22	277.16	9629983.0
2018-10-18 12:30:00	SPY	ETF	277.16	277.9319	276.85	277.18	6119980.0
2018-10-18 13:00:00	SPY	ETF	277.16	277.39	275.44	275.74	8763172.0
2018-10-18 13:30:00	SPY	ETF	275.74	276.06	274.97	275.405	11694284.0
2018-10-18 14:00:00	SPY	ETF	275.39	276.66	275.29	276.26	8308284.0
2018-10-18 14:30:00	SPY	ETF	276.24	277.07	275.88	276.39	6139202.0
2018-10-18 15:00:00	SPY	ETF	276.39	276.76	275.57	276.47	8182245.0
2018-10-18 15:30:00	SPY	ETF	276.46	277.02	275.88	276.47	20409803.0
2018-10-18 16:00:00	SPY	ETF	276.46	279.25	276.33	276.61	9359538.0
2018-10-18 16:30:00	SPY	ETF	276.62	276.82	276.3578	276.81	1634169.0
2018-10-18 17:00:00	SPY	ETF	276.81	276.82	276.4	276.82	92924.0
2018-10-18 17:30:00	SPY	ETF	276.82	276.88	276.4	276.82	130032.0
2018-10-18 18:00:00	SPY	ETF	276.81	276.84	276.46	276.61	163693.0
2018-10-18 18:30:00	SPY	ETF	276.65	276.69	276.55	276.69	57215.0
2018-10-18 19:00:00	SPY	ETF	276.68	276.74	276.4	276.68	16422.0
2018-10-18 19:30:00	SPY	ETF	276.67	276.76	276.44	276.55	35116.0
2018-10-18 04:00:00	QQQ	ETF	177.39	177.39	177.28	177.28	17569.0
2018-10-18 04:30:00	QQQ	ETF	177.28	177.36	177.22	177.29	8279.0
2018-10-18 05:00:00	QQQ	ETF	177.19	177.19	177.03	177.1	36296.0
2018-10-18 05:30:00	QQQ	ETF	177.06	177.29	176.91	177.29	19690.0
2018-10-18 06:00:00	QQQ	ETF	177.23	177.23	177.1	177.16	2349.0
2018-10-18 06:30:00	QQQ	ETF	177.01	177.06	176.79	176.79	21865.0
2018-10-18 07:00:00	QQQ	ETF	176.83	177.0	176.8	176.8	48275.0
2018-10-18 07:30:00	QQQ	ETF	176.9	177.0	176.62	176.64	56144.0
2018-10-18 08:00:00	QQQ	ETF	176.85	177.5	176.51	176.91	164275.0
2018-10-18 08:30:00	QQQ	ETF	176.82	177.04	176.82	176.94	216130.0
2018-10-18 09:00:00	QQQ	ETF	176.93	176.95	176.55	176.59	119173.0
2018-10-18 09:30:00	QQQ	ETF	176.6	176.68	175.6375	175.8	5564735.0
2018-10-18 10:00:00	QQQ	ETF	175.8	175.95	175.24	175.66	4391948.0
2018-10-18 10:30:00	QQQ	ETF	175.6425	176.29	175.52	176.08	2699941.0
2018-10-18 11:00:00	QQQ	ETF	176.1	176.225	174.54	174.64	5125888.0
2018-10-18 11:30:00	QQQ	ETF	174.63	174.72	173.19	173.54	7428291.0
2018-10-18 12:00:00	QQQ	ETF	173.53	174.25	173.33	174.11	4925372.0
2018-10-18 12:30:00	QQQ	ETF	174.11	174.69	173.9	173.94	3204992.0

> showing 50 of 16,848 rows — these rows as CSV

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