PREVIEW / etf_30min / 2019-11-13

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-13.parquet
  size:    512 KB
  rows:    17,853

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-11-13 04:00:00	SPY	ETF	308.26	308.26	307.87	307.91	19355.0
2019-11-13 04:30:00	SPY	ETF	307.8	307.88	307.44	307.54	11202.0
2019-11-13 05:00:00	SPY	ETF	307.67	307.88	307.64	307.81	13056.0
2019-11-13 05:30:00	SPY	ETF	307.8	307.9	307.74	307.86	6771.0
2019-11-13 06:00:00	SPY	ETF	307.84	307.87	307.73	307.82	10029.0
2019-11-13 06:30:00	SPY	ETF	307.82	307.85	307.75	307.84	31089.0
2019-11-13 07:00:00	SPY	ETF	307.91	307.94	307.66	307.82	47473.0
2019-11-13 07:30:00	SPY	ETF	307.78	308.13	307.77	308.04	108346.0
2019-11-13 08:00:00	SPY	ETF	307.89	309.0	307.73	308.13	78553.0
2019-11-13 08:30:00	SPY	ETF	308.12	308.24	308.0	308.18	287011.0
2019-11-13 09:00:00	SPY	ETF	308.19	308.2	307.87	307.89	453306.0
2019-11-13 09:30:00	SPY	ETF	307.91	308.47	307.66	308.37	4448056.0
2019-11-13 10:00:00	SPY	ETF	308.3701	308.71	308.23	308.55	2037098.0
2019-11-13 10:30:00	SPY	ETF	308.56	309.03	308.28	309.0	3012459.0
2019-11-13 11:00:00	SPY	ETF	309.0	309.04	308.69	308.7	1878120.0
2019-11-13 11:30:00	SPY	ETF	308.69	309.25	308.65	309.12	3983399.0
2019-11-13 12:00:00	SPY	ETF	309.12	309.26	308.98	309.215	2214196.0
2019-11-13 12:30:00	SPY	ETF	309.202	309.42	309.18	309.35	2502956.0
2019-11-13 13:00:00	SPY	ETF	309.35	309.42	309.19	309.2566	1091856.0
2019-11-13 13:30:00	SPY	ETF	309.26	309.54	308.38	308.83	6480428.0
2019-11-13 14:00:00	SPY	ETF	308.84	308.85	308.42	308.65	5145006.0
2019-11-13 14:30:00	SPY	ETF	308.66	309.19	308.6316	309.15	3432563.0
2019-11-13 15:00:00	SPY	ETF	309.15	309.37	309.1	309.21	3473508.0
2019-11-13 15:30:00	SPY	ETF	309.21	309.36	308.87	309.07	7505525.0
2019-11-13 16:00:00	SPY	ETF	309.1	309.45	309.0	309.37	4608070.0
2019-11-13 16:30:00	SPY	ETF	309.38	309.46	309.1	309.45	228828.0
2019-11-13 17:00:00	SPY	ETF	309.41	309.44	309.3	309.35	122314.0
2019-11-13 17:30:00	SPY	ETF	309.35	309.45	309.35	309.43	39490.0
2019-11-13 18:00:00	SPY	ETF	309.41	309.45	309.2	309.21	62756.0
2019-11-13 18:30:00	SPY	ETF	309.21	309.29	309.19	309.26	19752.0
2019-11-13 19:00:00	SPY	ETF	309.26	309.32	309.12	309.12	35760.0
2019-11-13 19:30:00	SPY	ETF	309.12	309.13	309.05	309.09	73387.0
2019-11-13 04:00:00	QQQ	ETF	201.0	201.0	200.69	200.75	14739.0
2019-11-13 04:30:00	QQQ	ETF	200.64	200.68	200.3	200.42	5544.0
2019-11-13 05:00:00	QQQ	ETF	200.47	200.61	200.44	200.61	31125.0
2019-11-13 05:30:00	QQQ	ETF	200.53	200.65	200.49	200.61	8111.0
2019-11-13 06:00:00	QQQ	ETF	200.61	200.61	200.5	200.6	5400.0
2019-11-13 06:30:00	QQQ	ETF	200.55	200.65	200.52	200.63	8820.0
2019-11-13 07:00:00	QQQ	ETF	200.67	200.74	200.55	200.66	37532.0
2019-11-13 07:30:00	QQQ	ETF	200.7	200.89	200.68	200.78	19377.0
2019-11-13 08:00:00	QQQ	ETF	200.75	201.32	200.58	200.8101	49238.0
2019-11-13 08:30:00	QQQ	ETF	200.87	201.03	200.87	201.02	55048.0
2019-11-13 09:00:00	QQQ	ETF	201.03	201.05	200.8	200.86	44277.0
2019-11-13 09:30:00	QQQ	ETF	200.84	201.34	200.71	201.12	1519452.0
2019-11-13 10:00:00	QQQ	ETF	201.12	201.4487	201.0	201.36	817865.0
2019-11-13 10:30:00	QQQ	ETF	201.38	201.6	201.11	201.54	911420.0
2019-11-13 11:00:00	QQQ	ETF	201.54	201.59	201.245	201.245	692485.0
2019-11-13 11:30:00	QQQ	ETF	201.24	201.7342	201.23	201.65	721468.0
2019-11-13 12:00:00	QQQ	ETF	201.64	201.71	201.51	201.57	379993.0
2019-11-13 12:30:00	QQQ	ETF	201.57	201.775	201.54	201.665	438113.0

> showing 50 of 17,853 rows — these rows as CSV

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