PREVIEW / etf_30min / 2020-04-27

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-27.parquet
  size:    571 KB
  rows:    20,712

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-27 04:00:00	SPY	ETF	285.69	285.8	284.89	285.23	60718.0
2020-04-27 04:30:00	SPY	ETF	285.18	285.9	284.98	285.59	80558.0
2020-04-27 05:00:00	SPY	ETF	285.61	286.15	285.25	286.1	58922.0
2020-04-27 05:30:00	SPY	ETF	286.16	286.43	286.0	286.18	144106.0
2020-04-27 06:00:00	SPY	ETF	285.98	286.03	285.6	285.78	55509.0
2020-04-27 06:30:00	SPY	ETF	285.78	285.92	285.4	285.41	126368.0
2020-04-27 07:00:00	SPY	ETF	285.46	285.69	285.2	285.64	208518.0
2020-04-27 07:30:00	SPY	ETF	285.68	285.94	285.54	285.65	172585.0
2020-04-27 08:00:00	SPY	ETF	285.83	286.62	284.59	285.96	430570.0
2020-04-27 08:30:00	SPY	ETF	286.0	286.5	285.68	285.73	315468.0
2020-04-27 09:00:00	SPY	ETF	285.77	286.17	284.98	284.99	339086.0
2020-04-27 09:30:00	SPY	ETF	285.12	285.75	284.62	285.52	6761778.0
2020-04-27 10:00:00	SPY	ETF	285.52	286.29	285.16	285.85	5919141.0
2020-04-27 10:30:00	SPY	ETF	285.84	286.41	285.5	285.69	4688774.0
2020-04-27 11:00:00	SPY	ETF	285.68	286.67	285.42	286.6199	3433009.0
2020-04-27 11:30:00	SPY	ETF	286.615	287.21	286.5	286.91	5505437.0
2020-04-27 12:00:00	SPY	ETF	286.91	287.0	286.42	286.7	3544759.0
2020-04-27 12:30:00	SPY	ETF	286.7011	287.35	286.7	287.07	4158487.0
2020-04-27 13:00:00	SPY	ETF	287.07	287.09	286.17	286.5425	3606259.0
2020-04-27 13:30:00	SPY	ETF	286.54	286.71	286.1	286.515	3657383.0
2020-04-27 14:00:00	SPY	ETF	286.51	287.13	286.51	286.857	2239137.0
2020-04-27 14:30:00	SPY	ETF	286.86	287.6	286.765	287.36	4893456.0
2020-04-27 15:00:00	SPY	ETF	287.36	287.9	287.26	287.5184	5919632.0
2020-04-27 15:30:00	SPY	ETF	287.515	288.27	287.04	287.11	13126914.0
2020-04-27 16:00:00	SPY	ETF	287.11	287.3	286.75	287.11	5223079.0
2020-04-27 16:30:00	SPY	ETF	287.1	287.53	286.91	286.91	1837100.0
2020-04-27 17:00:00	SPY	ETF	287.01	287.05	286.9	287.0	71304.0
2020-04-27 17:30:00	SPY	ETF	287.01	287.12	286.88	287.06	78801.0
2020-04-27 18:00:00	SPY	ETF	287.06	287.08	286.47	287.06	176905.0
2020-04-27 18:30:00	SPY	ETF	287.0	287.0	286.74	286.79	64496.0
2020-04-27 19:00:00	SPY	ETF	286.79	287.43	286.79	287.08	65226.0
2020-04-27 19:30:00	SPY	ETF	287.08	287.18	286.81	286.97	70876.0
2020-04-27 04:00:00	QQQ	ETF	216.55	216.65	216.04	216.13	19727.0
2020-04-27 04:30:00	QQQ	ETF	216.15	216.56	215.98	216.56	12219.0
2020-04-27 05:00:00	QQQ	ETF	216.37	216.89	216.37	216.87	22564.0
2020-04-27 05:30:00	QQQ	ETF	216.97	217.09	216.79	216.83	8582.0
2020-04-27 06:00:00	QQQ	ETF	216.82	216.82	216.48	216.48	16402.0
2020-04-27 06:30:00	QQQ	ETF	216.52	216.67	216.21	216.25	57619.0
2020-04-27 07:00:00	QQQ	ETF	216.26	216.57	216.12	216.55	120743.0
2020-04-27 07:30:00	QQQ	ETF	216.58	216.83	216.5	216.56	99141.0
2020-04-27 08:00:00	QQQ	ETF	216.61	217.0	215.78	216.62	98153.0
2020-04-27 08:30:00	QQQ	ETF	216.76	216.94	216.4	216.44	113901.0
2020-04-27 09:00:00	QQQ	ETF	216.43	216.73	216.1	216.17	168620.0
2020-04-27 09:30:00	QQQ	ETF	216.18	216.43	215.25	216.37	4309575.0
2020-04-27 10:00:00	QQQ	ETF	216.37	216.63	215.71	215.96	2521224.0
2020-04-27 10:30:00	QQQ	ETF	215.9699	216.06	215.1062	215.2	2248974.0
2020-04-27 11:00:00	QQQ	ETF	215.17	216.285	214.95	216.19	1950120.0
2020-04-27 11:30:00	QQQ	ETF	216.18	216.33	215.72	215.86	2160526.0
2020-04-27 12:00:00	QQQ	ETF	215.87	215.98	215.1914	215.5	2056894.0
2020-04-27 12:30:00	QQQ	ETF	215.5	216.06	215.43	215.66	1391987.0

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

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