PREVIEW / etf_30min / 2020-06-17

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-17.parquet
  size:    543 KB
  rows:    20,308

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-17 04:00:00	SPY	ETF	314.87	316.0	314.66	315.66	79542.0
2020-06-17 04:30:00	SPY	ETF	315.67	315.99	315.16	315.39	26473.0
2020-06-17 05:00:00	SPY	ETF	315.54	315.54	314.09	314.44	113049.0
2020-06-17 05:30:00	SPY	ETF	314.37	314.55	313.1	313.65	43752.0
2020-06-17 06:00:00	SPY	ETF	313.8	314.85	313.56	314.74	53275.0
2020-06-17 06:30:00	SPY	ETF	314.8	314.96	314.57	314.94	135350.0
2020-06-17 07:00:00	SPY	ETF	314.9	315.29	314.67	314.95	248985.0
2020-06-17 07:30:00	SPY	ETF	314.91	315.2	314.12	314.48	332569.0
2020-06-17 08:00:00	SPY	ETF	314.9	315.28	311.67	314.6701	602937.0
2020-06-17 08:30:00	SPY	ETF	314.65	314.85	313.88	314.08	296167.0
2020-06-17 09:00:00	SPY	ETF	314.08	314.44	313.81	314.06	223379.0
2020-06-17 09:30:00	SPY	ETF	314.07	314.11	312.0202	312.6567	7384050.0
2020-06-17 10:00:00	SPY	ETF	312.65	313.46	311.39	311.66	10922575.0
2020-06-17 10:30:00	SPY	ETF	311.65	313.38	311.16	312.82	9147628.0
2020-06-17 11:00:00	SPY	ETF	312.81	313.11	311.93	312.35	4484026.0
2020-06-17 11:30:00	SPY	ETF	312.31	313.17	312.15	313.1	3758662.0
2020-06-17 12:00:00	SPY	ETF	313.11	313.1764	312.46	312.88	2597450.0
2020-06-17 12:30:00	SPY	ETF	312.88	313.98	312.84	313.54	2879673.0
2020-06-17 13:00:00	SPY	ETF	313.5484	314.16	313.515	314.0208	3113406.0
2020-06-17 13:30:00	SPY	ETF	314.0	314.39	313.68	313.68	2699958.0
2020-06-17 14:00:00	SPY	ETF	313.68	314.1	313.32	313.71	3570389.0
2020-06-17 14:30:00	SPY	ETF	313.71	314.15	313.02	313.06	3428446.0
2020-06-17 15:00:00	SPY	ETF	313.05	313.055	311.45	311.835	6682632.0
2020-06-17 15:30:00	SPY	ETF	311.84	312.31	310.86	311.56	13378592.0
2020-06-17 16:00:00	SPY	ETF	311.56	312.2	311.5	312.06	4607765.0
2020-06-17 16:30:00	SPY	ETF	312.07	312.45	311.66	312.0	937800.0
2020-06-17 17:00:00	SPY	ETF	312.07	312.07	311.8	311.82	97766.0
2020-06-17 17:30:00	SPY	ETF	311.82	311.87	311.55	311.65	152050.0
2020-06-17 18:00:00	SPY	ETF	311.69	311.85	311.21	311.42	251200.0
2020-06-17 18:30:00	SPY	ETF	311.44	312.18	311.44	311.65	92935.0
2020-06-17 19:00:00	SPY	ETF	311.87	312.05	310.56	310.8	112202.0
2020-06-17 19:30:00	SPY	ETF	310.73	310.91	310.41	310.4501	120810.0
2020-06-17 04:00:00	QQQ	ETF	244.6	245.22	244.47	245.02	70028.0
2020-06-17 04:30:00	QQQ	ETF	245.05	245.18	244.82	245.11	30807.0
2020-06-17 05:00:00	QQQ	ETF	244.98	245.14	244.2	244.37	20446.0
2020-06-17 05:30:00	QQQ	ETF	244.39	244.48	243.76	244.0	17242.0
2020-06-17 06:00:00	QQQ	ETF	244.01	244.74	243.98	244.74	44180.0
2020-06-17 06:30:00	QQQ	ETF	244.75	244.84	244.66	244.79	67048.0
2020-06-17 07:00:00	QQQ	ETF	244.79	244.89	244.5	244.58	64201.0
2020-06-17 07:30:00	QQQ	ETF	244.62	244.88	244.42	244.68	139947.0
2020-06-17 08:00:00	QQQ	ETF	244.7	245.0	242.79	244.5701	148404.0
2020-06-17 08:30:00	QQQ	ETF	244.59	244.67	244.23	244.38	110891.0
2020-06-17 09:00:00	QQQ	ETF	244.45	244.79	244.22	244.37	124319.0
2020-06-17 09:30:00	QQQ	ETF	244.39	244.765	243.4202	243.8801	3695968.0
2020-06-17 10:00:00	QQQ	ETF	243.88	244.19	242.8004	243.26	3201499.0
2020-06-17 10:30:00	QQQ	ETF	243.29	244.465	242.91	244.24	2232878.0
2020-06-17 11:00:00	QQQ	ETF	244.22	244.54	243.685	244.075	2092861.0
2020-06-17 11:30:00	QQQ	ETF	244.07	244.48	243.93	244.44	1886903.0
2020-06-17 12:00:00	QQQ	ETF	244.46	244.54	244.03	244.415	982559.0
2020-06-17 12:30:00	QQQ	ETF	244.41	245.125	244.38	245.06	1708832.0

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

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