PREVIEW / etf_30min / 2020-02-03

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-03.parquet
  size:    559 KB
  rows:    19,803

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-02-03 04:00:00	SPY	ETF	323.5	323.52	323.0	323.19	74946.0
2020-02-03 04:30:00	SPY	ETF	323.01	323.15	322.82	322.98	14473.0
2020-02-03 05:00:00	SPY	ETF	322.84	323.32	322.72	323.29	10604.0
2020-02-03 05:30:00	SPY	ETF	323.22	323.27	323.04	323.13	7635.0
2020-02-03 06:00:00	SPY	ETF	323.22	323.65	323.18	323.27	30549.0
2020-02-03 06:30:00	SPY	ETF	323.24	323.58	323.24	323.39	37911.0
2020-02-03 07:00:00	SPY	ETF	323.35	323.47	323.01	323.24	99769.0
2020-02-03 07:30:00	SPY	ETF	323.32	323.45	323.19	323.32	157183.0
2020-02-03 08:00:00	SPY	ETF	323.31	324.38	321.73	324.07	355338.0
2020-02-03 08:30:00	SPY	ETF	324.06	324.1	323.59	323.66	266696.0
2020-02-03 09:00:00	SPY	ETF	323.63	323.71	323.32	323.37	289821.0
2020-02-03 09:30:00	SPY	ETF	323.35	325.24	323.22	325.16	6956714.0
2020-02-03 10:00:00	SPY	ETF	325.17	326.16	325.01	326.11	7915543.0
2020-02-03 10:30:00	SPY	ETF	326.12	326.155	324.92	325.18	4476482.0
2020-02-03 11:00:00	SPY	ETF	325.19	325.53	324.67	324.69	3743730.0
2020-02-03 11:30:00	SPY	ETF	324.69	324.785	323.72	324.27	6148367.0
2020-02-03 12:00:00	SPY	ETF	324.25	324.7601	323.91	324.56	3881294.0
2020-02-03 12:30:00	SPY	ETF	324.56	324.93	324.33	324.85	1768092.0
2020-02-03 13:00:00	SPY	ETF	324.85	324.92	324.05	324.21	1945165.0
2020-02-03 13:30:00	SPY	ETF	324.22	324.68	324.05	324.62	3029381.0
2020-02-03 14:00:00	SPY	ETF	324.62	324.65	324.02	324.29	2748663.0
2020-02-03 14:30:00	SPY	ETF	324.295	324.74	323.97	324.53	3228924.0
2020-02-03 15:00:00	SPY	ETF	324.52	324.96	324.36	324.95	3739088.0
2020-02-03 15:30:00	SPY	ETF	324.95	325.01	323.9	324.14	9478722.0
2020-02-03 16:00:00	SPY	ETF	324.14	324.2138	321.8814	323.98	6030544.0
2020-02-03 16:30:00	SPY	ETF	324.0	324.12	323.93	324.01	549762.0
2020-02-03 17:00:00	SPY	ETF	324.02	324.02	323.81	323.85	120374.0
2020-02-03 17:30:00	SPY	ETF	323.93	323.98	323.85	323.9	37638.0
2020-02-03 18:00:00	SPY	ETF	323.9	323.9	323.07	323.51	162482.0
2020-02-03 18:30:00	SPY	ETF	323.53	323.83	323.53	323.61	29928.0
2020-02-03 19:00:00	SPY	ETF	323.61	324.21	323.6	324.19	73477.0
2020-02-03 19:30:00	SPY	ETF	324.17	324.21	324.0	324.18	30984.0
2020-02-03 04:00:00	QQQ	ETF	220.42	220.58	220.21	220.23	57724.0
2020-02-03 04:30:00	QQQ	ETF	220.41	220.41	219.99	220.0	21633.0
2020-02-03 05:00:00	QQQ	ETF	219.95	220.17	219.81	220.12	7230.0
2020-02-03 05:30:00	QQQ	ETF	220.03	220.18	219.93	220.09	21954.0
2020-02-03 06:00:00	QQQ	ETF	220.21	220.5	220.1	220.13	30449.0
2020-02-03 06:30:00	QQQ	ETF	220.18	220.39	220.17	220.25	20011.0
2020-02-03 07:00:00	QQQ	ETF	220.24	220.32	219.93	220.18	119744.0
2020-02-03 07:30:00	QQQ	ETF	220.17	220.34	220.12	220.18	65629.0
2020-02-03 08:00:00	QQQ	ETF	220.18	221.23	219.07	220.78	163354.0
2020-02-03 08:30:00	QQQ	ETF	220.78	220.8	220.5	220.53	124999.0
2020-02-03 09:00:00	QQQ	ETF	220.52	220.55	220.04	220.09	167330.0
2020-02-03 09:30:00	QQQ	ETF	220.14	222.2	219.99	222.16	3619496.0
2020-02-03 10:00:00	QQQ	ETF	222.18	222.85	222.0	222.84	2831582.0
2020-02-03 10:30:00	QQQ	ETF	222.85	222.885	222.05	222.27	1535006.0
2020-02-03 11:00:00	QQQ	ETF	222.272	222.67	222.17	222.3077	1187233.0
2020-02-03 11:30:00	QQQ	ETF	222.31	222.38	221.62	221.98	1637263.0
2020-02-03 12:00:00	QQQ	ETF	221.96	222.47	221.8	222.3043	848726.0
2020-02-03 12:30:00	QQQ	ETF	222.3	222.66	222.165	222.56	868793.0

> showing 50 of 19,803 rows — these rows as CSV

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