PREVIEW / etf_30min / 2020-06-23

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-23.parquet
  size:    551 KB
  rows:    20,729

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-23 04:00:00	SPY	ETF	313.37	313.51	312.96	313.26	28740.0
2020-06-23 04:30:00	SPY	ETF	313.29	313.33	312.75	312.89	10586.0
2020-06-23 05:00:00	SPY	ETF	312.74	312.89	312.66	312.85	7751.0
2020-06-23 05:30:00	SPY	ETF	313.0	313.51	313.0	313.22	23387.0
2020-06-23 06:00:00	SPY	ETF	313.31	313.96	313.15	313.73	22549.0
2020-06-23 06:30:00	SPY	ETF	313.75	313.8	313.36	313.47	59117.0
2020-06-23 07:00:00	SPY	ETF	313.61	313.84	313.19	313.7	116926.0
2020-06-23 07:30:00	SPY	ETF	313.72	313.9	313.62	313.79	108157.0
2020-06-23 08:00:00	SPY	ETF	313.3398	314.57	309.91	314.47	335501.0
2020-06-23 08:30:00	SPY	ETF	314.41	314.5	314.13	314.22	245044.0
2020-06-23 09:00:00	SPY	ETF	314.2	314.36	313.4	313.47	453137.0
2020-06-23 09:30:00	SPY	ETF	313.49	313.84	312.62	312.98	6317799.0
2020-06-23 10:00:00	SPY	ETF	312.965	313.57	312.301	313.56	4764607.0
2020-06-23 10:30:00	SPY	ETF	313.56	313.65	312.11	312.78	4455275.0
2020-06-23 11:00:00	SPY	ETF	312.77	314.18	312.38	313.99	3902914.0
2020-06-23 11:30:00	SPY	ETF	313.9999	314.04	313.14	313.82	2870664.0
2020-06-23 12:00:00	SPY	ETF	313.83	314.03	313.4201	313.735	3358857.0
2020-06-23 12:30:00	SPY	ETF	313.74	313.9	313.4	313.67	1885332.0
2020-06-23 13:00:00	SPY	ETF	313.67	314.36	313.644	314.22	2151844.0
2020-06-23 13:30:00	SPY	ETF	314.23	314.5	313.5	314.18	3416839.0
2020-06-23 14:00:00	SPY	ETF	314.195	314.195	313.4	313.86	3067950.0
2020-06-23 14:30:00	SPY	ETF	313.85	314.1	313.11	313.3577	2558969.0
2020-06-23 15:00:00	SPY	ETF	313.36	313.61	312.63	312.72	5883925.0
2020-06-23 15:30:00	SPY	ETF	312.7	313.08	311.6101	312.03	14931063.0
2020-06-23 16:00:00	SPY	ETF	312.02	313.2132	311.7	311.8	5918376.0
2020-06-23 16:30:00	SPY	ETF	311.76	312.05	311.19	311.31	325393.0
2020-06-23 17:00:00	SPY	ETF	311.3	311.45	311.17	311.38	53955.0
2020-06-23 17:30:00	SPY	ETF	311.37	311.49	311.23	311.49	50416.0
2020-06-23 18:00:00	SPY	ETF	311.4	311.91	311.2	311.68	132759.0
2020-06-23 18:30:00	SPY	ETF	311.81	311.81	310.9	310.98	86605.0
2020-06-23 19:00:00	SPY	ETF	310.92	311.5	310.76	311.28	97102.0
2020-06-23 19:30:00	SPY	ETF	311.28	311.69	311.13	311.2	87226.0
2020-06-23 04:00:00	QQQ	ETF	248.66	248.78	248.35	248.5	52156.0
2020-06-23 04:30:00	QQQ	ETF	248.35	248.52	248.13	248.23	10200.0
2020-06-23 05:00:00	QQQ	ETF	248.15	248.26	248.11	248.26	3040.0
2020-06-23 05:30:00	QQQ	ETF	248.32	248.63	248.31	248.56	14677.0
2020-06-23 06:00:00	QQQ	ETF	248.5	248.91	248.5	248.82	55876.0
2020-06-23 06:30:00	QQQ	ETF	248.63	248.7	248.51	248.53	10608.0
2020-06-23 07:00:00	QQQ	ETF	248.55	248.89	248.33	248.76	72243.0
2020-06-23 07:30:00	QQQ	ETF	248.83	248.87	248.53	248.65	54534.0
2020-06-23 08:00:00	QQQ	ETF	248.61	248.8696	246.5	248.79	122894.0
2020-06-23 08:30:00	QQQ	ETF	248.77	248.78	246.74	248.6506	699467.0
2020-06-23 09:00:00	QQQ	ETF	248.6799	248.8	248.36	248.39	145350.0
2020-06-23 09:30:00	QQQ	ETF	248.39	248.84	247.82	248.44	3001078.0
2020-06-23 10:00:00	QQQ	ETF	248.43	249.24	247.96	249.24	2071052.0
2020-06-23 10:30:00	QQQ	ETF	249.24	249.5962	248.73	249.154	1967159.0
2020-06-23 11:00:00	QQQ	ETF	249.13	250.16	248.85	250.14	1648338.0
2020-06-23 11:30:00	QQQ	ETF	250.13	250.29	249.82	250.29	1401667.0
2020-06-23 12:00:00	QQQ	ETF	250.3	250.48	250.0	250.36	1245370.0
2020-06-23 12:30:00	QQQ	ETF	250.36	250.49	250.09	250.34	1272408.0

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

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