PREVIEW / etf_30min / 2020-06-22

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-22.parquet
  size:    544 KB
  rows:    20,396

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-22 04:00:00	SPY	ETF	308.5	308.64	308.03	308.27	54245.0
2020-06-22 04:30:00	SPY	ETF	308.22	309.36	308.22	309.15	61135.0
2020-06-22 05:00:00	SPY	ETF	309.27	309.79	309.27	309.68	51998.0
2020-06-22 05:30:00	SPY	ETF	309.51	309.59	308.95	309.01	34183.0
2020-06-22 06:00:00	SPY	ETF	308.96	308.99	308.44	308.48	31404.0
2020-06-22 06:30:00	SPY	ETF	308.56	308.74	308.22	308.44	65975.0
2020-06-22 07:00:00	SPY	ETF	308.43	308.48	307.55	307.73	212280.0
2020-06-22 07:30:00	SPY	ETF	307.74	308.46	307.69	308.46	182337.0
2020-06-22 08:00:00	SPY	ETF	308.46	309.45	306.1	308.67	438227.0
2020-06-22 08:30:00	SPY	ETF	308.64	308.67	307.9	308.26	734808.0
2020-06-22 09:00:00	SPY	ETF	308.2	308.48	307.62	307.95	661161.0
2020-06-22 09:30:00	SPY	ETF	307.99	308.67	306.75	308.51	8745545.0
2020-06-22 10:00:00	SPY	ETF	308.515	309.67	308.3	309.37	5395223.0
2020-06-22 10:30:00	SPY	ETF	309.38	309.45	308.15	308.16	5022726.0
2020-06-22 11:00:00	SPY	ETF	308.16	309.2	307.85	309.06	5659944.0
2020-06-22 11:30:00	SPY	ETF	309.055	309.46	308.7301	309.1001	3245340.0
2020-06-22 12:00:00	SPY	ETF	309.11	310.47	309.1016	310.25	5147652.0
2020-06-22 12:30:00	SPY	ETF	310.2587	310.81	310.01	310.495	3194787.0
2020-06-22 13:00:00	SPY	ETF	310.505	310.81	310.21	310.27	2160091.0
2020-06-22 13:30:00	SPY	ETF	310.2683	310.623	309.96	310.45	2165699.0
2020-06-22 14:00:00	SPY	ETF	310.46	310.47	309.72	310.31	3023812.0
2020-06-22 14:30:00	SPY	ETF	310.3199	311.04	310.23	310.955	2991737.0
2020-06-22 15:00:00	SPY	ETF	310.95	311.05	309.3	309.685	7482773.0
2020-06-22 15:30:00	SPY	ETF	309.7	310.84	309.68	310.68	9872913.0
2020-06-22 16:00:00	SPY	ETF	310.71	311.4	310.149	311.4	4950547.0
2020-06-22 16:30:00	SPY	ETF	311.37	311.5	310.62	311.12	845952.0
2020-06-22 17:00:00	SPY	ETF	311.02	311.22	310.62	311.15	271520.0
2020-06-22 17:30:00	SPY	ETF	311.15	311.27	310.62	311.2	69466.0
2020-06-22 18:00:00	SPY	ETF	311.21	311.62	311.15	311.53	157505.0
2020-06-22 18:30:00	SPY	ETF	311.56	312.0	310.94	311.94	215368.0
2020-06-22 19:00:00	SPY	ETF	311.9	312.48	311.85	312.28	77901.0
2020-06-22 19:30:00	SPY	ETF	312.3	312.56	312.26	312.3299	191033.0
2020-06-22 04:00:00	QQQ	ETF	244.1	244.12	243.76	243.76	35324.0
2020-06-22 04:30:00	QQQ	ETF	243.95	244.4	243.95	244.26	10316.0
2020-06-22 05:00:00	QQQ	ETF	244.31	244.86	244.31	244.65	14218.0
2020-06-22 05:30:00	QQQ	ETF	244.66	244.69	244.25	244.37	8920.0
2020-06-22 06:00:00	QQQ	ETF	244.35	244.41	244.05	244.11	12203.0
2020-06-22 06:30:00	QQQ	ETF	244.17	244.24	243.86	244.02	9369.0
2020-06-22 07:00:00	QQQ	ETF	244.0	244.0	243.561	243.73	104671.0
2020-06-22 07:30:00	QQQ	ETF	243.75	244.35	243.75	244.35	99887.0
2020-06-22 08:00:00	QQQ	ETF	243.7601	244.5	242.75	244.27	89912.0
2020-06-22 08:30:00	QQQ	ETF	244.25	244.29	243.86	243.93	69259.0
2020-06-22 09:00:00	QQQ	ETF	243.92	244.07	243.77	243.77	104696.0
2020-06-22 09:30:00	QQQ	ETF	243.77	244.455	243.38	244.455	3378938.0
2020-06-22 10:00:00	QQQ	ETF	244.46	245.28	244.46	245.08	1768554.0
2020-06-22 10:30:00	QQQ	ETF	245.11	245.35	244.47	244.51	1193163.0
2020-06-22 11:00:00	QQQ	ETF	244.5	245.2889	244.27	245.15	1119984.0
2020-06-22 11:30:00	QQQ	ETF	245.16	245.61	244.96	245.371	867659.0
2020-06-22 12:00:00	QQQ	ETF	245.37	246.17	245.36	246.13	1369447.0
2020-06-22 12:30:00	QQQ	ETF	246.14	246.49	246.04	246.235	1276149.0

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

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