PREVIEW / etf_30min / 2020-12-22

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-22.parquet
  size:    609 KB
  rows:    22,594

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-22 04:00:00	SPY	ETF	368.05	368.68	368.01	368.28	13029.0
2020-12-22 04:30:00	SPY	ETF	368.27	368.56	368.06	368.13	7161.0
2020-12-22 05:00:00	SPY	ETF	368.02	368.22	367.71	368.12	14234.0
2020-12-22 05:30:00	SPY	ETF	368.15	368.31	367.97	368.09	4039.0
2020-12-22 06:00:00	SPY	ETF	368.32	368.66	368.29	368.6	7521.0
2020-12-22 06:30:00	SPY	ETF	368.45	368.53	368.23	368.4	34517.0
2020-12-22 07:00:00	SPY	ETF	368.4	368.93	368.35	368.86	73795.0
2020-12-22 07:30:00	SPY	ETF	368.85	368.89	368.65	368.65	83600.0
2020-12-22 08:00:00	SPY	ETF	368.3712	368.96	366.02	368.74	142469.0
2020-12-22 08:30:00	SPY	ETF	368.71	368.83	368.39	368.4	59657.0
2020-12-22 09:00:00	SPY	ETF	368.37	368.5	368.1	368.21	175893.0
2020-12-22 09:30:00	SPY	ETF	368.21	368.23	367.21	367.82	4817949.0
2020-12-22 10:00:00	SPY	ETF	367.83	368.15	367.06	367.97	3933286.0
2020-12-22 10:30:00	SPY	ETF	367.98	368.3317	367.38	367.74	3055343.0
2020-12-22 11:00:00	SPY	ETF	367.75	368.08	367.295	367.64	2531789.0
2020-12-22 11:30:00	SPY	ETF	367.65	367.7	366.03	367.055	3398834.0
2020-12-22 12:00:00	SPY	ETF	367.055	367.5211	366.94	367.08	2408087.0
2020-12-22 12:30:00	SPY	ETF	367.072	367.64	367.06	367.47	1401171.0
2020-12-22 13:00:00	SPY	ETF	367.47	367.87	367.42	367.81	1833349.0
2020-12-22 13:30:00	SPY	ETF	367.82	368.25	367.81	368.0	1200803.0
2020-12-22 14:00:00	SPY	ETF	368.01	368.15	367.77	367.9689	2083718.0
2020-12-22 14:30:00	SPY	ETF	367.965	367.97	367.2101	367.565	2298637.0
2020-12-22 15:00:00	SPY	ETF	367.5655	367.67	366.91	366.975	3632206.0
2020-12-22 15:30:00	SPY	ETF	366.97	367.3	366.58	367.22	8538586.0
2020-12-22 16:00:00	SPY	ETF	367.23	367.3	366.84	367.07	3790364.0
2020-12-22 16:30:00	SPY	ETF	367.07	367.2	366.94	366.94	77128.0
2020-12-22 17:00:00	SPY	ETF	366.99	367.07	366.93	366.96	7198.0
2020-12-22 17:30:00	SPY	ETF	366.96	367.01	366.93	367.0	5566.0
2020-12-22 18:00:00	SPY	ETF	366.96	367.24	366.88	367.23	29277.0
2020-12-22 18:30:00	SPY	ETF	367.23	367.7	367.1	367.69	48333.0
2020-12-22 19:00:00	SPY	ETF	367.65	367.81	366.7	366.7	92060.0
2020-12-22 19:30:00	SPY	ETF	366.73	366.73	364.55	365.22	293698.0
2020-12-22 04:00:00	QQQ	ETF	309.6	310.27	309.57	309.92	14985.0
2020-12-22 04:30:00	QQQ	ETF	309.94	310.13	309.82	309.92	2200.0
2020-12-22 05:00:00	QQQ	ETF	309.98	310.06	309.92	309.98	3266.0
2020-12-22 05:30:00	QQQ	ETF	309.99	310.1	309.86	310.02	5748.0
2020-12-22 06:00:00	QQQ	ETF	310.1	310.22	310.08	310.22	1000.0
2020-12-22 06:30:00	QQQ	ETF	310.22	310.22	309.97	310.01	29691.0
2020-12-22 07:00:00	QQQ	ETF	310.03	310.74	310.03	310.62	44550.0
2020-12-22 07:30:00	QQQ	ETF	310.66	310.79	310.55	310.55	104662.0
2020-12-22 08:00:00	QQQ	ETF	310.17	310.87	308.2	310.59	78148.0
2020-12-22 08:30:00	QQQ	ETF	310.6	310.64	308.92	310.44	161386.0
2020-12-22 09:00:00	QQQ	ETF	310.45	310.45	309.89	309.94	107618.0
2020-12-22 09:30:00	QQQ	ETF	309.85	310.7105	308.88	310.605	2577342.0
2020-12-22 10:00:00	QQQ	ETF	310.6	310.61	309.14	309.5759	2152603.0
2020-12-22 10:30:00	QQQ	ETF	309.57	310.2787	308.96	309.45	1366019.0
2020-12-22 11:00:00	QQQ	ETF	309.457	309.5	308.51	308.99	1401755.0
2020-12-22 11:30:00	QQQ	ETF	308.9901	308.9901	306.845	308.33	2630458.0
2020-12-22 12:00:00	QQQ	ETF	308.33	308.92	308.25	308.48	1240986.0
2020-12-22 12:30:00	QQQ	ETF	308.48	309.06	308.46	308.83	794513.0

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

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