PREVIEW / etf_30min / 2020-02-14

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-14.parquet
  size:    529 KB
  rows:    18,509

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-14 04:00:00	SPY	ETF	337.75	337.84	337.61	337.71	4929.0
2020-02-14 04:30:00	SPY	ETF	337.71	337.85	337.62	337.78	9438.0
2020-02-14 05:00:00	SPY	ETF	337.86	338.0	337.86	337.88	5996.0
2020-02-14 05:30:00	SPY	ETF	337.93	338.04	337.89	337.91	11471.0
2020-02-14 06:00:00	SPY	ETF	337.95	337.98	337.8	337.98	1395.0
2020-02-14 06:30:00	SPY	ETF	337.96	337.98	337.82	337.98	3875.0
2020-02-14 07:00:00	SPY	ETF	337.91	338.11	337.91	338.0	93672.0
2020-02-14 07:30:00	SPY	ETF	338.0	338.24	337.98	338.14	257236.0
2020-02-14 08:00:00	SPY	ETF	338.13	338.2	337.67	338.02	150013.0
2020-02-14 08:30:00	SPY	ETF	338.03	338.03	337.27	337.48	263335.0
2020-02-14 09:00:00	SPY	ETF	337.48	337.69	337.35	337.47	125325.0
2020-02-14 09:30:00	SPY	ETF	337.51	337.65	336.92	337.03	3766640.0
2020-02-14 10:00:00	SPY	ETF	337.03	337.315	336.68	337.23	2529395.0
2020-02-14 10:30:00	SPY	ETF	337.237	337.54	337.1	337.51	1930276.0
2020-02-14 11:00:00	SPY	ETF	337.51	337.73	337.34	337.49	1710677.0
2020-02-14 11:30:00	SPY	ETF	337.48	337.56	337.23	337.29	1307393.0
2020-02-14 12:00:00	SPY	ETF	337.28	337.3667	336.81	336.94	2510225.0
2020-02-14 12:30:00	SPY	ETF	336.95	337.06	336.655	336.8	2725051.0
2020-02-14 13:00:00	SPY	ETF	336.81	337.0	336.49	336.6438	4875412.0
2020-02-14 13:30:00	SPY	ETF	336.6396	336.93	336.5	336.59	3730783.0
2020-02-14 14:00:00	SPY	ETF	336.58	336.94	336.2	336.9	5616658.0
2020-02-14 14:30:00	SPY	ETF	336.9	337.24	336.755	336.88	7596390.0
2020-02-14 15:00:00	SPY	ETF	336.87	336.95	336.54	336.8299	3516660.0
2020-02-14 15:30:00	SPY	ETF	336.82	337.61	336.755	337.6	9643077.0
2020-02-14 16:00:00	SPY	ETF	337.6	337.8	337.56	337.76	11062932.0
2020-02-14 16:30:00	SPY	ETF	337.78	337.86	337.6	337.7	579760.0
2020-02-14 17:00:00	SPY	ETF	337.7	337.79	337.6	337.62	101227.0
2020-02-14 17:30:00	SPY	ETF	337.6	337.66	337.54	337.66	26411.0
2020-02-14 18:00:00	SPY	ETF	337.66	337.67	337.6	337.67	5974.0
2020-02-14 18:30:00	SPY	ETF	337.67	337.87	337.65	337.74	23902.0
2020-02-14 19:00:00	SPY	ETF	337.72	337.75	337.69	337.75	9538.0
2020-02-14 19:30:00	SPY	ETF	337.79	337.86	337.74	337.8	17048.0
2020-02-14 04:00:00	QQQ	ETF	234.62	234.62	234.47	234.61	13740.0
2020-02-14 04:30:00	QQQ	ETF	234.55	234.72	234.54	234.72	6800.0
2020-02-14 05:00:00	QQQ	ETF	234.69	234.8	234.68	234.71	8700.0
2020-02-14 05:30:00	QQQ	ETF	234.74	234.85	234.74	234.81	6195.0
2020-02-14 06:00:00	QQQ	ETF	234.78	234.78	234.6	234.72	15981.0
2020-02-14 06:30:00	QQQ	ETF	234.71	234.73	234.67	234.72	3920.0
2020-02-14 07:00:00	QQQ	ETF	234.77	234.92	234.77	234.89	63160.0
2020-02-14 07:30:00	QQQ	ETF	234.87	235.01	234.86	234.95	180914.0
2020-02-14 08:00:00	QQQ	ETF	234.85	234.98	234.62	234.83	163253.0
2020-02-14 08:30:00	QQQ	ETF	234.76	234.78	234.2	234.44	251222.0
2020-02-14 09:00:00	QQQ	ETF	234.37	234.53	234.31	234.31	57595.0
2020-02-14 09:30:00	QQQ	ETF	234.28	234.81	233.92	234.07	2121263.0
2020-02-14 10:00:00	QQQ	ETF	234.08	234.37	233.68	234.32	1759888.0
2020-02-14 10:30:00	QQQ	ETF	234.31	234.766	234.19	234.74	871294.0
2020-02-14 11:00:00	QQQ	ETF	234.74	234.86	234.515	234.6064	870510.0
2020-02-14 11:30:00	QQQ	ETF	234.6	234.64	234.3646	234.43	582485.0
2020-02-14 12:00:00	QQQ	ETF	234.42	234.5	233.875	234.0846	998270.0
2020-02-14 12:30:00	QQQ	ETF	234.0646	234.21	233.74	233.9173	723467.0

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

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