PREVIEW / etf_30min / 2020-12-23

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-23.parquet
  size:    590 KB
  rows:    22,225

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-12-23 04:00:00	SPY	ETF	367.82	368.15	367.82	367.92	36503.0
2020-12-23 04:30:00	SPY	ETF	368.06	368.19	368.01	368.14	11067.0
2020-12-23 05:00:00	SPY	ETF	368.12	368.42	368.12	368.26	6048.0
2020-12-23 05:30:00	SPY	ETF	368.35	368.4	368.24	368.39	6400.0
2020-12-23 06:00:00	SPY	ETF	368.22	368.26	368.15	368.15	3087.0
2020-12-23 06:30:00	SPY	ETF	368.15	368.16	367.97	368.0	30106.0
2020-12-23 07:00:00	SPY	ETF	368.0	368.0	367.61	367.66	126629.0
2020-12-23 07:30:00	SPY	ETF	367.65	367.84	367.65	367.8	68552.0
2020-12-23 08:00:00	SPY	ETF	367.7999	368.2104	366.38	367.9	92777.0
2020-12-23 08:30:00	SPY	ETF	367.91	368.37	367.7	368.2	177057.0
2020-12-23 09:00:00	SPY	ETF	368.13	368.41	368.04	368.31	209280.0
2020-12-23 09:30:00	SPY	ETF	368.28	369.21	368.25	368.98	5863478.0
2020-12-23 10:00:00	SPY	ETF	368.97	369.14	368.29	368.5	3241303.0
2020-12-23 10:30:00	SPY	ETF	368.505	368.89	368.42	368.78	1886454.0
2020-12-23 11:00:00	SPY	ETF	368.77	369.12	368.67	368.77	2465128.0
2020-12-23 11:30:00	SPY	ETF	368.78	369.12	368.66	369.1	1295614.0
2020-12-23 12:00:00	SPY	ETF	369.1	369.3	368.97	369.065	1181113.0
2020-12-23 12:30:00	SPY	ETF	369.06	369.4	369.06	369.3	1803676.0
2020-12-23 13:00:00	SPY	ETF	369.2909	369.53	369.26	369.445	1359215.0
2020-12-23 13:30:00	SPY	ETF	369.445	369.62	369.3419	369.38	1318935.0
2020-12-23 14:00:00	SPY	ETF	369.39	369.53	369.01	369.045	1806717.0
2020-12-23 14:30:00	SPY	ETF	369.04	369.31	368.87	368.905	1642662.0
2020-12-23 15:00:00	SPY	ETF	368.904	369.13	368.74	368.77	2186006.0
2020-12-23 15:30:00	SPY	ETF	368.78	369.1	367.39	367.53	11302669.0
2020-12-23 16:00:00	SPY	ETF	367.53	367.82	366.92	367.4	5239358.0
2020-12-23 16:30:00	SPY	ETF	367.4	367.97	367.15	367.88	389927.0
2020-12-23 17:00:00	SPY	ETF	367.81	367.84	367.57	367.7	1153325.0
2020-12-23 17:30:00	SPY	ETF	367.7	367.85	367.67	367.85	37461.0
2020-12-23 18:00:00	SPY	ETF	367.86	368.01	367.71	367.91	89784.0
2020-12-23 18:30:00	SPY	ETF	367.87	367.92	367.52	367.8	34065.0
2020-12-23 19:00:00	SPY	ETF	367.77	368.07	367.58	367.66	33434.0
2020-12-23 19:30:00	SPY	ETF	367.7	367.84	367.65	367.76	25739.0
2020-12-23 04:00:00	QQQ	ETF	310.04	310.2	310.04	310.11	21513.0
2020-12-23 04:30:00	QQQ	ETF	310.13	310.3	310.13	310.29	5706.0
2020-12-23 05:00:00	QQQ	ETF	310.3	310.38	310.28	310.28	4181.0
2020-12-23 05:30:00	QQQ	ETF	310.29	310.34	310.2	310.25	2150.0
2020-12-23 06:00:00	QQQ	ETF	310.23	310.23	310.09	310.12	6250.0
2020-12-23 06:30:00	QQQ	ETF	310.11	310.12	309.82	309.9	3900.0
2020-12-23 07:00:00	QQQ	ETF	309.87	309.87	309.61	309.7	34484.0
2020-12-23 07:30:00	QQQ	ETF	309.7	310.0	309.7	309.81	58417.0
2020-12-23 08:00:00	QQQ	ETF	309.7302	310.25	309.6102	309.81	70868.0
2020-12-23 08:30:00	QQQ	ETF	309.79	310.25	309.69	309.99	129238.0
2020-12-23 09:00:00	QQQ	ETF	309.76	310.07	309.68	309.8	325670.0
2020-12-23 09:30:00	QQQ	ETF	309.81	310.0	308.19	309.17	2910441.0
2020-12-23 10:00:00	QQQ	ETF	309.17	309.46	308.69	309.03	1685144.0
2020-12-23 10:30:00	QQQ	ETF	309.05	309.56	308.67	309.12	938435.0
2020-12-23 11:00:00	QQQ	ETF	309.13	309.39	308.59	308.77	995041.0
2020-12-23 11:30:00	QQQ	ETF	308.78	309.37	308.63	309.355	645234.0
2020-12-23 12:00:00	QQQ	ETF	309.35	309.52	309.03	309.52	455207.0
2020-12-23 12:30:00	QQQ	ETF	309.51	309.75	309.4	309.7	446714.0

> showing 50 of 22,225 rows — these rows as CSV

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