PREVIEW / etf_30min / 2019-08-21

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-21.parquet
  size:    507 KB
  rows:    17,709

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-08-21 04:00:00	SPY	ETF	291.3	291.5	291.3	291.5	12816.0
2019-08-21 04:30:00	SPY	ETF	291.48	291.94	291.48	291.87	8777.0
2019-08-21 05:00:00	SPY	ETF	291.84	291.85	291.71	291.85	18910.0
2019-08-21 05:30:00	SPY	ETF	291.91	291.97	291.74	291.76	3360.0
2019-08-21 06:00:00	SPY	ETF	291.64	291.81	291.64	291.8	5147.0
2019-08-21 06:30:00	SPY	ETF	291.74	291.92	291.7	291.7	52955.0
2019-08-21 07:00:00	SPY	ETF	291.72	291.84	291.6	291.8	77748.0
2019-08-21 07:30:00	SPY	ETF	291.7	291.75	291.6	291.7	109902.0
2019-08-21 08:00:00	SPY	ETF	291.73	292.12	290.79	291.91	404631.0
2019-08-21 08:30:00	SPY	ETF	291.94	292.33	291.85	292.31	606005.0
2019-08-21 09:00:00	SPY	ETF	292.3	292.6301	292.2	292.47	877470.0
2019-08-21 09:30:00	SPY	ETF	292.48	292.86	292.09	292.53	5706520.0
2019-08-21 10:00:00	SPY	ETF	292.54	292.62	292.1	292.33	3320701.0
2019-08-21 10:30:00	SPY	ETF	292.32	292.42	291.96	292.3	2678247.0
2019-08-21 11:00:00	SPY	ETF	292.29	292.6	292.04	292.49	3976909.0
2019-08-21 11:30:00	SPY	ETF	292.485	292.83	292.41	292.75	3249981.0
2019-08-21 12:00:00	SPY	ETF	292.74	292.79	292.41	292.46	1970846.0
2019-08-21 12:30:00	SPY	ETF	292.46	292.68	292.35	292.59	1779573.0
2019-08-21 13:00:00	SPY	ETF	292.585	292.69	292.51	292.5435	1595903.0
2019-08-21 13:30:00	SPY	ETF	292.55	292.58	292.29	292.32	2078317.0
2019-08-21 14:00:00	SPY	ETF	292.31	292.68	291.72	292.58	4150696.0
2019-08-21 14:30:00	SPY	ETF	292.5741	292.63	291.79	292.0	2318988.0
2019-08-21 15:00:00	SPY	ETF	291.98	292.32	291.85	292.25	2549084.0
2019-08-21 15:30:00	SPY	ETF	292.25	292.52	292.19	292.43	6298096.0
2019-08-21 16:00:00	SPY	ETF	292.41	292.89	292.33	292.83	3825651.0
2019-08-21 16:30:00	SPY	ETF	292.86	293.15	292.86	293.11	360544.0
2019-08-21 17:00:00	SPY	ETF	293.03	293.1	293.01	293.01	81979.0
2019-08-21 17:30:00	SPY	ETF	293.02	293.11	293.0	293.05	37523.0
2019-08-21 18:00:00	SPY	ETF	293.06	293.76	293.01	293.55	93790.0
2019-08-21 18:30:00	SPY	ETF	293.57	293.57	293.37	293.42	35902.0
2019-08-21 19:00:00	SPY	ETF	293.48	293.61	293.45	293.54	46584.0
2019-08-21 19:30:00	SPY	ETF	293.5	293.55	293.35	293.4	93710.0
2019-08-21 04:00:00	QQQ	ETF	188.06	188.31	188.06	188.2	8213.0
2019-08-21 04:30:00	QQQ	ETF	188.2	188.55	188.2	188.45	22975.0
2019-08-21 05:00:00	QQQ	ETF	188.51	188.51	188.37	188.43	12341.0
2019-08-21 05:30:00	QQQ	ETF	188.57	188.59	188.42	188.52	2225.0
2019-08-21 06:00:00	QQQ	ETF	188.43	188.43	188.28	188.4	13200.0
2019-08-21 06:30:00	QQQ	ETF	188.41	188.53	188.34	188.34	9950.0
2019-08-21 07:00:00	QQQ	ETF	188.33	188.4	188.26	188.36	40906.0
2019-08-21 07:30:00	QQQ	ETF	188.28	188.31	188.17	188.24	48925.0
2019-08-21 08:00:00	QQQ	ETF	188.27	188.51	187.37	188.34	165783.0
2019-08-21 08:30:00	QQQ	ETF	188.32	188.55	186.97	188.55	103182.0
2019-08-21 09:00:00	QQQ	ETF	188.56	188.88	188.53	188.64	202275.0
2019-08-21 09:30:00	QQQ	ETF	188.66	189.23	188.38	189.0	3521278.0
2019-08-21 10:00:00	QQQ	ETF	189.02	189.13	188.69	188.85	1393751.0
2019-08-21 10:30:00	QQQ	ETF	188.84	188.89	188.555	188.75	1143670.0
2019-08-21 11:00:00	QQQ	ETF	188.75	188.98	188.55	188.9	813889.0
2019-08-21 11:30:00	QQQ	ETF	188.89	189.09	188.82	188.97	920357.0
2019-08-21 12:00:00	QQQ	ETF	188.97	189.0	188.73	188.79	425751.0
2019-08-21 12:30:00	QQQ	ETF	188.79	188.87	188.65	188.79	643391.0

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

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