PREVIEW / etf_30min / 2020-12-24

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-24.parquet
  size:    366 KB
  rows:    12,770

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-24 04:00:00	SPY	ETF	368.36	368.58	368.36	368.57	5708.0
2020-12-24 04:30:00	SPY	ETF	368.57	368.57	368.51	368.51	1795.0
2020-12-24 05:00:00	SPY	ETF	368.64	368.64	368.56	368.56	1201.0
2020-12-24 05:30:00	SPY	ETF	368.58	368.61	368.57	368.59	3990.0
2020-12-24 06:00:00	SPY	ETF	368.56	368.57	368.35	368.35	4976.0
2020-12-24 06:30:00	SPY	ETF	368.36	368.47	368.36	368.46	12393.0
2020-12-24 07:00:00	SPY	ETF	368.44	368.44	368.27	368.28	21966.0
2020-12-24 07:30:00	SPY	ETF	368.33	368.33	367.93	368.19	19730.0
2020-12-24 08:00:00	SPY	ETF	368.29	368.38	367.97	368.22	113110.0
2020-12-24 08:30:00	SPY	ETF	368.18	368.25	368.03	368.16	29117.0
2020-12-24 09:00:00	SPY	ETF	368.15	368.18	367.96	368.04	70056.0
2020-12-24 09:30:00	SPY	ETF	368.08	368.56	367.97	368.4	2679519.0
2020-12-24 10:00:00	SPY	ETF	368.41	368.69	368.25	368.6009	1813834.0
2020-12-24 10:30:00	SPY	ETF	368.605	368.72	368.15	368.19	1512576.0
2020-12-24 11:00:00	SPY	ETF	368.19	368.54	367.96	367.98	2712708.0
2020-12-24 11:30:00	SPY	ETF	367.9899	368.15	367.625	367.87	2319877.0
2020-12-24 12:00:00	SPY	ETF	367.88	368.21	367.45	368.19	2568752.0
2020-12-24 12:30:00	SPY	ETF	368.21	369.01	368.16	368.9899	6807531.0
2020-12-24 13:00:00	SPY	ETF	368.97	369.03	368.6256	368.85	2386048.0
2020-12-24 13:30:00	SPY	ETF	368.87	369.51	368.87	369.03	246560.0
2020-12-24 14:00:00	SPY	ETF	369.03	369.1	368.96	369.02	32765.0
2020-12-24 14:30:00	SPY	ETF	369.03	369.09	368.98	369.04	6418.0
2020-12-24 15:00:00	SPY	ETF	369.04	369.04	368.94	368.95	2972.0
2020-12-24 15:30:00	SPY	ETF	368.93	368.99	368.9	368.97	5120.0
2020-12-24 16:00:00	SPY	ETF	368.93	369.23	368.93	368.98	2363.0
2020-12-24 16:30:00	SPY	ETF	369.0	369.0	368.96	368.98	353140.0
2020-12-24 04:00:00	QQQ	ETF	308.64	308.74	308.61	308.74	2995.0
2020-12-24 04:30:00	QQQ	ETF	308.75	308.75	308.63	308.65	3247.0
2020-12-24 05:00:00	QQQ	ETF	308.66	308.72	308.66	308.71	400.0
2020-12-24 05:30:00	QQQ	ETF	308.69	308.69	308.53	308.53	2000.0
2020-12-24 06:00:00	QQQ	ETF	308.57	308.77	308.57	308.68	3661.0
2020-12-24 06:30:00	QQQ	ETF	308.66	308.72	308.66	308.68	11599.0
2020-12-24 07:00:00	QQQ	ETF	308.67	308.69	308.56	308.6	29461.0
2020-12-24 07:30:00	QQQ	ETF	308.54	308.57	308.44	308.55	24656.0
2020-12-24 08:00:00	QQQ	ETF	308.59	308.66	308.44	308.57	20926.0
2020-12-24 08:30:00	QQQ	ETF	308.53	308.56	308.47	308.5	10733.0
2020-12-24 09:00:00	QQQ	ETF	308.42	308.63	308.42	308.49	235738.0
2020-12-24 09:30:00	QQQ	ETF	308.47	309.86	308.39	309.525	2076375.0
2020-12-24 10:00:00	QQQ	ETF	309.525	309.95	309.225	309.695	1310582.0
2020-12-24 10:30:00	QQQ	ETF	309.72	310.02	308.931	308.9401	1169428.0
2020-12-24 11:00:00	QQQ	ETF	308.94	309.31	308.76	308.79	904741.0
2020-12-24 11:30:00	QQQ	ETF	308.785	309.165	308.59	308.88	766402.0
2020-12-24 12:00:00	QQQ	ETF	308.88	309.17	308.56	309.13	845658.0
2020-12-24 12:30:00	QQQ	ETF	309.15	309.6	308.98	309.53	2194246.0
2020-12-24 13:00:00	QQQ	ETF	309.52	309.61	309.33	309.4	782051.0
2020-12-24 13:30:00	QQQ	ETF	309.42	309.56	309.35	309.505	30927.0
2020-12-24 14:00:00	QQQ	ETF	309.48	309.56	309.45	309.56	15635.0
2020-12-24 14:30:00	QQQ	ETF	309.5	309.53	309.22	309.3	7838.0
2020-12-24 15:00:00	QQQ	ETF	309.3899	309.3899	309.2001	309.38	7702.0
2020-12-24 15:30:00	QQQ	ETF	309.25	309.46	309.25	309.38	1750.0

> showing 50 of 12,770 rows — these rows as CSV

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