PREVIEW / etf_30min / 2020-05-19

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-19.parquet
  size:    540 KB
  rows:    20,392

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-19 04:00:00	SPY	ETF	295.43	295.64	293.95	293.99	73094.0
2020-05-19 04:30:00	SPY	ETF	294.02	294.65	293.56	294.58	17110.0
2020-05-19 05:00:00	SPY	ETF	294.63	294.74	293.8	293.94	21179.0
2020-05-19 05:30:00	SPY	ETF	294.06	294.5	293.91	294.15	38746.0
2020-05-19 06:00:00	SPY	ETF	294.06	294.07	293.42	293.72	94831.0
2020-05-19 06:30:00	SPY	ETF	293.63	294.3	293.5	293.95	44220.0
2020-05-19 07:00:00	SPY	ETF	293.92	295.11	293.92	294.92	232158.0
2020-05-19 07:30:00	SPY	ETF	294.88	295.15	294.43	294.43	173528.0
2020-05-19 08:00:00	SPY	ETF	293.9896	297.5	293.5	294.11	355318.0
2020-05-19 08:30:00	SPY	ETF	294.11	294.75	294.0	294.57	251149.0
2020-05-19 09:00:00	SPY	ETF	294.55	294.7	294.04	294.38	422128.0
2020-05-19 09:30:00	SPY	ETF	294.35	294.73	293.52	294.65	8871698.0
2020-05-19 10:00:00	SPY	ETF	294.67	295.88	294.6101	295.0799	7131139.0
2020-05-19 10:30:00	SPY	ETF	295.07	295.43	294.2	295.28	5056744.0
2020-05-19 11:00:00	SPY	ETF	295.27	295.7886	294.93	295.77	3637527.0
2020-05-19 11:30:00	SPY	ETF	295.78	295.9896	295.21	295.46	4009175.0
2020-05-19 12:00:00	SPY	ETF	295.45	295.68	294.89	295.1699	2334964.0
2020-05-19 12:30:00	SPY	ETF	295.17	295.34	294.73	295.215	2506466.0
2020-05-19 13:00:00	SPY	ETF	295.2	295.47	294.95	295.36	1612641.0
2020-05-19 13:30:00	SPY	ETF	295.35	295.68	295.19	295.5	3128104.0
2020-05-19 14:00:00	SPY	ETF	295.49	296.04	295.05	295.71	4211315.0
2020-05-19 14:30:00	SPY	ETF	295.72	296.205	293.73	294.0399	6806154.0
2020-05-19 15:00:00	SPY	ETF	294.05	295.825	293.69	294.81	13851894.0
2020-05-19 15:30:00	SPY	ETF	294.8	294.8	291.95	292.02	15700365.0
2020-05-19 16:00:00	SPY	ETF	292.03	292.39	291.92	292.13	11068734.0
2020-05-19 16:30:00	SPY	ETF	292.11	292.22	291.81	292.14	1578687.0
2020-05-19 17:00:00	SPY	ETF	291.95	292.15	291.8	291.82	447328.0
2020-05-19 17:30:00	SPY	ETF	291.82	291.9	291.6	291.7	187825.0
2020-05-19 18:00:00	SPY	ETF	291.7	292.22	291.29	291.98	315870.0
2020-05-19 18:30:00	SPY	ETF	292.0	292.3	291.37	292.23	247325.0
2020-05-19 19:00:00	SPY	ETF	292.2	292.71	292.2	292.69	171193.0
2020-05-19 19:30:00	SPY	ETF	292.68	292.89	292.44	292.69	136094.0
2020-05-19 04:00:00	QQQ	ETF	228.0	228.32	227.25	227.47	17183.0
2020-05-19 04:30:00	QQQ	ETF	227.24	227.87	227.03	227.83	52133.0
2020-05-19 05:00:00	QQQ	ETF	227.81	227.81	227.27	227.35	6535.0
2020-05-19 05:30:00	QQQ	ETF	227.49	227.72	227.44	227.44	15590.0
2020-05-19 06:00:00	QQQ	ETF	227.2	227.33	226.82	227.05	10660.0
2020-05-19 06:30:00	QQQ	ETF	226.97	227.55	226.95	227.51	13473.0
2020-05-19 07:00:00	QQQ	ETF	227.31	228.07	227.31	227.96	57138.0
2020-05-19 07:30:00	QQQ	ETF	227.93	228.18	227.69	227.7	71467.0
2020-05-19 08:00:00	QQQ	ETF	227.72	228.86	227.31	227.68	62233.0
2020-05-19 08:30:00	QQQ	ETF	227.66	228.03	227.6	227.89	46259.0
2020-05-19 09:00:00	QQQ	ETF	227.9098	227.94	227.56	227.68	144375.0
2020-05-19 09:30:00	QQQ	ETF	227.66	228.93	227.32	228.72	3920282.0
2020-05-19 10:00:00	QQQ	ETF	228.7201	229.3804	228.65	228.985	4819493.0
2020-05-19 10:30:00	QQQ	ETF	228.99	229.35	228.51	229.29	1991411.0
2020-05-19 11:00:00	QQQ	ETF	229.27	229.515	228.98	229.4401	1654301.0
2020-05-19 11:30:00	QQQ	ETF	229.44	229.58	228.81	229.17	1999965.0
2020-05-19 12:00:00	QQQ	ETF	229.21	229.27	228.62	228.9606	1094854.0
2020-05-19 12:30:00	QQQ	ETF	228.96	229.34	228.79	229.29	893471.0

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

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