PREVIEW / etf_30min / 2019-12-17

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-17.parquet
  size:    523 KB
  rows:    18,518

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-17 04:00:00	SPY	ETF	319.72	319.72	319.48	319.48	8288.0
2019-12-17 04:30:00	SPY	ETF	319.49	319.61	319.49	319.61	3212.0
2019-12-17 05:00:00	SPY	ETF	319.6	319.65	319.6	319.62	1403.0
2019-12-17 05:30:00	SPY	ETF	319.57	319.57	319.16	319.4	4337.0
2019-12-17 06:00:00	SPY	ETF	319.3	319.37	319.17	319.37	9451.0
2019-12-17 06:30:00	SPY	ETF	319.43	319.55	319.34	319.5	10597.0
2019-12-17 07:00:00	SPY	ETF	319.56	319.75	319.53	319.75	20304.0
2019-12-17 07:30:00	SPY	ETF	319.72	319.83	319.67	319.67	18179.0
2019-12-17 08:00:00	SPY	ETF	319.59	320.12	319.5	319.85	54381.0
2019-12-17 08:30:00	SPY	ETF	319.85	320.25	319.75	320.06	248330.0
2019-12-17 09:00:00	SPY	ETF	320.02	320.14	319.84	319.84	222339.0
2019-12-17 09:30:00	SPY	ETF	319.92	320.25	319.53	319.58	4464459.0
2019-12-17 10:00:00	SPY	ETF	319.59	320.12	319.53	320.02	3122184.0
2019-12-17 10:30:00	SPY	ETF	320.02	320.04	319.6932	319.7	2998151.0
2019-12-17 11:00:00	SPY	ETF	319.71	319.86	319.67	319.7631	1711373.0
2019-12-17 11:30:00	SPY	ETF	319.77	319.9599	319.6199	319.91	2219636.0
2019-12-17 12:00:00	SPY	ETF	319.905	320.0	319.88	319.97	2481334.0
2019-12-17 12:30:00	SPY	ETF	319.975	320.07	319.88	320.02	4134496.0
2019-12-17 13:00:00	SPY	ETF	320.02	320.025	319.74	319.7486	1313846.0
2019-12-17 13:30:00	SPY	ETF	319.74	319.9	319.51	319.89	2405108.0
2019-12-17 14:00:00	SPY	ETF	319.89	319.9862	319.67	319.73	4082161.0
2019-12-17 14:30:00	SPY	ETF	319.735	319.96	319.73	319.84	3856287.0
2019-12-17 15:00:00	SPY	ETF	319.83	319.94	319.71	319.87	4478201.0
2019-12-17 15:30:00	SPY	ETF	319.87	319.93	319.48	319.56	9427216.0
2019-12-17 16:00:00	SPY	ETF	319.55	319.6204	319.41	319.41	8712818.0
2019-12-17 16:30:00	SPY	ETF	319.41	319.57	319.24	319.36	1323913.0
2019-12-17 17:00:00	SPY	ETF	319.39	319.57	319.19	319.57	2518154.0
2019-12-17 17:30:00	SPY	ETF	319.25	319.3	319.25	319.28	21002.0
2019-12-17 18:00:00	SPY	ETF	319.3	319.49	319.29	319.49	39825.0
2019-12-17 18:30:00	SPY	ETF	319.46	319.49	319.38	319.42	11982.0
2019-12-17 19:00:00	SPY	ETF	319.43	319.48	319.39	319.45	7130.0
2019-12-17 19:30:00	SPY	ETF	319.44	319.44	319.38	319.38	8472.0
2019-12-17 04:00:00	QQQ	ETF	209.41	209.41	209.18	209.18	7443.0
2019-12-17 04:30:00	QQQ	ETF	209.18	209.34	209.18	209.33	7500.0
2019-12-17 05:00:00	QQQ	ETF	209.33	209.37	209.27	209.29	8022.0
2019-12-17 05:30:00	QQQ	ETF	209.26	209.28	209.1	209.17	9189.0
2019-12-17 06:00:00	QQQ	ETF	209.17	209.2	209.0	209.2	15144.0
2019-12-17 06:30:00	QQQ	ETF	209.22	209.22	209.08	209.17	9619.0
2019-12-17 07:00:00	QQQ	ETF	209.19	209.33	209.19	209.33	13403.0
2019-12-17 07:30:00	QQQ	ETF	209.28	209.38	209.23	209.25	23467.0
2019-12-17 08:00:00	QQQ	ETF	209.3	209.74	209.1	209.39	34365.0
2019-12-17 08:30:00	QQQ	ETF	209.38	209.67	209.36	209.53	69737.0
2019-12-17 09:00:00	QQQ	ETF	209.46	209.59	209.42	209.5	76018.0
2019-12-17 09:30:00	QQQ	ETF	209.49	209.71	209.04	209.07	2061430.0
2019-12-17 10:00:00	QQQ	ETF	209.07	209.46	209.04	209.3815	852248.0
2019-12-17 10:30:00	QQQ	ETF	209.3737	209.45	209.15	209.17	676692.0
2019-12-17 11:00:00	QQQ	ETF	209.18	209.29	209.13	209.23	491710.0
2019-12-17 11:30:00	QQQ	ETF	209.24	209.36	209.14	209.24	523555.0
2019-12-17 12:00:00	QQQ	ETF	209.255	209.385	209.23	209.38	350480.0
2019-12-17 12:30:00	QQQ	ETF	209.375	209.3937	209.27	209.35	329105.0

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

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