PREVIEW / etf_30min / 2020-05-20

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-20.parquet
  size:    547 KB
  rows:    20,310

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-20 04:00:00	SPY	ETF	293.38	295.05	293.38	294.97	49502.0
2020-05-20 04:30:00	SPY	ETF	294.99	295.0	294.63	294.76	23572.0
2020-05-20 05:00:00	SPY	ETF	294.73	295.08	294.57	295.0	45181.0
2020-05-20 05:30:00	SPY	ETF	294.89	295.68	294.74	295.6	96902.0
2020-05-20 06:00:00	SPY	ETF	295.57	295.74	295.44	295.44	80545.0
2020-05-20 06:30:00	SPY	ETF	295.52	295.7	295.22	295.52	74269.0
2020-05-20 07:00:00	SPY	ETF	295.43	295.51	295.06	295.16	230535.0
2020-05-20 07:30:00	SPY	ETF	295.25	295.63	295.11	295.45	351291.0
2020-05-20 08:00:00	SPY	ETF	292.13	296.06	292.13	295.79	537125.0
2020-05-20 08:30:00	SPY	ETF	295.84	295.84	295.36	295.62	285993.0
2020-05-20 09:00:00	SPY	ETF	295.65	295.95	295.6	295.82	227876.0
2020-05-20 09:30:00	SPY	ETF	295.82	296.79	295.57	296.61	7780570.0
2020-05-20 10:00:00	SPY	ETF	296.605	297.55	296.474	297.31	5867246.0
2020-05-20 10:30:00	SPY	ETF	297.32	297.5	296.95	297.09	4350625.0
2020-05-20 11:00:00	SPY	ETF	297.09	297.87	296.93	297.76	4061244.0
2020-05-20 11:30:00	SPY	ETF	297.76	297.87	297.48	297.58	2658304.0
2020-05-20 12:00:00	SPY	ETF	297.573	297.74	296.52	296.895	4390266.0
2020-05-20 12:30:00	SPY	ETF	296.895	297.08	296.1	296.87	4083091.0
2020-05-20 13:00:00	SPY	ETF	296.885	296.99	295.97	296.2	4292627.0
2020-05-20 13:30:00	SPY	ETF	296.19	296.86	296.15	296.5023	3128145.0
2020-05-20 14:00:00	SPY	ETF	296.5	296.95	295.81	296.26	5293325.0
2020-05-20 14:30:00	SPY	ETF	296.2599	297.43	296.16	297.105	3196631.0
2020-05-20 15:00:00	SPY	ETF	297.1	297.25	296.22	297.17	5357474.0
2020-05-20 15:30:00	SPY	ETF	297.16	297.34	296.29	296.96	11820865.0
2020-05-20 16:00:00	SPY	ETF	296.97	297.53	296.93	296.93	13704982.0
2020-05-20 16:30:00	SPY	ETF	297.18	297.63	296.93	297.5	642216.0
2020-05-20 17:00:00	SPY	ETF	297.5	297.57	297.42	297.5	69637.0
2020-05-20 17:30:00	SPY	ETF	297.5	297.65	296.93	297.55	28229.0
2020-05-20 18:00:00	SPY	ETF	297.58	297.66	297.08	297.1	243326.0
2020-05-20 18:30:00	SPY	ETF	297.15	297.5	297.0	297.07	83521.0
2020-05-20 19:00:00	SPY	ETF	297.05	297.15	296.92	296.95	119742.0
2020-05-20 19:30:00	SPY	ETF	296.97	297.03	296.8	296.83	131198.0
2020-05-20 04:00:00	QQQ	ETF	227.98	229.13	227.98	229.13	42312.0
2020-05-20 04:30:00	QQQ	ETF	229.18	229.18	228.88	228.95	22390.0
2020-05-20 05:00:00	QQQ	ETF	228.94	229.39	228.89	229.35	25396.0
2020-05-20 05:30:00	QQQ	ETF	229.16	229.66	229.08	229.65	8672.0
2020-05-20 06:00:00	QQQ	ETF	229.56	229.61	229.36	229.36	13881.0
2020-05-20 06:30:00	QQQ	ETF	229.35	229.6	229.22	229.47	12744.0
2020-05-20 07:00:00	QQQ	ETF	229.4	229.45	229.15	229.17	80760.0
2020-05-20 07:30:00	QQQ	ETF	229.22	229.42	229.15	229.31	49998.0
2020-05-20 08:00:00	QQQ	ETF	229.32	229.75	227.43	229.5	138178.0
2020-05-20 08:30:00	QQQ	ETF	229.5	229.52	229.29	229.47	126728.0
2020-05-20 09:00:00	QQQ	ETF	229.53	229.61	229.38	229.48	120782.0
2020-05-20 09:30:00	QQQ	ETF	229.48	230.9199	229.48	230.91	4948081.0
2020-05-20 10:00:00	QQQ	ETF	230.92	231.22	230.62	230.74	3276008.0
2020-05-20 10:30:00	QQQ	ETF	230.76	231.08	230.51	230.76	1943369.0
2020-05-20 11:00:00	QQQ	ETF	230.77	231.63	230.74	231.6	1967417.0
2020-05-20 11:30:00	QQQ	ETF	231.6	231.74	231.46	231.5999	1596895.0
2020-05-20 12:00:00	QQQ	ETF	231.6	231.76	230.66	230.96	2133900.0
2020-05-20 12:30:00	QQQ	ETF	230.965	231.14	230.15	230.93	2048906.0

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

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