PREVIEW / etf_30min / 2020-02-13

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-13.parquet
  size:    545 KB
  rows:    19,208

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-02-13 04:00:00	SPY	ETF	336.1	336.1	335.61	335.62	15604.0
2020-02-13 04:30:00	SPY	ETF	335.68	335.69	335.07	335.32	14474.0
2020-02-13 05:00:00	SPY	ETF	335.28	335.52	334.62	335.36	31326.0
2020-02-13 05:30:00	SPY	ETF	335.34	335.45	335.15	335.25	5125.0
2020-02-13 06:00:00	SPY	ETF	335.12	335.13	334.89	334.98	40105.0
2020-02-13 06:30:00	SPY	ETF	334.91	335.61	334.91	335.37	150211.0
2020-02-13 07:00:00	SPY	ETF	335.41	335.71	335.3	335.34	513494.0
2020-02-13 07:30:00	SPY	ETF	335.34	335.61	335.15	335.61	115877.0
2020-02-13 08:00:00	SPY	ETF	335.66	336.52	335.22	335.72	370761.0
2020-02-13 08:30:00	SPY	ETF	335.85	336.21	335.63	336.14	392004.0
2020-02-13 09:00:00	SPY	ETF	336.07	336.28	335.85	335.87	230708.0
2020-02-13 09:30:00	SPY	ETF	335.8621	336.845	335.56	336.12	5884268.0
2020-02-13 10:00:00	SPY	ETF	336.13	336.49	335.6	336.35	4166898.0
2020-02-13 10:30:00	SPY	ETF	336.34	337.13	336.11	337.08	3270224.0
2020-02-13 11:00:00	SPY	ETF	337.07	337.405	336.9	337.35	2205713.0
2020-02-13 11:30:00	SPY	ETF	337.36	337.63	337.105	337.3	3113641.0
2020-02-13 12:00:00	SPY	ETF	337.29	337.73	337.27	337.58	2024600.0
2020-02-13 12:30:00	SPY	ETF	337.58	337.72	337.19	337.2	1785851.0
2020-02-13 13:00:00	SPY	ETF	337.2	337.56	337.01	337.5473	2635374.0
2020-02-13 13:30:00	SPY	ETF	337.545	338.0	337.47	337.88	1870314.0
2020-02-13 14:00:00	SPY	ETF	337.865	338.12	337.61	337.62	2367647.0
2020-02-13 14:30:00	SPY	ETF	337.62	338.01	337.56	337.88	1729174.0
2020-02-13 15:00:00	SPY	ETF	337.87	338.0	337.24	337.4098	4870307.0
2020-02-13 15:30:00	SPY	ETF	337.41	337.47	336.77	337.08	9636329.0
2020-02-13 16:00:00	SPY	ETF	337.08	337.5283	336.9679	337.48	4270177.0
2020-02-13 16:30:00	SPY	ETF	337.48	337.5	337.28	337.5	288970.0
2020-02-13 17:00:00	SPY	ETF	337.51	337.59	337.06	337.53	87800.0
2020-02-13 17:30:00	SPY	ETF	337.53	337.54	337.4	337.53	76140.0
2020-02-13 18:00:00	SPY	ETF	337.53	337.53	337.15	337.27	89651.0
2020-02-13 18:30:00	SPY	ETF	337.28	337.36	336.87	337.06	271752.0
2020-02-13 19:00:00	SPY	ETF	337.06	337.2	336.85	336.92	37090.0
2020-02-13 19:30:00	SPY	ETF	337.03	337.39	336.97	337.37	55009.0
2020-02-13 04:00:00	QQQ	ETF	233.08	233.08	232.6	232.6	28040.0
2020-02-13 04:30:00	QQQ	ETF	232.65	232.71	232.25	232.44	23960.0
2020-02-13 05:00:00	QQQ	ETF	232.26	232.57	231.7	232.49	33058.0
2020-02-13 05:30:00	QQQ	ETF	232.42	232.52	232.27	232.41	21159.0
2020-02-13 06:00:00	QQQ	ETF	232.38	232.42	232.1	232.21	17407.0
2020-02-13 06:30:00	QQQ	ETF	232.1	232.82	232.1	232.6	72225.0
2020-02-13 07:00:00	QQQ	ETF	232.63	232.79	232.36	232.39	158359.0
2020-02-13 07:30:00	QQQ	ETF	232.41	232.57	232.01	232.53	203734.0
2020-02-13 08:00:00	QQQ	ETF	232.7501	233.45	232.1	232.75	263275.0
2020-02-13 08:30:00	QQQ	ETF	232.7	233.03	232.54	232.92	245319.0
2020-02-13 09:00:00	QQQ	ETF	232.91	233.01	232.6	232.64	122775.0
2020-02-13 09:30:00	QQQ	ETF	232.62	233.66	232.36	233.12	3211523.0
2020-02-13 10:00:00	QQQ	ETF	233.14	233.6	232.72	233.4423	1785555.0
2020-02-13 10:30:00	QQQ	ETF	233.41	234.07	233.31	234.0148	1084135.0
2020-02-13 11:00:00	QQQ	ETF	234.03	234.34	233.9201	234.27	1161784.0
2020-02-13 11:30:00	QQQ	ETF	234.27	234.57	234.08	234.2101	1202486.0
2020-02-13 12:00:00	QQQ	ETF	234.215	234.59	234.2	234.44	1009108.0
2020-02-13 12:30:00	QQQ	ETF	234.45	234.58	233.94	233.9433	716365.0

> showing 50 of 19,208 rows — these rows as CSV

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