PREVIEW / etf_30min / 2020-12-04

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-12-04.parquet
  size:    587 KB
  rows:    21,911

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-04 04:00:00	SPY	ETF	367.5	367.7	367.48	367.52	4837.0
2020-12-04 04:30:00	SPY	ETF	367.55	367.96	367.55	367.59	6240.0
2020-12-04 05:00:00	SPY	ETF	367.5	367.61	367.4	367.43	10674.0
2020-12-04 05:30:00	SPY	ETF	367.42	367.7	367.42	367.68	6746.0
2020-12-04 06:00:00	SPY	ETF	367.75	367.82	367.57	367.6	67710.0
2020-12-04 06:30:00	SPY	ETF	367.6	367.67	367.51	367.59	75006.0
2020-12-04 07:00:00	SPY	ETF	367.54	367.87	367.48	367.76	70184.0
2020-12-04 07:30:00	SPY	ETF	367.76	367.76	367.49	367.49	39181.0
2020-12-04 08:00:00	SPY	ETF	367.5	367.83	367.1	367.53	163483.0
2020-12-04 08:30:00	SPY	ETF	367.55	367.95	366.69	367.37	614026.0
2020-12-04 09:00:00	SPY	ETF	367.38	367.47	367.18	367.28	97379.0
2020-12-04 09:30:00	SPY	ETF	367.32	368.42	367.22	368.2356	3673786.0
2020-12-04 10:00:00	SPY	ETF	368.225	368.7299	368.095	368.35	3093427.0
2020-12-04 10:30:00	SPY	ETF	368.355	369.27	368.35	369.05	4153324.0
2020-12-04 11:00:00	SPY	ETF	369.04	369.2	368.72	369.01	2119133.0
2020-12-04 11:30:00	SPY	ETF	369.02	369.2584	368.96	369.05	1845435.0
2020-12-04 12:00:00	SPY	ETF	369.05	369.2	368.89	369.0256	1406311.0
2020-12-04 12:30:00	SPY	ETF	369.03	369.16	368.875	369.0	2336183.0
2020-12-04 13:00:00	SPY	ETF	369.005	369.14	368.8419	368.89	1365147.0
2020-12-04 13:30:00	SPY	ETF	368.9	369.1801	368.71	368.74	1771105.0
2020-12-04 14:00:00	SPY	ETF	368.74	369.05	368.55	368.635	1561284.0
2020-12-04 14:30:00	SPY	ETF	368.64	369.28	368.59	369.1999	2997551.0
2020-12-04 15:00:00	SPY	ETF	369.2	369.38	368.67	368.95	3255503.0
2020-12-04 15:30:00	SPY	ETF	368.96	369.85	368.9	369.83	10511455.0
2020-12-04 16:00:00	SPY	ETF	369.82	369.94	368.94	369.14	7117942.0
2020-12-04 16:30:00	SPY	ETF	369.14	369.85	369.0	369.01	500631.0
2020-12-04 17:00:00	SPY	ETF	369.0	369.85	369.0	369.02	390377.0
2020-12-04 17:30:00	SPY	ETF	369.04	369.15	369.0	369.15	23621.0
2020-12-04 18:00:00	SPY	ETF	369.15	369.18	369.11	369.18	11827.0
2020-12-04 18:30:00	SPY	ETF	369.17	369.34	369.11	369.19	26427.0
2020-12-04 19:00:00	SPY	ETF	369.21	369.25	369.17	369.22	6965.0
2020-12-04 19:30:00	SPY	ETF	369.25	369.25	369.14	369.22	15657.0
2020-12-04 04:00:00	QQQ	ETF	305.12	305.17	305.0	305.03	12898.0
2020-12-04 04:30:00	QQQ	ETF	305.02	305.2	305.01	305.01	10175.0
2020-12-04 05:00:00	QQQ	ETF	304.93	304.98	304.88	304.96	11046.0
2020-12-04 05:30:00	QQQ	ETF	305.0	305.11	304.99	305.04	12935.0
2020-12-04 06:00:00	QQQ	ETF	305.2	305.22	305.08	305.18	15173.0
2020-12-04 06:30:00	QQQ	ETF	305.16	305.26	305.13	305.13	19063.0
2020-12-04 07:00:00	QQQ	ETF	305.13	305.15	304.96	305.01	175816.0
2020-12-04 07:30:00	QQQ	ETF	304.97	304.99	304.61	304.74	27670.0
2020-12-04 08:00:00	QQQ	ETF	304.74	305.46	304.28	304.77	66861.0
2020-12-04 08:30:00	QQQ	ETF	304.72	305.0	304.25	304.34	333169.0
2020-12-04 09:00:00	QQQ	ETF	304.36	304.5	304.3	304.31	90796.0
2020-12-04 09:30:00	QQQ	ETF	304.27	305.09	303.63	305.02	2364685.0
2020-12-04 10:00:00	QQQ	ETF	305.02	305.33	304.21	304.3	1376171.0
2020-12-04 10:30:00	QQQ	ETF	304.3079	305.4	304.3	304.85	1243470.0
2020-12-04 11:00:00	QQQ	ETF	304.85	305.16	304.46	305.16	1033380.0
2020-12-04 11:30:00	QQQ	ETF	305.1696	305.61	305.1201	305.17	781276.0
2020-12-04 12:00:00	QQQ	ETF	305.19	305.49	305.01	305.179	801760.0
2020-12-04 12:30:00	QQQ	ETF	305.17	305.6	305.15	305.58	503925.0

> showing 50 of 21,911 rows — these rows as CSV

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