PREVIEW / etf_30min / 2020-06-03

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-03.parquet
  size:    575 KB
  rows:    21,519

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-03 04:00:00	SPY	ETF	309.25	309.35	308.84	309.13	15225.0
2020-06-03 04:30:00	SPY	ETF	309.13	309.41	309.03	309.36	14940.0
2020-06-03 05:00:00	SPY	ETF	309.17	309.54	309.17	309.46	16735.0
2020-06-03 05:30:00	SPY	ETF	309.74	309.81	309.51	309.65	33523.0
2020-06-03 06:00:00	SPY	ETF	309.65	309.68	309.14	309.5	31052.0
2020-06-03 06:30:00	SPY	ETF	309.58	309.58	309.0	309.19	31354.0
2020-06-03 07:00:00	SPY	ETF	309.14	309.45	309.08	309.24	120114.0
2020-06-03 07:30:00	SPY	ETF	309.24	309.69	309.02	309.48	126961.0
2020-06-03 08:00:00	SPY	ETF	309.2145	310.0	308.75	309.74	374379.0
2020-06-03 08:30:00	SPY	ETF	309.75	310.18	309.69	309.9599	522468.0
2020-06-03 09:00:00	SPY	ETF	309.94	310.46	309.85	310.24	621106.0
2020-06-03 09:30:00	SPY	ETF	310.24	310.86	309.94	310.57	10658668.0
2020-06-03 10:00:00	SPY	ETF	310.58	310.97	310.45	310.92	5202579.0
2020-06-03 10:30:00	SPY	ETF	310.91	311.36	310.7733	311.01	5295745.0
2020-06-03 11:00:00	SPY	ETF	311.01	311.96	310.97	311.655	5102857.0
2020-06-03 11:30:00	SPY	ETF	311.66	312.06	311.51	311.72	4479828.0
2020-06-03 12:00:00	SPY	ETF	311.72	311.74	311.22	311.55	4606373.0
2020-06-03 12:30:00	SPY	ETF	311.55	311.7195	311.19	311.215	2967277.0
2020-06-03 13:00:00	SPY	ETF	311.23	311.66	311.13	311.55	3186335.0
2020-06-03 13:30:00	SPY	ETF	311.565	311.67	311.19	311.36	2593827.0
2020-06-03 14:00:00	SPY	ETF	311.36	312.16	311.3	312.03	4004644.0
2020-06-03 14:30:00	SPY	ETF	312.03	312.38	311.845	312.13	6084345.0
2020-06-03 15:00:00	SPY	ETF	312.13	312.69	311.93	312.595	6749652.0
2020-06-03 15:30:00	SPY	ETF	312.6	313.22	312.04	312.2117	18291683.0
2020-06-03 16:00:00	SPY	ETF	312.22	312.2854	311.86	312.1	7851287.0
2020-06-03 16:30:00	SPY	ETF	312.1	312.2854	312.0	312.1	1308942.0
2020-06-03 17:00:00	SPY	ETF	312.03	312.28	312.03	312.16	556385.0
2020-06-03 17:30:00	SPY	ETF	312.15	312.19	312.1	312.12	35015.0
2020-06-03 18:00:00	SPY	ETF	312.12	312.2853	311.55	311.65	273287.0
2020-06-03 18:30:00	SPY	ETF	311.69	312.09	311.68	312.02	73493.0
2020-06-03 19:00:00	SPY	ETF	312.03	312.54	312.03	312.49	94999.0
2020-06-03 19:30:00	SPY	ETF	312.5	312.95	312.47	312.65	373792.0
2020-06-03 04:00:00	QQQ	ETF	236.25	236.35	235.94	236.14	8910.0
2020-06-03 04:30:00	QQQ	ETF	236.14	236.26	236.0	236.26	8050.0
2020-06-03 05:00:00	QQQ	ETF	236.2	236.32	236.2	236.26	1700.0
2020-06-03 05:30:00	QQQ	ETF	236.47	236.6	236.4	236.49	23073.0
2020-06-03 06:00:00	QQQ	ETF	236.41	236.41	236.18	236.3	11957.0
2020-06-03 06:30:00	QQQ	ETF	236.33	236.37	235.99	236.35	12750.0
2020-06-03 07:00:00	QQQ	ETF	236.11	236.34	236.04	236.2	28966.0
2020-06-03 07:30:00	QQQ	ETF	236.07	236.43	235.96	236.3	138263.0
2020-06-03 08:00:00	QQQ	ETF	236.1801	236.6	236.0	236.22	134008.0
2020-06-03 08:30:00	QQQ	ETF	236.25	236.25	235.54	235.82	220223.0
2020-06-03 09:00:00	QQQ	ETF	235.88	236.38	235.74	236.22	172175.0
2020-06-03 09:30:00	QQQ	ETF	236.22	236.73	235.56	236.69	4425788.0
2020-06-03 10:00:00	QQQ	ETF	236.7	236.85	235.81	236.19	2638120.0
2020-06-03 10:30:00	QQQ	ETF	236.2	236.62	235.97	236.25	1816606.0
2020-06-03 11:00:00	QQQ	ETF	236.23	236.65	236.1	236.369	1514630.0
2020-06-03 11:30:00	QQQ	ETF	236.37	236.41	235.835	236.1601	1801044.0
2020-06-03 12:00:00	QQQ	ETF	236.16	236.19	235.35	235.82	3073846.0
2020-06-03 12:30:00	QQQ	ETF	235.83	236.19	235.82	235.8611	3587466.0

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

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