PREVIEW / etf_30min / 2019-12-16

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-16.parquet
  size:    536 KB
  rows:    18,778

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-16 04:00:00	SPY	ETF	318.41	318.57	318.41	318.52	35812.0
2019-12-16 04:30:00	SPY	ETF	318.42	318.6	318.4	318.54	24898.0
2019-12-16 05:00:00	SPY	ETF	318.55	318.58	318.38	318.49	26668.0
2019-12-16 05:30:00	SPY	ETF	318.55	318.61	318.36	318.46	14798.0
2019-12-16 06:00:00	SPY	ETF	318.48	318.73	318.48	318.66	16840.0
2019-12-16 06:30:00	SPY	ETF	318.64	318.8	318.61	318.61	21914.0
2019-12-16 07:00:00	SPY	ETF	318.61	318.82	318.61	318.79	90322.0
2019-12-16 07:30:00	SPY	ETF	318.79	318.95	318.75	318.92	63048.0
2019-12-16 08:00:00	SPY	ETF	318.95	319.05	318.3	318.92	183229.0
2019-12-16 08:30:00	SPY	ETF	318.92	319.29	318.92	319.26	132404.0
2019-12-16 09:00:00	SPY	ETF	319.22	319.32	319.18	319.18	233014.0
2019-12-16 09:30:00	SPY	ETF	319.22	319.72	319.17	319.4	8948903.0
2019-12-16 10:00:00	SPY	ETF	319.41	320.05	319.39	319.92	7977095.0
2019-12-16 10:30:00	SPY	ETF	319.93	320.06	319.81	319.885	4400262.0
2019-12-16 11:00:00	SPY	ETF	319.88	319.96	319.74	319.925	5463369.0
2019-12-16 11:30:00	SPY	ETF	319.925	320.05	319.82	320.001	4860138.0
2019-12-16 12:00:00	SPY	ETF	320.005	320.15	319.955	320.06	4069785.0
2019-12-16 12:30:00	SPY	ETF	320.07	320.1	319.97	319.98	2697296.0
2019-12-16 13:00:00	SPY	ETF	319.975	320.06	319.91	319.97	3220003.0
2019-12-16 13:30:00	SPY	ETF	319.975	320.12	319.85	320.05	2126432.0
2019-12-16 14:00:00	SPY	ETF	320.05	320.14	319.67	319.73	2603464.0
2019-12-16 14:30:00	SPY	ETF	319.73	319.8	319.62	319.685	2221869.0
2019-12-16 15:00:00	SPY	ETF	319.68	319.9	319.61	319.7	3595041.0
2019-12-16 15:30:00	SPY	ETF	319.695	319.9	319.49	319.51	10873970.0
2019-12-16 16:00:00	SPY	ETF	319.51	319.81	319.44	319.74	8126751.0
2019-12-16 16:30:00	SPY	ETF	319.74	319.87	319.5	319.67	4885950.0
2019-12-16 17:00:00	SPY	ETF	319.73	319.73	319.5	319.6	166005.0
2019-12-16 17:30:00	SPY	ETF	319.6	319.63	319.5	319.63	920597.0
2019-12-16 18:00:00	SPY	ETF	319.61	319.66	319.53	319.65	26274.0
2019-12-16 18:30:00	SPY	ETF	319.57	319.57	319.39	319.39	31399.0
2019-12-16 19:00:00	SPY	ETF	319.4	319.41	319.25	319.3	32928.0
2019-12-16 19:30:00	SPY	ETF	319.32	319.37	319.26	319.34	18931.0
2019-12-16 04:00:00	QQQ	ETF	207.61	208.09	207.61	208.05	22846.0
2019-12-16 04:30:00	QQQ	ETF	207.98	208.09	207.98	208.08	6719.0
2019-12-16 05:00:00	QQQ	ETF	208.05	208.06	207.93	207.96	5107.0
2019-12-16 05:30:00	QQQ	ETF	207.99	208.03	207.9	207.97	13308.0
2019-12-16 06:00:00	QQQ	ETF	207.99	208.13	207.99	208.11	8950.0
2019-12-16 06:30:00	QQQ	ETF	208.08	208.16	208.08	208.08	5573.0
2019-12-16 07:00:00	QQQ	ETF	208.1	208.25	208.07	208.25	56099.0
2019-12-16 07:30:00	QQQ	ETF	208.22	208.35	208.2	208.33	32182.0
2019-12-16 08:00:00	QQQ	ETF	208.09	208.44	207.87	208.37	62723.0
2019-12-16 08:30:00	QQQ	ETF	208.42	208.52	208.37	208.49	73067.0
2019-12-16 09:00:00	QQQ	ETF	208.5	208.59	208.48	208.48	162102.0
2019-12-16 09:30:00	QQQ	ETF	208.49	209.2537	208.48	209.06	3222618.0
2019-12-16 10:00:00	QQQ	ETF	209.07	209.51	209.01	209.45	1296441.0
2019-12-16 10:30:00	QQQ	ETF	209.455	209.51	209.37	209.38	991187.0
2019-12-16 11:00:00	QQQ	ETF	209.38	209.46	209.33	209.42	855494.0
2019-12-16 11:30:00	QQQ	ETF	209.41	209.435	209.2299	209.3801	798463.0
2019-12-16 12:00:00	QQQ	ETF	209.3877	209.53	209.35	209.4955	983196.0
2019-12-16 12:30:00	QQQ	ETF	209.5	209.5	209.39	209.4	459299.0

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

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