PREVIEW / etf_30min / 2021-06-14

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-06-14.parquet
  size:    607 KB
  rows:    23,277

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
2021-06-14 04:00:00	SPY	ETF	424.65	424.66	424.48	424.48	2795.0
2021-06-14 04:30:00	SPY	ETF	424.71	424.75	424.7	424.75	391.0
2021-06-14 05:00:00	SPY	ETF	424.72	424.72	424.5	424.5	1503.0
2021-06-14 05:30:00	SPY	ETF	424.62	424.79	424.59	424.79	21337.0
2021-06-14 06:00:00	SPY	ETF	424.79	424.81	424.59	424.59	4311.0
2021-06-14 06:30:00	SPY	ETF	424.77	424.81	424.67	424.74	23968.0
2021-06-14 07:00:00	SPY	ETF	424.61	424.83	424.3	424.33	27221.0
2021-06-14 07:30:00	SPY	ETF	424.36	424.56	424.26	424.34	19384.0
2021-06-14 08:00:00	SPY	ETF	424.7999	424.88	424.3	424.45	50477.0
2021-06-14 08:30:00	SPY	ETF	424.46	424.55	424.0	424.26	176658.0
2021-06-14 09:00:00	SPY	ETF	424.24	424.44	424.19	424.41	81610.0
2021-06-14 09:30:00	SPY	ETF	424.43	424.45	423.6899	423.925	2979604.0
2021-06-14 10:00:00	SPY	ETF	423.93	424.01	423.35	423.54	2039452.0
2021-06-14 10:30:00	SPY	ETF	423.535	423.79	423.23	423.74	2242950.0
2021-06-14 11:00:00	SPY	ETF	423.74	423.99	423.39	423.495	1550301.0
2021-06-14 11:30:00	SPY	ETF	423.4959	423.55	423.22	423.4182	1526742.0
2021-06-14 12:00:00	SPY	ETF	423.4181	423.6	423.33	423.395	1139586.0
2021-06-14 12:30:00	SPY	ETF	423.395	423.4	423.11	423.165	1391372.0
2021-06-14 13:00:00	SPY	ETF	423.17	423.41	423.1	423.4	925878.0
2021-06-14 13:30:00	SPY	ETF	423.39	423.52	423.25	423.325	1078667.0
2021-06-14 14:00:00	SPY	ETF	423.33	423.4	423.18	423.1899	1260517.0
2021-06-14 14:30:00	SPY	ETF	423.19	423.5993	423.16	423.54	1580404.0
2021-06-14 15:00:00	SPY	ETF	423.54	423.74	423.42	423.729	2469009.0
2021-06-14 15:30:00	SPY	ETF	423.725	425.29	423.69	425.29	7596737.0
2021-06-14 16:00:00	SPY	ETF	425.28	425.47	425.09	425.29	4061571.0
2021-06-14 16:30:00	SPY	ETF	425.29	425.3	425.13	425.23	377028.0
2021-06-14 17:00:00	SPY	ETF	425.21	425.28	425.17	425.28	97807.0
2021-06-14 17:30:00	SPY	ETF	425.28	425.34	425.25	425.28	43085.0
2021-06-14 18:00:00	SPY	ETF	425.28	425.28	424.97	425.05	130776.0
2021-06-14 18:30:00	SPY	ETF	425.26	425.26	425.06	425.07	6146.0
2021-06-14 19:00:00	SPY	ETF	425.09	425.2	425.09	425.17	3699.0
2021-06-14 19:30:00	SPY	ETF	425.19	425.29	425.07	425.1	27975.0
2021-06-14 04:00:00	QQQ	ETF	341.48	341.9	341.3	341.85	14541.0
2021-06-14 04:30:00	QQQ	ETF	341.91	342.05	341.87	342.05	5930.0
2021-06-14 05:00:00	QQQ	ETF	341.99	342.13	341.99	342.0	5733.0
2021-06-14 05:30:00	QQQ	ETF	341.95	342.09	341.95	342.08	1600.0
2021-06-14 06:00:00	QQQ	ETF	342.1	342.1	342.0	342.06	8690.0
2021-06-14 06:30:00	QQQ	ETF	342.15	342.44	342.05	342.34	33961.0
2021-06-14 07:00:00	QQQ	ETF	342.36	342.57	342.16	342.16	95063.0
2021-06-14 07:30:00	QQQ	ETF	342.2	342.35	342.08	342.24	14780.0
2021-06-14 08:00:00	QQQ	ETF	342.3604	342.5499	341.8	342.0	77659.0
2021-06-14 08:30:00	QQQ	ETF	342.02	342.06	341.62	341.78	78260.0
2021-06-14 09:00:00	QQQ	ETF	341.78	341.79	341.5	341.69	102315.0
2021-06-14 09:30:00	QQQ	ETF	341.68	342.44	340.46	342.0488	3858645.0
2021-06-14 10:00:00	QQQ	ETF	342.08	342.14	341.06	341.48	1960671.0
2021-06-14 10:30:00	QQQ	ETF	341.48	341.88	341.08	341.83	1156294.0
2021-06-14 11:00:00	QQQ	ETF	341.87	342.27	341.7	342.265	1132405.0
2021-06-14 11:30:00	QQQ	ETF	342.27	342.4	341.92	342.32	1136203.0
2021-06-14 12:00:00	QQQ	ETF	342.33	342.83	342.235	342.5278	1193230.0
2021-06-14 12:30:00	QQQ	ETF	342.5297	342.5401	342.335	342.5	816077.0

> showing 50 of 23,277 rows — these rows as CSV

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