PREVIEW / etf_30min / 2019-02-25

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-02-25.parquet
  size:    511 KB
  rows:    17,943

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
2019-02-25 04:00:00	SPY	ETF	279.9	280.16	279.9	280.15	18892.0
2019-02-25 04:30:00	SPY	ETF	280.14	280.15	279.98	280.03	14534.0
2019-02-25 05:00:00	SPY	ETF	280.02	280.29	280.0	280.16	8883.0
2019-02-25 05:30:00	SPY	ETF	280.16	280.33	280.16	280.29	17505.0
2019-02-25 06:00:00	SPY	ETF	280.35	280.46	280.3	280.4	25291.0
2019-02-25 06:30:00	SPY	ETF	280.36	280.46	280.3	280.35	21116.0
2019-02-25 07:00:00	SPY	ETF	280.29	280.35	280.2	280.27	57179.0
2019-02-25 07:30:00	SPY	ETF	280.28	280.36	280.25	280.36	96911.0
2019-02-25 08:00:00	SPY	ETF	280.37	280.44	279.75	280.41	122325.0
2019-02-25 08:30:00	SPY	ETF	280.41	280.71	280.4	280.71	266272.0
2019-02-25 09:00:00	SPY	ETF	280.73	280.83	280.68	280.72	313551.0
2019-02-25 09:30:00	SPY	ETF	280.73	281.08	280.61	280.63	7713990.0
2019-02-25 10:00:00	SPY	ETF	280.625	280.99	280.44	280.59	4155761.0
2019-02-25 10:30:00	SPY	ETF	280.5862	281.27	280.41	281.2	7012769.0
2019-02-25 11:00:00	SPY	ETF	281.2	281.31	280.8	280.87	3961245.0
2019-02-25 11:30:00	SPY	ETF	280.87	281.11	280.78	280.9	4557110.0
2019-02-25 12:00:00	SPY	ETF	280.8864	280.95	280.45	280.54	4949574.0
2019-02-25 12:30:00	SPY	ETF	280.54	280.61	280.08	280.25	3326758.0
2019-02-25 13:00:00	SPY	ETF	280.2562	280.42	280.13	280.16	2133153.0
2019-02-25 13:30:00	SPY	ETF	280.14	280.28	279.95	280.21	2524688.0
2019-02-25 14:00:00	SPY	ETF	280.21	280.42	280.18	280.2	2840054.0
2019-02-25 14:30:00	SPY	ETF	280.2	280.34	280.08	280.12	2602619.0
2019-02-25 15:00:00	SPY	ETF	280.12	280.19	279.59	279.6083	4238581.0
2019-02-25 15:30:00	SPY	ETF	279.61	280.0599	279.43	279.57	11071803.0
2019-02-25 16:00:00	SPY	ETF	279.6	279.7611	279.48	279.6	5336535.0
2019-02-25 16:30:00	SPY	ETF	279.59	279.59	279.42	279.47	252169.0
2019-02-25 17:00:00	SPY	ETF	279.48	279.51	279.44	279.44	78281.0
2019-02-25 17:30:00	SPY	ETF	279.44	279.44	279.25	279.4	164407.0
2019-02-25 18:00:00	SPY	ETF	279.4	279.5	279.14	279.16	157042.0
2019-02-25 18:30:00	SPY	ETF	279.16	279.35	279.16	279.34	15130.0
2019-02-25 19:00:00	SPY	ETF	279.33	279.45	279.29	279.29	16182.0
2019-02-25 19:30:00	SPY	ETF	279.26	279.36	279.13	279.15	41940.0
2019-02-25 04:00:00	QQQ	ETF	173.41	173.6	173.41	173.6	15093.0
2019-02-25 04:30:00	QQQ	ETF	173.61	173.64	173.56	173.6	15205.0
2019-02-25 05:00:00	QQQ	ETF	173.64	173.73	173.59	173.69	12795.0
2019-02-25 05:30:00	QQQ	ETF	173.67	173.79	173.67	173.78	19711.0
2019-02-25 06:00:00	QQQ	ETF	173.81	173.86	173.77	173.86	6853.0
2019-02-25 06:30:00	QQQ	ETF	173.87	173.91	173.81	173.86	12094.0
2019-02-25 07:00:00	QQQ	ETF	173.83	173.88	173.73	173.85	50077.0
2019-02-25 07:30:00	QQQ	ETF	173.85	173.93	173.83	173.91	39127.0
2019-02-25 08:00:00	QQQ	ETF	173.75	173.97	173.23	173.93	104158.0
2019-02-25 08:30:00	QQQ	ETF	173.94	174.18	173.91	174.17	169677.0
2019-02-25 09:00:00	QQQ	ETF	174.19	174.31	174.16	174.19	217608.0
2019-02-25 09:30:00	QQQ	ETF	174.2	174.64	174.13	174.17	4044629.0
2019-02-25 10:00:00	QQQ	ETF	174.17	174.56	174.03	174.24	2579402.0
2019-02-25 10:30:00	QQQ	ETF	174.24	174.62	174.0401	174.54	1987280.0
2019-02-25 11:00:00	QQQ	ETF	174.54	174.66	174.3399	174.385	1645240.0
2019-02-25 11:30:00	QQQ	ETF	174.38	174.49	174.25	174.3184	1698674.0
2019-02-25 12:00:00	QQQ	ETF	174.31	174.335	173.79	173.81	1738907.0
2019-02-25 12:30:00	QQQ	ETF	173.81	173.87	173.43	173.65	1745309.0

> showing 50 of 17,943 rows — these rows as CSV

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