PREVIEW / etf_30min / 2020-05-26

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-05-26.parquet
  size:    562 KB
  rows:    21,192

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-26 04:00:00	SPY	ETF	300.51	301.25	300.51	301.15	115355.0
2020-05-26 04:30:00	SPY	ETF	301.14	301.48	300.84	301.4	29843.0
2020-05-26 05:00:00	SPY	ETF	301.4	301.79	301.34	301.77	49025.0
2020-05-26 05:30:00	SPY	ETF	301.7	301.7	301.24	301.3	38723.0
2020-05-26 06:00:00	SPY	ETF	301.33	301.33	301.0	301.24	72486.0
2020-05-26 06:30:00	SPY	ETF	301.39	301.55	301.06	301.15	123563.0
2020-05-26 07:00:00	SPY	ETF	301.11	301.24	300.86	300.97	222072.0
2020-05-26 07:30:00	SPY	ETF	301.0	301.36	300.75	301.03	325594.0
2020-05-26 08:00:00	SPY	ETF	301.03	301.68	300.11	301.2604	368445.0
2020-05-26 08:30:00	SPY	ETF	301.29	301.8	301.06	301.7804	523554.0
2020-05-26 09:00:00	SPY	ETF	301.79	302.26	301.75	301.96	855734.0
2020-05-26 09:30:00	SPY	ETF	301.93	302.19	300.66	300.84	10028571.0
2020-05-26 10:00:00	SPY	ETF	300.83	301.39	300.37	301.36	6866641.0
2020-05-26 10:30:00	SPY	ETF	301.353	301.54	300.84	301.3	5587944.0
2020-05-26 11:00:00	SPY	ETF	301.29	301.58	300.35	300.865	6383932.0
2020-05-26 11:30:00	SPY	ETF	300.865	300.88	299.9	300.4117	5021886.0
2020-05-26 12:00:00	SPY	ETF	300.42	300.71	300.08	300.37	4369347.0
2020-05-26 12:30:00	SPY	ETF	300.365	301.08	300.36	301.03	3556910.0
2020-05-26 13:00:00	SPY	ETF	301.035	301.47	300.8894	301.4201	5506846.0
2020-05-26 13:30:00	SPY	ETF	301.42	301.47	301.09	301.1101	2146313.0
2020-05-26 14:00:00	SPY	ETF	301.14	301.45	301.02	301.2415	2397818.0
2020-05-26 14:30:00	SPY	ETF	301.25	301.335	300.74	301.04	3009545.0
2020-05-26 15:00:00	SPY	ETF	301.035	301.08	300.52	300.7001	4516362.0
2020-05-26 15:30:00	SPY	ETF	300.72	300.93	298.69	299.15	20889066.0
2020-05-26 16:00:00	SPY	ETF	299.14	299.91	298.9666	299.88	4383267.0
2020-05-26 16:30:00	SPY	ETF	299.86	299.97	299.08	299.8	494776.0
2020-05-26 17:00:00	SPY	ETF	299.75	299.75	299.62	299.66	65126.0
2020-05-26 17:30:00	SPY	ETF	299.66	299.85	299.66	299.77	35065.0
2020-05-26 18:00:00	SPY	ETF	299.73	299.73	299.08	299.29	162513.0
2020-05-26 18:30:00	SPY	ETF	299.29	299.73	299.21	299.65	72175.0
2020-05-26 19:00:00	SPY	ETF	299.64	299.73	299.24	299.3	64875.0
2020-05-26 19:30:00	SPY	ETF	299.28	299.47	299.16	299.39	44981.0
2020-05-26 04:00:00	QQQ	ETF	233.35	234.14	233.35	233.84	36386.0
2020-05-26 04:30:00	QQQ	ETF	233.74	234.0	233.61	233.98	11752.0
2020-05-26 05:00:00	QQQ	ETF	233.97	234.31	233.94	234.06	14299.0
2020-05-26 05:30:00	QQQ	ETF	234.07	234.07	233.79	233.79	8385.0
2020-05-26 06:00:00	QQQ	ETF	233.88	233.88	233.63	233.87	71009.0
2020-05-26 06:30:00	QQQ	ETF	233.95	234.02	233.56	233.64	101699.0
2020-05-26 07:00:00	QQQ	ETF	233.62	233.63	233.2	233.35	80218.0
2020-05-26 07:30:00	QQQ	ETF	233.25	233.42	233.15	233.24	130341.0
2020-05-26 08:00:00	QQQ	ETF	230.63	234.2	230.63	233.13	224797.0
2020-05-26 08:30:00	QQQ	ETF	233.05	233.27	232.7902	233.13	109179.0
2020-05-26 09:00:00	QQQ	ETF	233.07	233.53	233.0	233.32	281209.0
2020-05-26 09:30:00	QQQ	ETF	233.31	233.57	231.45	231.83	4265822.0
2020-05-26 10:00:00	QQQ	ETF	231.81	232.49	231.75	232.45	2225783.0
2020-05-26 10:30:00	QQQ	ETF	232.4301	232.48	231.355	231.911	1874530.0
2020-05-26 11:00:00	QQQ	ETF	231.94	232.17	230.69	231.0	2675071.0
2020-05-26 11:30:00	QQQ	ETF	231.0	231.0	229.74	230.51	2165333.0
2020-05-26 12:00:00	QQQ	ETF	230.54	230.97	230.42	230.7	1335049.0
2020-05-26 12:30:00	QQQ	ETF	230.71	231.31	230.7	231.14	1558409.0

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

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