PREVIEW / etf_30min / 2020-04-15

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-15.parquet
  size:    583 KB
  rows:    21,497

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
2020-04-15 04:00:00	SPY	ETF	280.36	280.96	280.2	280.6	55733.0
2020-04-15 04:30:00	SPY	ETF	280.65	280.65	279.21	279.6	71914.0
2020-04-15 05:00:00	SPY	ETF	279.6	279.66	278.86	279.26	62315.0
2020-04-15 05:30:00	SPY	ETF	279.31	279.66	279.21	279.52	34222.0
2020-04-15 06:00:00	SPY	ETF	279.54	280.1	278.95	279.25	76894.0
2020-04-15 06:30:00	SPY	ETF	279.34	279.48	278.6	279.45	188666.0
2020-04-15 07:00:00	SPY	ETF	279.49	280.23	279.28	280.16	665829.0
2020-04-15 07:30:00	SPY	ETF	280.12	280.15	279.29	279.29	366088.0
2020-04-15 08:00:00	SPY	ETF	279.3799	283.68	277.81	277.92	950416.0
2020-04-15 08:30:00	SPY	ETF	277.88	278.15	275.96	276.23	1460106.0
2020-04-15 09:00:00	SPY	ETF	276.21	277.62	275.78	277.56	1458300.0
2020-04-15 09:30:00	SPY	ETF	277.57	278.39	276.33	277.369	15224763.0
2020-04-15 10:00:00	SPY	ETF	277.37	283.9407	275.626	276.0499	11926304.0
2020-04-15 10:30:00	SPY	ETF	275.99	277.18	275.46	276.7847	7406978.0
2020-04-15 11:00:00	SPY	ETF	276.77	276.94	275.63	276.4633	6593248.0
2020-04-15 11:30:00	SPY	ETF	276.48	277.28	275.79	276.14	6127082.0
2020-04-15 12:00:00	SPY	ETF	276.13	277.0	275.76	276.88	5998528.0
2020-04-15 12:30:00	SPY	ETF	276.8975	277.87	276.66	277.3586	5823066.0
2020-04-15 13:00:00	SPY	ETF	277.35	278.75	277.17	277.81	6509743.0
2020-04-15 13:30:00	SPY	ETF	277.8	277.81	277.03	277.1699	6003618.0
2020-04-15 14:00:00	SPY	ETF	277.18	278.91	277.17	278.72	6542991.0
2020-04-15 14:30:00	SPY	ETF	278.74	279.41	278.44	279.38	7509410.0
2020-04-15 15:00:00	SPY	ETF	279.385	279.59	277.7	278.05	7211936.0
2020-04-15 15:30:00	SPY	ETF	278.04	278.35	277.07	277.75	15802155.0
2020-04-15 16:00:00	SPY	ETF	277.73	278.79	277.4392	277.64	4793314.0
2020-04-15 16:30:00	SPY	ETF	277.64	277.77	276.82	277.08	1284625.0
2020-04-15 17:00:00	SPY	ETF	277.2	277.2	276.95	277.04	726218.0
2020-04-15 17:30:00	SPY	ETF	277.03	277.15	276.98	277.05	30956.0
2020-04-15 18:00:00	SPY	ETF	277.08	277.76	276.0	276.44	253491.0
2020-04-15 18:30:00	SPY	ETF	276.51	276.68	275.64	275.9	113006.0
2020-04-15 19:00:00	SPY	ETF	275.92	275.96	275.4	275.82	116720.0
2020-04-15 19:30:00	SPY	ETF	275.85	276.03	275.57	275.7	134549.0
2020-04-15 04:00:00	QQQ	ETF	209.75	210.14	209.66	209.9	23199.0
2020-04-15 04:30:00	QQQ	ETF	209.92	209.92	209.16	209.5	29207.0
2020-04-15 05:00:00	QQQ	ETF	209.3	209.45	208.83	209.15	26376.0
2020-04-15 05:30:00	QQQ	ETF	209.23	209.53	209.23	209.44	34278.0
2020-04-15 06:00:00	QQQ	ETF	209.48	209.74	209.03	209.32	60745.0
2020-04-15 06:30:00	QQQ	ETF	209.27	209.63	208.95	209.56	41252.0
2020-04-15 07:00:00	QQQ	ETF	209.62	210.33	209.57	210.26	146305.0
2020-04-15 07:30:00	QQQ	ETF	210.24	210.3	209.77	209.77	135037.0
2020-04-15 08:00:00	QQQ	ETF	209.78	211.86	208.35	208.35	337180.0
2020-04-15 08:30:00	QQQ	ETF	208.39	208.66	207.65	207.88	510008.0
2020-04-15 09:00:00	QQQ	ETF	207.82	208.54	207.6	208.53	382673.0
2020-04-15 09:30:00	QQQ	ETF	208.53	209.06	207.12	207.9134	5246361.0
2020-04-15 10:00:00	QQQ	ETF	207.92	208.47	207.48	208.18	3058469.0
2020-04-15 10:30:00	QQQ	ETF	208.16	209.44	207.75	209.2	2859387.0
2020-04-15 11:00:00	QQQ	ETF	209.205	209.4298	208.05	208.635	2211128.0
2020-04-15 11:30:00	QQQ	ETF	208.65	209.02	207.91	208.1814	1965154.0
2020-04-15 12:00:00	QQQ	ETF	208.16	208.91	208.02	208.8099	1630575.0
2020-04-15 12:30:00	QQQ	ETF	208.8	209.56	208.725	209.196	1694948.0

> showing 50 of 21,497 rows — these rows as CSV

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