PREVIEW / etf_30min / 2020-06-02

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-02.parquet
  size:    552 KB
  rows:    20,585

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-06-02 04:00:00	SPY	ETF	305.53	306.58	305.52	306.58	30133.0
2020-06-02 04:30:00	SPY	ETF	306.56	307.23	306.56	306.91	33365.0
2020-06-02 05:00:00	SPY	ETF	306.91	307.21	306.81	307.21	19585.0
2020-06-02 05:30:00	SPY	ETF	307.21	307.88	307.21	307.63	45518.0
2020-06-02 06:00:00	SPY	ETF	307.57	307.7	307.43	307.6	19672.0
2020-06-02 06:30:00	SPY	ETF	307.56	307.75	307.36	307.41	55585.0
2020-06-02 07:00:00	SPY	ETF	307.37	307.42	306.98	307.13	111117.0
2020-06-02 07:30:00	SPY	ETF	307.1	307.25	306.8	306.97	67476.0
2020-06-02 08:00:00	SPY	ETF	307.2501	307.4	304.02	307.05	299730.0
2020-06-02 08:30:00	SPY	ETF	307.0304	307.22	306.5	306.7	279653.0
2020-06-02 09:00:00	SPY	ETF	306.74	306.78	306.32	306.55	475074.0
2020-06-02 09:30:00	SPY	ETF	306.55	306.6	305.52	306.27	6733142.0
2020-06-02 10:00:00	SPY	ETF	306.28	307.18	306.28	307.1601	4758089.0
2020-06-02 10:30:00	SPY	ETF	307.17	307.26	305.83	306.3867	5159536.0
2020-06-02 11:00:00	SPY	ETF	306.37	306.41	305.1	305.75	5167229.0
2020-06-02 11:30:00	SPY	ETF	305.75	306.34	305.57	305.86	4811174.0
2020-06-02 12:00:00	SPY	ETF	305.84	306.47	305.76	306.46	2266189.0
2020-06-02 12:30:00	SPY	ETF	306.458	306.55	306.24	306.405	2085878.0
2020-06-02 13:00:00	SPY	ETF	306.42	306.97	306.375	306.89	2819967.0
2020-06-02 13:30:00	SPY	ETF	306.89	307.14	306.73	307.06	3757451.0
2020-06-02 14:00:00	SPY	ETF	307.06	307.19	306.58	306.72	3502316.0
2020-06-02 14:30:00	SPY	ETF	306.7	306.94	306.15	306.79	4175672.0
2020-06-02 15:00:00	SPY	ETF	306.79	306.89	306.03	306.43	5360988.0
2020-06-02 15:30:00	SPY	ETF	306.435	308.13	306.19	308.13	15444866.0
2020-06-02 16:00:00	SPY	ETF	308.11	308.14	307.72	308.05	4437888.0
2020-06-02 16:30:00	SPY	ETF	308.03	308.24	307.93	308.1	469988.0
2020-06-02 17:00:00	SPY	ETF	308.1202	308.21	308.06	308.17	89034.0
2020-06-02 17:30:00	SPY	ETF	308.12	308.2	308.05	308.14	56697.0
2020-06-02 18:00:00	SPY	ETF	308.16	308.32	307.79	308.0	268139.0
2020-06-02 18:30:00	SPY	ETF	307.96	308.04	307.85	307.93	41403.0
2020-06-02 19:00:00	SPY	ETF	307.95	308.75	307.92	308.73	131312.0
2020-06-02 19:30:00	SPY	ETF	308.69	309.07	308.69	308.89	189108.0
2020-06-02 04:00:00	QQQ	ETF	234.68	235.18	234.62	235.18	40269.0
2020-06-02 04:30:00	QQQ	ETF	235.27	235.5	235.21	235.31	20818.0
2020-06-02 05:00:00	QQQ	ETF	235.31	235.51	235.3	235.51	8600.0
2020-06-02 05:30:00	QQQ	ETF	235.48	235.9	235.48	235.85	18152.0
2020-06-02 06:00:00	QQQ	ETF	235.79	236.0	235.63	235.7	20331.0
2020-06-02 06:30:00	QQQ	ETF	235.64	235.85	235.51	235.67	36300.0
2020-06-02 07:00:00	QQQ	ETF	235.6	235.63	235.19	235.23	68077.0
2020-06-02 07:30:00	QQQ	ETF	235.28	235.32	234.94	234.94	60384.0
2020-06-02 08:00:00	QQQ	ETF	235.4999	235.605	233.63	234.83	146924.0
2020-06-02 08:30:00	QQQ	ETF	234.81	234.95	234.29	234.6	122776.0
2020-06-02 09:00:00	QQQ	ETF	234.63	234.64	234.38	234.42	128209.0
2020-06-02 09:30:00	QQQ	ETF	234.42	234.5	233.31	233.9321	3788876.0
2020-06-02 10:00:00	QQQ	ETF	233.94	234.59	233.88	234.47	2069965.0
2020-06-02 10:30:00	QQQ	ETF	234.48	234.55	232.76	233.21	2875741.0
2020-06-02 11:00:00	QQQ	ETF	233.22	233.24	232.01	232.58	3732533.0
2020-06-02 11:30:00	QQQ	ETF	232.59	233.23	232.431	232.79	1822524.0
2020-06-02 12:00:00	QQQ	ETF	232.77	233.47	232.75	233.45	1142266.0
2020-06-02 12:30:00	QQQ	ETF	233.4501	233.73	233.29	233.6488	855310.0

> showing 50 of 20,585 rows — these rows as CSV

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