PREVIEW / etf_30min / 2018-05-17

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-17.parquet
  size:    454 KB
  rows:    15,654

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
2018-05-17 04:00:00	SPY	ETF	271.95	271.95	271.72	271.85	3809.0
2018-05-17 04:30:00	SPY	ETF	271.9	271.9	271.65	271.65	900.0
2018-05-17 05:00:00	SPY	ETF	271.78	271.9	271.77	271.9	1825.0
2018-05-17 05:30:00	SPY	ETF	271.96	272.01	271.85	271.91	4300.0
2018-05-17 06:00:00	SPY	ETF	272.06	272.06	271.8	271.8	4950.0
2018-05-17 06:30:00	SPY	ETF	271.89	271.9	271.8	271.8	87300.0
2018-05-17 07:00:00	SPY	ETF	271.78	271.87	271.71	271.85	96583.0
2018-05-17 07:30:00	SPY	ETF	271.85	271.96	271.75	271.76	104467.0
2018-05-17 08:00:00	SPY	ETF	271.75	272.37	271.7	271.81	169667.0
2018-05-17 08:30:00	SPY	ETF	271.82	271.85	271.54	271.84	277216.0
2018-05-17 09:00:00	SPY	ETF	271.85	272.08	271.83	271.93	178912.0
2018-05-17 09:30:00	SPY	ETF	271.94	272.08	271.38	271.875	4644928.0
2018-05-17 10:00:00	SPY	ETF	271.88	272.76	271.87	272.6008	3979023.0
2018-05-17 10:30:00	SPY	ETF	272.61	273.23	272.55	273.14	3965004.0
2018-05-17 11:00:00	SPY	ETF	273.14	273.2	272.76	272.9	2731218.0
2018-05-17 11:30:00	SPY	ETF	272.91	272.94	272.53	272.56	2627198.0
2018-05-17 12:00:00	SPY	ETF	272.5589	272.84	272.43	272.72	2178873.0
2018-05-17 12:30:00	SPY	ETF	272.72	272.84	272.1	272.28	2279930.0
2018-05-17 13:00:00	SPY	ETF	272.26	272.49	272.08	272.31	1657186.0
2018-05-17 13:30:00	SPY	ETF	272.33	272.38	271.465	271.52	3053827.0
2018-05-17 14:00:00	SPY	ETF	271.52	271.99	271.13	271.89	5931494.0
2018-05-17 14:30:00	SPY	ETF	271.88	272.22	271.8	272.19	3543321.0
2018-05-17 15:00:00	SPY	ETF	272.19	272.34	271.76	271.8	3844813.0
2018-05-17 15:30:00	SPY	ETF	271.8	272.15	271.67	272.01	8264130.0
2018-05-17 16:00:00	SPY	ETF	272.04	272.06	271.85	271.91	4928286.0
2018-05-17 16:30:00	SPY	ETF	271.92	272.01	271.9	271.91	250613.0
2018-05-17 17:00:00	SPY	ETF	271.95	271.95	271.86	271.86	15422.0
2018-05-17 17:30:00	SPY	ETF	271.89	272.01	271.89	271.91	25455.0
2018-05-17 18:00:00	SPY	ETF	271.9	271.9	271.68	271.9	42335.0
2018-05-17 18:30:00	SPY	ETF	271.88	272.4	271.81	272.12	78270.0
2018-05-17 19:00:00	SPY	ETF	272.17	272.32	272.17	272.24	6012.0
2018-05-17 19:30:00	SPY	ETF	272.17	272.28	272.01	272.24	17608.0
2018-05-17 04:00:00	QQQ	ETF	168.52	168.52	168.33	168.43	6987.0
2018-05-17 04:30:00	QQQ	ETF	168.4	168.4	168.36	168.36	600.0
2018-05-17 05:00:00	QQQ	ETF	168.34	168.36	168.34	168.36	1400.0
2018-05-17 05:30:00	QQQ	ETF	168.43	168.45	168.43	168.45	800.0
2018-05-17 06:00:00	QQQ	ETF	168.5	168.53	168.39	168.39	2700.0
2018-05-17 06:30:00	QQQ	ETF	168.42	168.44	168.32	168.32	15700.0
2018-05-17 07:00:00	QQQ	ETF	168.34	168.38	168.28	168.38	143731.0
2018-05-17 07:30:00	QQQ	ETF	168.39	168.51	168.34	168.35	42409.0
2018-05-17 08:00:00	QQQ	ETF	168.35	168.45	168.22	168.33	178552.0
2018-05-17 08:30:00	QQQ	ETF	168.33	168.49	168.06	168.26	245653.0
2018-05-17 09:00:00	QQQ	ETF	168.26	168.44	168.26	168.42	187389.0
2018-05-17 09:30:00	QQQ	ETF	168.4	168.7	168.26	168.46	1979741.0
2018-05-17 10:00:00	QQQ	ETF	168.47	169.09	168.45	169.0107	1478148.0
2018-05-17 10:30:00	QQQ	ETF	169.03	169.61	168.94	169.55	4218304.0
2018-05-17 11:00:00	QQQ	ETF	169.55	169.56	169.24	169.28	1193438.0
2018-05-17 11:30:00	QQQ	ETF	169.3	169.34	168.97	168.98	848080.0
2018-05-17 12:00:00	QQQ	ETF	168.98	169.19	168.8801	169.0932	691093.0
2018-05-17 12:30:00	QQQ	ETF	169.09	169.18	168.45	168.54	1097625.0

> showing 50 of 15,654 rows — these rows as CSV

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