PREVIEW / etf_30min / 2019-12-05

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-05.parquet
  size:    508 KB
  rows:    17,703

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-05 04:00:00	SPY	ETF	311.92	311.94	311.63	311.71	3940.0
2019-12-05 04:30:00	SPY	ETF	311.72	312.1	311.72	312.1	6865.0
2019-12-05 05:00:00	SPY	ETF	312.12	312.12	311.99	312.06	2530.0
2019-12-05 05:30:00	SPY	ETF	312.11	312.62	312.11	312.39	26704.0
2019-12-05 06:00:00	SPY	ETF	312.41	312.65	312.39	312.63	14316.0
2019-12-05 06:30:00	SPY	ETF	312.57	312.67	312.45	312.49	18677.0
2019-12-05 07:00:00	SPY	ETF	312.44	312.53	312.33	312.36	45458.0
2019-12-05 07:30:00	SPY	ETF	312.36	312.36	312.26	312.36	40187.0
2019-12-05 08:00:00	SPY	ETF	312.32	312.51	311.22	312.3	201489.0
2019-12-05 08:30:00	SPY	ETF	312.34	312.39	312.1	312.16	138000.0
2019-12-05 09:00:00	SPY	ETF	312.21	312.25	312.02	312.22	77937.0
2019-12-05 09:30:00	SPY	ETF	312.23	312.25	311.35	311.45	3424051.0
2019-12-05 10:00:00	SPY	ETF	311.43	311.455	310.58	311.223	4165651.0
2019-12-05 10:30:00	SPY	ETF	311.2206	311.48	311.04	311.36	2152266.0
2019-12-05 11:00:00	SPY	ETF	311.36	311.61	311.18	311.44	1843155.0
2019-12-05 11:30:00	SPY	ETF	311.42	311.49	311.04	311.2961	1282433.0
2019-12-05 12:00:00	SPY	ETF	311.29	311.49	311.135	311.269	1006253.0
2019-12-05 12:30:00	SPY	ETF	311.26	311.28	311.06	311.25	983645.0
2019-12-05 13:00:00	SPY	ETF	311.25	311.41	311.17	311.34	2175040.0
2019-12-05 13:30:00	SPY	ETF	311.34	311.72	311.28	311.57	2076105.0
2019-12-05 14:00:00	SPY	ETF	311.57	311.85	311.47	311.81	1682929.0
2019-12-05 14:30:00	SPY	ETF	311.81	311.99	311.11	311.58	5078319.0
2019-12-05 15:00:00	SPY	ETF	311.59	312.09	311.54	312.07	4658052.0
2019-12-05 15:30:00	SPY	ETF	312.07	312.2	311.76	312.04	5712651.0
2019-12-05 16:00:00	SPY	ETF	312.05	312.12	311.91	311.97	2778107.0
2019-12-05 16:30:00	SPY	ETF	311.97	312.05	311.93	312.04	400839.0
2019-12-05 17:00:00	SPY	ETF	312.05	312.06	311.96	312.05	31439.0
2019-12-05 17:30:00	SPY	ETF	312.05	312.05	311.97	312.01	8045.0
2019-12-05 18:00:00	SPY	ETF	312.03	312.12	311.98	312.1	53931.0
2019-12-05 18:30:00	SPY	ETF	312.09	312.15	312.09	312.1	8298.0
2019-12-05 19:00:00	SPY	ETF	312.15	312.41	312.15	312.26	19972.0
2019-12-05 19:30:00	SPY	ETF	312.3	312.52	312.3	312.45	38561.0
2019-12-05 04:00:00	QQQ	ETF	202.84	202.84	202.6	202.67	5614.0
2019-12-05 04:30:00	QQQ	ETF	202.68	202.95	202.68	202.9	15400.0
2019-12-05 05:00:00	QQQ	ETF	202.91	202.94	202.86	202.9	2072.0
2019-12-05 05:30:00	QQQ	ETF	203.0	203.36	203.0	203.21	24880.0
2019-12-05 06:00:00	QQQ	ETF	203.23	203.44	203.17	203.41	9131.0
2019-12-05 06:30:00	QQQ	ETF	203.35	203.45	203.27	203.27	9256.0
2019-12-05 07:00:00	QQQ	ETF	203.28	203.4	203.22	203.28	40462.0
2019-12-05 07:30:00	QQQ	ETF	203.27	203.27	203.13	203.24	40498.0
2019-12-05 08:00:00	QQQ	ETF	203.16	203.36	202.25	203.26	90353.0
2019-12-05 08:30:00	QQQ	ETF	203.27	203.33	203.07	203.1	104781.0
2019-12-05 09:00:00	QQQ	ETF	203.14	203.15	203.02	203.15	66875.0
2019-12-05 09:30:00	QQQ	ETF	203.15	203.15	202.56	202.64	1672158.0
2019-12-05 10:00:00	QQQ	ETF	202.64	202.66	201.84	202.2328	1403505.0
2019-12-05 10:30:00	QQQ	ETF	202.25	202.435	202.13	202.31	813155.0
2019-12-05 11:00:00	QQQ	ETF	202.3	202.4875	202.11	202.35	680656.0
2019-12-05 11:30:00	QQQ	ETF	202.34	202.38	202.07	202.32	487516.0
2019-12-05 12:00:00	QQQ	ETF	202.3	202.43	202.19	202.29	269588.0
2019-12-05 12:30:00	QQQ	ETF	202.29	202.3089	202.13	202.2645	300781.0

> showing 50 of 17,703 rows — these rows as CSV

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