PREVIEW / etf_30min / 2020-04-17

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-17.parquet
  size:    582 KB
  rows:    21,358

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-17 04:00:00	SPY	ETF	286.15	287.54	286.15	286.32	125468.0
2020-04-17 04:30:00	SPY	ETF	286.3	286.84	285.95	285.98	97389.0
2020-04-17 05:00:00	SPY	ETF	285.97	286.69	285.7	285.91	87946.0
2020-04-17 05:30:00	SPY	ETF	285.9	287.41	285.56	286.81	93340.0
2020-04-17 06:00:00	SPY	ETF	286.98	287.87	286.68	287.56	90093.0
2020-04-17 06:30:00	SPY	ETF	287.52	287.85	287.2	287.65	334105.0
2020-04-17 07:00:00	SPY	ETF	287.56	288.13	287.09	287.17	435054.0
2020-04-17 07:30:00	SPY	ETF	287.25	287.45	286.64	287.13	537226.0
2020-04-17 08:00:00	SPY	ETF	288.0399	288.5	285.91	286.49	839148.0
2020-04-17 08:30:00	SPY	ETF	286.5	286.71	285.8	286.3	813955.0
2020-04-17 09:00:00	SPY	ETF	286.29	286.45	284.95	285.37	1767080.0
2020-04-17 09:30:00	SPY	ETF	285.38	285.68	284.06	285.46	16897405.0
2020-04-17 10:00:00	SPY	ETF	285.47	285.67	283.3608	283.753	14663980.0
2020-04-17 10:30:00	SPY	ETF	283.78	283.92	282.55	283.38	13414144.0
2020-04-17 11:00:00	SPY	ETF	283.385	284.0	282.4	282.71	8735293.0
2020-04-17 11:30:00	SPY	ETF	282.71	283.84	282.46	283.51	7309558.0
2020-04-17 12:00:00	SPY	ETF	283.53	283.94	282.92	283.34	7803694.0
2020-04-17 12:30:00	SPY	ETF	283.36	284.65	283.27	284.34	5282275.0
2020-04-17 13:00:00	SPY	ETF	284.33	284.77	283.95	283.9921	5115101.0
2020-04-17 13:30:00	SPY	ETF	283.9981	284.547	283.77	284.0801	5845229.0
2020-04-17 14:00:00	SPY	ETF	284.08	284.08	283.3808	283.45	4959507.0
2020-04-17 14:30:00	SPY	ETF	283.45	283.65	282.65	283.62	4701244.0
2020-04-17 15:00:00	SPY	ETF	283.62	284.6799	283.5	284.62	5910818.0
2020-04-17 15:30:00	SPY	ETF	284.61	287.3	284.61	286.73	27136762.0
2020-04-17 16:00:00	SPY	ETF	286.72	288.0	284.2049	287.25	9635126.0
2020-04-17 16:30:00	SPY	ETF	287.26	287.39	286.64	287.15	772833.0
2020-04-17 17:00:00	SPY	ETF	287.24	287.29	286.64	287.0	301806.0
2020-04-17 17:30:00	SPY	ETF	287.0	287.1	286.64	286.65	1331095.0
2020-04-17 18:00:00	SPY	ETF	286.64	286.69	286.41	286.41	99426.0
2020-04-17 18:30:00	SPY	ETF	286.41	286.5	286.31	286.44	26610.0
2020-04-17 19:00:00	SPY	ETF	286.44	286.65	286.4	286.55	34074.0
2020-04-17 19:30:00	SPY	ETF	286.6	286.7	286.42	286.66	48894.0
2020-04-17 04:00:00	QQQ	ETF	216.98	217.8	216.95	216.95	45471.0
2020-04-17 04:30:00	QQQ	ETF	216.8	217.46	216.71	216.98	29430.0
2020-04-17 05:00:00	QQQ	ETF	216.98	217.4	216.83	217.05	26855.0
2020-04-17 05:30:00	QQQ	ETF	217.0	217.88	216.8	217.62	25969.0
2020-04-17 06:00:00	QQQ	ETF	217.73	218.24	217.54	218.0	32021.0
2020-04-17 06:30:00	QQQ	ETF	217.9	218.12	217.89	218.02	140949.0
2020-04-17 07:00:00	QQQ	ETF	218.06	218.38	217.43	217.51	146298.0
2020-04-17 07:30:00	QQQ	ETF	217.52	217.53	217.15	217.3	280733.0
2020-04-17 08:00:00	QQQ	ETF	218.2601	218.48	216.88	216.98	261210.0
2020-04-17 08:30:00	QQQ	ETF	216.97	217.09	216.62	216.81	292159.0
2020-04-17 09:00:00	QQQ	ETF	216.7401	216.95	215.64	215.93	908564.0
2020-04-17 09:30:00	QQQ	ETF	215.96	216.51	213.89	215.35	9047104.0
2020-04-17 10:00:00	QQQ	ETF	215.31	215.89	214.26	214.6	4966214.0
2020-04-17 10:30:00	QQQ	ETF	214.6099	214.695	213.325	213.95	3614367.0
2020-04-17 11:00:00	QQQ	ETF	213.95	214.42	212.74	212.96	3033444.0
2020-04-17 11:30:00	QQQ	ETF	212.965	213.97	212.71	213.45	2854238.0
2020-04-17 12:00:00	QQQ	ETF	213.45	213.54	212.77	213.09	2030348.0
2020-04-17 12:30:00	QQQ	ETF	213.11	213.9694	213.035	213.705	1801304.0

> showing 50 of 21,358 rows — these rows as CSV

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