PREVIEW / etf_30min / 2019-11-18

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-11-18.parquet
  size:    516 KB
  rows:    18,207

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-18 04:00:00	SPY	ETF	312.13	312.29	312.13	312.17	4973.0
2019-11-18 04:30:00	SPY	ETF	312.17	312.24	312.17	312.24	4075.0
2019-11-18 05:00:00	SPY	ETF	312.32	312.37	312.22	312.34	3575.0
2019-11-18 05:30:00	SPY	ETF	312.37	312.37	312.16	312.16	5537.0
2019-11-18 06:00:00	SPY	ETF	312.14	312.22	312.09	312.21	12652.0
2019-11-18 06:30:00	SPY	ETF	312.19	312.33	312.19	312.3	13100.0
2019-11-18 07:00:00	SPY	ETF	312.3	312.38	312.23	312.36	25388.0
2019-11-18 07:30:00	SPY	ETF	312.34	312.47	312.34	312.45	114693.0
2019-11-18 08:00:00	SPY	ETF	312.4	312.58	311.4	311.44	226095.0
2019-11-18 08:30:00	SPY	ETF	311.42	311.68	311.3	311.63	483323.0
2019-11-18 09:00:00	SPY	ETF	311.63	311.71	311.45	311.55	229042.0
2019-11-18 09:30:00	SPY	ETF	311.53	311.58	311.085	311.45	3727281.0
2019-11-18 10:00:00	SPY	ETF	311.45	311.64	311.03	311.18	8111708.0
2019-11-18 10:30:00	SPY	ETF	311.18	311.8	311.11	311.6223	3539790.0
2019-11-18 11:00:00	SPY	ETF	311.625	311.93	311.48	311.81	3926993.0
2019-11-18 11:30:00	SPY	ETF	311.81	312.0	311.76	311.94	1775470.0
2019-11-18 12:00:00	SPY	ETF	311.94	311.98	311.7053	311.72	1570902.0
2019-11-18 12:30:00	SPY	ETF	311.725	311.94	311.68	311.895	867668.0
2019-11-18 13:00:00	SPY	ETF	311.9	311.98	311.83	311.963	1756653.0
2019-11-18 13:30:00	SPY	ETF	311.96	312.21	311.93	312.13	1674286.0
2019-11-18 14:00:00	SPY	ETF	312.13	312.22	311.95	312.1447	1613109.0
2019-11-18 14:30:00	SPY	ETF	312.14	312.28	312.1	312.14	1591543.0
2019-11-18 15:00:00	SPY	ETF	312.145	312.19	311.81	311.96	3598430.0
2019-11-18 15:30:00	SPY	ETF	311.97	312.04	311.67	311.99	7479661.0
2019-11-18 16:00:00	SPY	ETF	312.0	312.11	311.78	312.07	3738305.0
2019-11-18 16:30:00	SPY	ETF	312.08	312.18	311.97	312.06	338895.0
2019-11-18 17:00:00	SPY	ETF	312.06	312.1	312.0	312.1	959035.0
2019-11-18 17:30:00	SPY	ETF	312.02	312.09	312.0	312.06	22665.0
2019-11-18 18:00:00	SPY	ETF	312.06	312.06	311.9	311.92	60162.0
2019-11-18 18:30:00	SPY	ETF	311.93	311.98	311.88	311.89	11998.0
2019-11-18 19:00:00	SPY	ETF	311.94	311.94	311.72	311.78	28813.0
2019-11-18 19:30:00	SPY	ETF	311.78	311.78	311.55	311.71	25924.0
2019-11-18 04:00:00	QQQ	ETF	203.11	203.22	203.08	203.12	8645.0
2019-11-18 04:30:00	QQQ	ETF	203.09	203.24	203.09	203.18	6000.0
2019-11-18 05:00:00	QQQ	ETF	203.27	203.3	203.22	203.29	10250.0
2019-11-18 05:30:00	QQQ	ETF	203.26	203.28	203.11	203.12	24350.0
2019-11-18 06:00:00	QQQ	ETF	203.11	203.16	203.1	203.16	14140.0
2019-11-18 06:30:00	QQQ	ETF	203.19	203.3	203.17	203.29	13535.0
2019-11-18 07:00:00	QQQ	ETF	203.23	203.33	203.16	203.29	33464.0
2019-11-18 07:30:00	QQQ	ETF	203.25	203.38	203.2	203.34	67321.0
2019-11-18 08:00:00	QQQ	ETF	203.26	203.37	202.59	202.6	217363.0
2019-11-18 08:30:00	QQQ	ETF	202.6	202.77	202.47	202.69	343637.0
2019-11-18 09:00:00	QQQ	ETF	202.65	202.72	202.55	202.58	83720.0
2019-11-18 09:30:00	QQQ	ETF	202.61	202.62	201.77	202.1836	2026254.0
2019-11-18 10:00:00	QQQ	ETF	202.19	202.3197	201.9	202.01	1105717.0
2019-11-18 10:30:00	QQQ	ETF	202.0	202.61	201.98	202.47	1050246.0
2019-11-18 11:00:00	QQQ	ETF	202.47	202.69	202.28	202.5762	1477422.0
2019-11-18 11:30:00	QQQ	ETF	202.57	202.865	202.56	202.81	677725.0
2019-11-18 12:00:00	QQQ	ETF	202.81	202.84	202.54	202.57	424326.0
2019-11-18 12:30:00	QQQ	ETF	202.57	202.7401	202.5285	202.7	294624.0

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

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