PREVIEW / etf_30min / 2020-05-29

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-29.parquet
  size:    549 KB
  rows:    20,597

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-05-29 04:00:00	SPY	ETF	302.28	302.51	301.71	302.01	70208.0
2020-05-29 04:30:00	SPY	ETF	302.35	302.46	302.19	302.26	8924.0
2020-05-29 05:00:00	SPY	ETF	302.42	302.8	302.09	302.77	10120.0
2020-05-29 05:30:00	SPY	ETF	302.67	303.3	302.49	303.26	67282.0
2020-05-29 06:00:00	SPY	ETF	303.23	303.67	303.16	303.35	41925.0
2020-05-29 06:30:00	SPY	ETF	303.4	303.52	303.13	303.49	23401.0
2020-05-29 07:00:00	SPY	ETF	303.42	303.77	303.14	303.63	99711.0
2020-05-29 07:30:00	SPY	ETF	303.59	303.81	303.18	303.46	156251.0
2020-05-29 08:00:00	SPY	ETF	303.4701	303.8	302.07	303.05	313977.0
2020-05-29 08:30:00	SPY	ETF	303.02	303.15	302.43	302.65	420252.0
2020-05-29 09:00:00	SPY	ETF	302.6	302.78	302.11	302.45	528016.0
2020-05-29 09:30:00	SPY	ETF	302.46	303.14	301.78	302.23	8108316.0
2020-05-29 10:00:00	SPY	ETF	302.24	302.59	301.14	301.56	6488239.0
2020-05-29 10:30:00	SPY	ETF	301.57	302.04	300.63	301.0299	6261191.0
2020-05-29 11:00:00	SPY	ETF	301.02	301.73	300.48	301.36	5141901.0
2020-05-29 11:30:00	SPY	ETF	301.37	302.06	300.97	301.67	4329912.0
2020-05-29 12:00:00	SPY	ETF	301.7	301.948	300.69	301.12	4605133.0
2020-05-29 12:30:00	SPY	ETF	301.1	302.27	299.47	301.631	7304415.0
2020-05-29 13:00:00	SPY	ETF	301.63	301.87	301.11	301.411	4793304.0
2020-05-29 13:30:00	SPY	ETF	301.43	301.58	300.72	301.13	3168838.0
2020-05-29 14:00:00	SPY	ETF	301.14	303.03	300.95	302.86	7101085.0
2020-05-29 14:30:00	SPY	ETF	302.86	303.64	300.07	303.57	12528419.0
2020-05-29 15:00:00	SPY	ETF	303.56	304.58	303.08	303.64	13969073.0
2020-05-29 15:30:00	SPY	ETF	303.62	304.96	303.32	304.16	17557019.0
2020-05-29 16:00:00	SPY	ETF	304.17	305.79	304.06	305.54	12612622.0
2020-05-29 16:30:00	SPY	ETF	305.55	306.13	304.32	306.0	869474.0
2020-05-29 17:00:00	SPY	ETF	306.03	306.03	304.32	306.0	667009.0
2020-05-29 17:30:00	SPY	ETF	306.0001	306.09	304.32	305.91	81942.0
2020-05-29 18:00:00	SPY	ETF	306.0	306.0	305.83	305.84	33510.0
2020-05-29 18:30:00	SPY	ETF	305.89	305.93	305.82	305.93	38721.0
2020-05-29 19:00:00	SPY	ETF	305.92	306.1	305.88	305.99	62389.0
2020-05-29 19:30:00	SPY	ETF	306.01	306.1	305.91	306.1	59681.0
2020-05-29 04:00:00	QQQ	ETF	229.75	229.76	229.14	229.29	36879.0
2020-05-29 04:30:00	QQQ	ETF	229.31	229.62	229.31	229.58	14300.0
2020-05-29 05:00:00	QQQ	ETF	229.6	229.95	229.2	229.84	9800.0
2020-05-29 05:30:00	QQQ	ETF	229.71	230.13	229.61	230.11	20864.0
2020-05-29 06:00:00	QQQ	ETF	230.14	230.46	230.07	230.4	8900.0
2020-05-29 06:30:00	QQQ	ETF	230.3	230.46	230.28	230.34	10000.0
2020-05-29 07:00:00	QQQ	ETF	230.38	230.76	230.23	230.76	49836.0
2020-05-29 07:30:00	QQQ	ETF	230.73	231.32	230.52	231.2	85045.0
2020-05-29 08:00:00	QQQ	ETF	230.47	231.6301	229.91	231.1	196569.0
2020-05-29 08:30:00	QQQ	ETF	231.14	231.2	230.56	230.76	131085.0
2020-05-29 09:00:00	QQQ	ETF	230.82	230.92	230.45	230.46	159520.0
2020-05-29 09:30:00	QQQ	ETF	230.43	231.43	229.94	230.8499	4754070.0
2020-05-29 10:00:00	QQQ	ETF	230.87	231.01	228.96	229.59	4818874.0
2020-05-29 10:30:00	QQQ	ETF	229.61	230.24	229.05	229.66	3045595.0
2020-05-29 11:00:00	QQQ	ETF	229.66	230.05	228.76	229.82	2784030.0
2020-05-29 11:30:00	QQQ	ETF	229.82	230.73	229.36	230.51	1900387.0
2020-05-29 12:00:00	QQQ	ETF	230.52	230.77	229.6	230.0531	1426885.0
2020-05-29 12:30:00	QQQ	ETF	230.05	230.96	228.89	230.54	2205064.0

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

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