PREVIEW / etf_30min / 2020-04-03

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-03.parquet
  size:    559 KB
  rows:    20,548

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
2020-04-03 04:00:00	SPY	ETF	250.0	250.26	249.0	249.05	37299.0
2020-04-03 04:30:00	SPY	ETF	249.29	249.29	248.44	249.14	33741.0
2020-04-03 05:00:00	SPY	ETF	249.14	249.45	248.23	248.79	41407.0
2020-04-03 05:30:00	SPY	ETF	248.68	249.44	248.02	249.42	55085.0
2020-04-03 06:00:00	SPY	ETF	249.45	249.7	248.8	249.05	51968.0
2020-04-03 06:30:00	SPY	ETF	248.91	249.82	248.91	249.6	61300.0
2020-04-03 07:00:00	SPY	ETF	249.59	250.0	249.38	249.79	148756.0
2020-04-03 07:30:00	SPY	ETF	249.75	253.03	249.75	252.65	674215.0
2020-04-03 08:00:00	SPY	ETF	249.9301	252.97	248.2	250.11	1342242.0
2020-04-03 08:30:00	SPY	ETF	250.1	252.19	248.75	251.32	2152590.0
2020-04-03 09:00:00	SPY	ETF	251.32	252.5499	250.5	250.74	1320747.0
2020-04-03 09:30:00	SPY	ETF	250.76	253.32	250.48	251.8	14148515.0
2020-04-03 10:00:00	SPY	ETF	251.85	252.74	249.8809	250.17	8890696.0
2020-04-03 10:30:00	SPY	ETF	250.23	250.53	248.78	249.64	8846145.0
2020-04-03 11:00:00	SPY	ETF	249.63	250.29	247.95	248.47	7788269.0
2020-04-03 11:30:00	SPY	ETF	248.47	249.15	247.4	248.217	8506109.0
2020-04-03 12:00:00	SPY	ETF	248.21	248.55	246.35	247.0201	6808326.0
2020-04-03 12:30:00	SPY	ETF	247.0209	248.05	246.81	247.575	6657672.0
2020-04-03 13:00:00	SPY	ETF	247.5758	248.18	246.57	246.7	4353811.0
2020-04-03 13:30:00	SPY	ETF	246.69	246.79	245.65	246.09	6665360.0
2020-04-03 14:00:00	SPY	ETF	246.08	246.93	245.22	246.82	7389462.0
2020-04-03 14:30:00	SPY	ETF	246.82	247.78	245.64	247.71	6417570.0
2020-04-03 15:00:00	SPY	ETF	247.7	248.26	246.6469	247.3816	9077899.0
2020-04-03 15:30:00	SPY	ETF	247.385	249.17	245.86	248.21	24436039.0
2020-04-03 16:00:00	SPY	ETF	248.27	249.1	247.88	248.55	5976358.0
2020-04-03 16:30:00	SPY	ETF	248.55	248.82	248.14	248.36	469255.0
2020-04-03 17:00:00	SPY	ETF	248.2	248.6	248.19	248.46	591160.0
2020-04-03 17:30:00	SPY	ETF	248.47	248.5	248.19	248.33	119127.0
2020-04-03 18:00:00	SPY	ETF	248.28	248.4	248.01	248.02	891952.0
2020-04-03 18:30:00	SPY	ETF	248.02	248.02	247.8	247.86	73271.0
2020-04-03 19:00:00	SPY	ETF	247.94	248.09	247.74	247.74	61650.0
2020-04-03 19:30:00	SPY	ETF	247.73	247.99	247.53	247.92	71342.0
2020-04-03 04:00:00	QQQ	ETF	184.7	185.0	184.06	184.06	14460.0
2020-04-03 04:30:00	QQQ	ETF	184.28	184.28	183.59	184.04	20797.0
2020-04-03 05:00:00	QQQ	ETF	184.12	184.33	183.62	183.87	8661.0
2020-04-03 05:30:00	QQQ	ETF	183.71	184.37	183.47	184.23	22103.0
2020-04-03 06:00:00	QQQ	ETF	184.4	184.52	184.01	184.11	25675.0
2020-04-03 06:30:00	QQQ	ETF	184.29	184.72	184.11	184.5	19156.0
2020-04-03 07:00:00	QQQ	ETF	184.48	184.78	184.27	184.55	56797.0
2020-04-03 07:30:00	QQQ	ETF	184.57	186.81	184.57	186.55	139776.0
2020-04-03 08:00:00	QQQ	ETF	186.51	186.73	183.99	185.07	253525.0
2020-04-03 08:30:00	QQQ	ETF	184.9	186.35	184.27	185.55	293194.0
2020-04-03 09:00:00	QQQ	ETF	185.5	186.5	185.25	185.52	250007.0
2020-04-03 09:30:00	QQQ	ETF	185.47	187.0716	184.93	186.13	4606533.0
2020-04-03 10:00:00	QQQ	ETF	186.13	186.77	184.57	184.8	3480297.0
2020-04-03 10:30:00	QQQ	ETF	184.82	184.99	183.91	184.37	3162537.0
2020-04-03 11:00:00	QQQ	ETF	184.37	184.77	183.47	183.79	2825492.0
2020-04-03 11:30:00	QQQ	ETF	183.8	184.33	183.1	183.64	2162424.0
2020-04-03 12:00:00	QQQ	ETF	183.67	183.89	182.33	182.78	2243256.0
2020-04-03 12:30:00	QQQ	ETF	182.72	183.32	182.5443	183.08	1659405.0

> showing 50 of 20,548 rows — these rows as CSV

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