PREVIEW / etf_30min / 2019-12-18

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-18.parquet
  size:    520 KB
  rows:    18,346

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-12-18 04:00:00	SPY	ETF	319.69	319.77	319.64	319.77	4354.0
2019-12-18 04:30:00	SPY	ETF	319.82	319.87	319.79	319.87	6943.0
2019-12-18 05:00:00	SPY	ETF	319.87	319.89	319.83	319.85	4659.0
2019-12-18 05:30:00	SPY	ETF	319.8	319.88	319.8	319.87	1500.0
2019-12-18 06:00:00	SPY	ETF	319.79	319.79	319.69	319.7	3950.0
2019-12-18 06:30:00	SPY	ETF	319.7	319.77	319.59	319.64	10006.0
2019-12-18 07:00:00	SPY	ETF	319.69	319.69	319.5	319.68	17225.0
2019-12-18 07:30:00	SPY	ETF	319.71	319.82	319.71	319.73	61875.0
2019-12-18 08:00:00	SPY	ETF	319.77	319.85	319.37	319.83	51316.0
2019-12-18 08:30:00	SPY	ETF	319.84	319.88	319.65	319.65	44746.0
2019-12-18 09:00:00	SPY	ETF	319.64	320.04	319.62	320.0	72988.0
2019-12-18 09:30:00	SPY	ETF	320.0	320.2	319.72	319.72	5675696.0
2019-12-18 10:00:00	SPY	ETF	319.73	319.86	319.53	319.61	3602815.0
2019-12-18 10:30:00	SPY	ETF	319.61	320.07	319.6	320.0	2113497.0
2019-12-18 11:00:00	SPY	ETF	319.99	320.25	319.83	320.13	3090605.0
2019-12-18 11:30:00	SPY	ETF	320.13	320.18	319.79	319.805	1452263.0
2019-12-18 12:00:00	SPY	ETF	319.8099	319.98	319.77	319.8499	1189781.0
2019-12-18 12:30:00	SPY	ETF	319.84	319.86	319.7604	319.83	1286599.0
2019-12-18 13:00:00	SPY	ETF	319.835	319.97	319.81	319.85	1669374.0
2019-12-18 13:30:00	SPY	ETF	319.84	320.015	319.82	320.0	2293285.0
2019-12-18 14:00:00	SPY	ETF	320.01	320.05	319.815	319.925	1902091.0
2019-12-18 14:30:00	SPY	ETF	319.93	320.07	319.91	320.035	1705200.0
2019-12-18 15:00:00	SPY	ETF	320.04	320.06	319.85	319.945	2754756.0
2019-12-18 15:30:00	SPY	ETF	319.94	320.04	319.53	319.57	10684079.0
2019-12-18 16:00:00	SPY	ETF	319.56	319.86	319.5055	319.84	5630307.0
2019-12-18 16:30:00	SPY	ETF	319.84	319.89	319.5025	319.85	784405.0
2019-12-18 17:00:00	SPY	ETF	319.85	319.85	319.71	319.82	39885.0
2019-12-18 17:30:00	SPY	ETF	319.83	319.85	319.8	319.81	17548.0
2019-12-18 18:00:00	SPY	ETF	319.85	319.93	319.82	319.85	67023.0
2019-12-18 18:30:00	SPY	ETF	319.84	319.87	319.79	319.79	5724.0
2019-12-18 19:00:00	SPY	ETF	319.77	319.96	319.75	319.9	17664.0
2019-12-18 19:30:00	SPY	ETF	319.94	320.07	319.93	319.94	35446.0
2019-12-18 04:00:00	QQQ	ETF	209.33	209.43	209.29	209.42	6633.0
2019-12-18 04:30:00	QQQ	ETF	209.44	209.48	209.43	209.46	7485.0
2019-12-18 05:00:00	QQQ	ETF	209.49	209.52	209.46	209.46	16900.0
2019-12-18 05:30:00	QQQ	ETF	209.46	209.5	209.43	209.47	8350.0
2019-12-18 06:00:00	QQQ	ETF	209.43	209.47	209.39	209.39	2600.0
2019-12-18 06:30:00	QQQ	ETF	209.42	209.42	209.32	209.38	4251.0
2019-12-18 07:00:00	QQQ	ETF	209.39	209.43	209.28	209.43	16210.0
2019-12-18 07:30:00	QQQ	ETF	209.41	209.5	209.41	209.45	44653.0
2019-12-18 08:00:00	QQQ	ETF	209.44	209.53	209.12	209.51	44850.0
2019-12-18 08:30:00	QQQ	ETF	209.53	209.57	209.38	209.38	33123.0
2019-12-18 09:00:00	QQQ	ETF	209.4	209.61	209.39	209.6	46801.0
2019-12-18 09:30:00	QQQ	ETF	209.59	209.83	209.44	209.479	1353099.0
2019-12-18 10:00:00	QQQ	ETF	209.47	209.669	209.33	209.5751	817186.0
2019-12-18 10:30:00	QQQ	ETF	209.57	209.83	209.54	209.78	796966.0
2019-12-18 11:00:00	QQQ	ETF	209.77	210.07	209.62	209.99	855915.0
2019-12-18 11:30:00	QQQ	ETF	209.98	210.13	209.91	209.91	598161.0
2019-12-18 12:00:00	QQQ	ETF	209.92	210.03	209.8563	209.95	799195.0
2019-12-18 12:30:00	QQQ	ETF	209.94	209.94	209.8606	209.88	517075.0

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

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