PREVIEW / etf_30min / 2020-05-27

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-27.parquet
  size:    566 KB
  rows:    21,187

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-27 04:00:00	SPY	ETF	301.86	302.24	301.79	301.9	43613.0
2020-05-27 04:30:00	SPY	ETF	301.99	302.71	301.99	302.64	55875.0
2020-05-27 05:00:00	SPY	ETF	302.71	303.78	302.42	303.46	59680.0
2020-05-27 05:30:00	SPY	ETF	303.44	303.86	303.21	303.69	65208.0
2020-05-27 06:00:00	SPY	ETF	303.68	303.75	303.19	303.37	71532.0
2020-05-27 06:30:00	SPY	ETF	303.39	303.47	303.01	303.3	40357.0
2020-05-27 07:00:00	SPY	ETF	303.26	303.49	302.98	303.19	271338.0
2020-05-27 07:30:00	SPY	ETF	303.19	303.2	302.71	302.8	283335.0
2020-05-27 08:00:00	SPY	ETF	302.7201	303.5	300.0	303.09	563806.0
2020-05-27 08:30:00	SPY	ETF	303.09	303.32	302.25	302.25	1154754.0
2020-05-27 09:00:00	SPY	ETF	302.25	302.79	302.05	302.11	953320.0
2020-05-27 09:30:00	SPY	ETF	302.12	302.22	299.57	299.89	10980492.0
2020-05-27 10:00:00	SPY	ETF	299.91	300.59	299.27	299.91	6391568.0
2020-05-27 10:30:00	SPY	ETF	299.9075	299.9075	296.87	298.04	10249317.0
2020-05-27 11:00:00	SPY	ETF	298.03	298.96	297.41	298.93	5836446.0
2020-05-27 11:30:00	SPY	ETF	298.93	299.62	297.54	299.55	8100215.0
2020-05-27 12:00:00	SPY	ETF	299.54	300.22	299.28	299.73	4779522.0
2020-05-27 12:30:00	SPY	ETF	299.754	300.52	299.56	300.17	3191338.0
2020-05-27 13:00:00	SPY	ETF	300.165	300.49	299.45	300.27	4644976.0
2020-05-27 13:30:00	SPY	ETF	300.2783	300.43	299.67	300.36	2408314.0
2020-05-27 14:00:00	SPY	ETF	300.36	301.54	300.36	301.21	5288801.0
2020-05-27 14:30:00	SPY	ETF	301.215	301.78	300.84	301.74	4011478.0
2020-05-27 15:00:00	SPY	ETF	301.74	302.11	301.375	302.02	4957015.0
2020-05-27 15:30:00	SPY	ETF	302.015	303.57	301.57	303.48	21300990.0
2020-05-27 16:00:00	SPY	ETF	303.49	303.98	303.14	303.8	6608303.0
2020-05-27 16:30:00	SPY	ETF	303.84	304.25	303.84	303.99	618705.0
2020-05-27 17:00:00	SPY	ETF	303.97	304.18	303.53	304.01	197625.0
2020-05-27 17:30:00	SPY	ETF	304.01	304.04	303.53	303.75	84064.0
2020-05-27 18:00:00	SPY	ETF	303.83	303.95	303.5	303.51	208267.0
2020-05-27 18:30:00	SPY	ETF	303.53	304.24	303.41	304.09	192716.0
2020-05-27 19:00:00	SPY	ETF	304.1	304.28	303.87	304.07	112819.0
2020-05-27 19:30:00	SPY	ETF	304.05	304.63	303.73	304.54	214016.0
2020-05-27 04:00:00	QQQ	ETF	231.38	231.51	231.01	231.09	37222.0
2020-05-27 04:30:00	QQQ	ETF	231.26	231.55	231.19	231.52	23590.0
2020-05-27 05:00:00	QQQ	ETF	231.54	231.79	231.27	231.64	29044.0
2020-05-27 05:30:00	QQQ	ETF	231.63	232.02	231.61	232.0	15800.0
2020-05-27 06:00:00	QQQ	ETF	231.96	231.96	231.37	231.51	36635.0
2020-05-27 06:30:00	QQQ	ETF	231.45	231.5	231.1	231.29	21969.0
2020-05-27 07:00:00	QQQ	ETF	231.38	231.38	230.56	230.73	100602.0
2020-05-27 07:30:00	QQQ	ETF	230.75	230.8	230.34	230.34	93801.0
2020-05-27 08:00:00	QQQ	ETF	230.7299	231.5296	230.15	230.25	174891.0
2020-05-27 08:30:00	QQQ	ETF	230.27	230.27	229.13	229.21	239363.0
2020-05-27 09:00:00	QQQ	ETF	229.16	229.51	228.46	228.51	435056.0
2020-05-27 09:30:00	QQQ	ETF	228.51	229.07	226.3	226.69	7356065.0
2020-05-27 10:00:00	QQQ	ETF	226.68	227.59	226.08	226.79	4008821.0
2020-05-27 10:30:00	QQQ	ETF	226.77	226.82	223.94	224.9	6391645.0
2020-05-27 11:00:00	QQQ	ETF	224.91	226.05	224.05	225.865	3862002.0
2020-05-27 11:30:00	QQQ	ETF	225.85	226.52	224.64	226.38	3936619.0
2020-05-27 12:00:00	QQQ	ETF	226.38	227.21	226.13	226.79	2357057.0
2020-05-27 12:30:00	QQQ	ETF	226.79	227.94	226.669	227.5	1802228.0

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

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