PREVIEW / etf_30min / 2019-12-03

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-03.parquet
  size:    543 KB
  rows:    18,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
2019-12-03 04:00:00	SPY	ETF	312.05	312.27	312.05	312.14	8030.0
2019-12-03 04:30:00	SPY	ETF	312.13	312.14	311.69	311.9	6993.0
2019-12-03 05:00:00	SPY	ETF	312.06	312.14	310.35	310.37	39568.0
2019-12-03 05:30:00	SPY	ETF	310.42	310.6	310.3	310.4	35421.0
2019-12-03 06:00:00	SPY	ETF	310.52	310.71	310.37	310.65	23629.0
2019-12-03 06:30:00	SPY	ETF	310.66	310.87	310.66	310.84	20702.0
2019-12-03 07:00:00	SPY	ETF	310.86	310.86	310.53	310.6	119348.0
2019-12-03 07:30:00	SPY	ETF	310.59	310.63	309.78	309.9	317554.0
2019-12-03 08:00:00	SPY	ETF	309.9	312.25	309.21	309.49	1298072.0
2019-12-03 08:30:00	SPY	ETF	309.46	309.5	308.9	308.97	633103.0
2019-12-03 09:00:00	SPY	ETF	308.99	309.0	308.33	308.64	996831.0
2019-12-03 09:30:00	SPY	ETF	308.65	308.77	307.13	308.15	13931291.0
2019-12-03 10:00:00	SPY	ETF	308.15	308.51	307.37	307.97	7388392.0
2019-12-03 10:30:00	SPY	ETF	307.965	308.57	307.65	307.98	6187468.0
2019-12-03 11:00:00	SPY	ETF	307.97	308.419	307.59	307.97	5641978.0
2019-12-03 11:30:00	SPY	ETF	307.97	308.43	307.76	308.2	3787877.0
2019-12-03 12:00:00	SPY	ETF	308.21	308.54	307.92	308.396	2559983.0
2019-12-03 12:30:00	SPY	ETF	308.39	308.4698	308.19	308.45	2547216.0
2019-12-03 13:00:00	SPY	ETF	308.45	308.91	308.415	308.85	2621551.0
2019-12-03 13:30:00	SPY	ETF	308.85	309.13	308.75	308.79	3294048.0
2019-12-03 14:00:00	SPY	ETF	308.79	308.96	308.37	308.5	2239105.0
2019-12-03 14:30:00	SPY	ETF	308.48	308.8	308.32	308.69	2477453.0
2019-12-03 15:00:00	SPY	ETF	308.7	309.61	308.52	309.565	4458039.0
2019-12-03 15:30:00	SPY	ETF	309.56	309.64	309.01	309.47	7942951.0
2019-12-03 16:00:00	SPY	ETF	309.48	309.56	309.22	309.31	3903083.0
2019-12-03 16:30:00	SPY	ETF	309.32	309.35	308.2157	309.34	797160.0
2019-12-03 17:00:00	SPY	ETF	309.35	309.43	309.3	309.41	43670.0
2019-12-03 17:30:00	SPY	ETF	309.44	309.46	309.33	309.42	37027.0
2019-12-03 18:00:00	SPY	ETF	309.36	309.65	309.28	309.59	260003.0
2019-12-03 18:30:00	SPY	ETF	309.59	309.6	309.43	309.6	39363.0
2019-12-03 19:00:00	SPY	ETF	309.64	309.8	309.07	309.48	61490.0
2019-12-03 19:30:00	SPY	ETF	309.47	309.47	309.1701	309.25	21559.0
2019-12-03 04:00:00	QQQ	ETF	203.18	203.31	203.14	203.23	11170.0
2019-12-03 04:30:00	QQQ	ETF	203.23	203.25	202.95	203.13	13006.0
2019-12-03 05:00:00	QQQ	ETF	203.15	203.22	201.8	201.87	50125.0
2019-12-03 05:30:00	QQQ	ETF	201.78	201.96	201.75	201.84	35427.0
2019-12-03 06:00:00	QQQ	ETF	201.88	202.01	201.77	201.96	45004.0
2019-12-03 06:30:00	QQQ	ETF	202.01	202.22	202.01	202.22	17792.0
2019-12-03 07:00:00	QQQ	ETF	202.22	202.23	201.88	201.95	90769.0
2019-12-03 07:30:00	QQQ	ETF	201.93	201.95	201.22	201.35	205509.0
2019-12-03 08:00:00	QQQ	ETF	201.9	203.14	200.75	200.96	477959.0
2019-12-03 08:30:00	QQQ	ETF	200.94	200.95	200.52	200.56	362108.0
2019-12-03 09:00:00	QQQ	ETF	200.56	200.58	200.1	200.31	506383.0
2019-12-03 09:30:00	QQQ	ETF	200.32	200.57	199.23	200.08	5291986.0
2019-12-03 10:00:00	QQQ	ETF	200.06	200.5	199.615	200.08	3087007.0
2019-12-03 10:30:00	QQQ	ETF	200.08	200.43	199.69	199.84	2191526.0
2019-12-03 11:00:00	QQQ	ETF	199.85	200.27	199.61	199.87	1873393.0
2019-12-03 11:30:00	QQQ	ETF	199.87	200.22	199.74	200.105	1658320.0
2019-12-03 12:00:00	QQQ	ETF	200.1	200.43	199.88	200.3495	1068614.0
2019-12-03 12:30:00	QQQ	ETF	200.34	200.43	200.21	200.39	485117.0

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

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