PREVIEW / etf_30min / 2018-06-05

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-05.parquet
  size:    466 KB
  rows:    16,074

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-06-05 04:00:00	SPY	ETF	275.0	275.12	274.96	275.11	12185.0
2018-06-05 04:30:00	SPY	ETF	275.1	275.17	275.05	275.16	13000.0
2018-06-05 05:00:00	SPY	ETF	275.14	275.32	275.04	275.31	20909.0
2018-06-05 05:30:00	SPY	ETF	275.27	275.44	275.16	275.42	22107.0
2018-06-05 06:00:00	SPY	ETF	275.44	275.44	275.15	275.15	25852.0
2018-06-05 06:30:00	SPY	ETF	275.15	275.27	275.07	275.13	68700.0
2018-06-05 07:00:00	SPY	ETF	275.13	275.31	275.13	275.24	36900.0
2018-06-05 07:30:00	SPY	ETF	275.22	275.27	275.11	275.14	32907.0
2018-06-05 08:00:00	SPY	ETF	275.19	275.28	274.69	274.82	234101.0
2018-06-05 08:30:00	SPY	ETF	274.82	274.93	274.73	274.75	169212.0
2018-06-05 09:00:00	SPY	ETF	274.76	275.04	274.7	275.01	225951.0
2018-06-05 09:30:00	SPY	ETF	275.05	275.2	274.82	275.2	3714087.0
2018-06-05 10:00:00	SPY	ETF	275.2	275.527	275.16	275.4	3691563.0
2018-06-05 10:30:00	SPY	ETF	275.3954	275.53	274.87	275.1375	3305159.0
2018-06-05 11:00:00	SPY	ETF	275.13	275.175	274.481	274.71	3597954.0
2018-06-05 11:30:00	SPY	ETF	274.72	274.74	274.181	274.5	3107740.0
2018-06-05 12:00:00	SPY	ETF	274.51	274.675	274.18	274.5927	2355643.0
2018-06-05 12:30:00	SPY	ETF	274.59	274.82	274.405	274.72	1993108.0
2018-06-05 13:00:00	SPY	ETF	274.71	275.05	274.675	274.96	1217898.0
2018-06-05 13:30:00	SPY	ETF	274.96	275.05	274.85	274.94	2034110.0
2018-06-05 14:00:00	SPY	ETF	274.94	275.18	274.78	275.18	1859935.0
2018-06-05 14:30:00	SPY	ETF	275.18	275.37	275.13	275.36	1499860.0
2018-06-05 15:00:00	SPY	ETF	275.35	275.37	274.92	275.01	2362492.0
2018-06-05 15:30:00	SPY	ETF	275.01	275.26	274.96	275.2	9828764.0
2018-06-05 16:00:00	SPY	ETF	275.2	275.47	274.9473	275.43	6513179.0
2018-06-05 16:30:00	SPY	ETF	275.42	275.59	275.35	275.35	165788.0
2018-06-05 17:00:00	SPY	ETF	275.39	275.43	275.33	275.42	26813.0
2018-06-05 17:30:00	SPY	ETF	275.43	275.45	275.42	275.42	45996.0
2018-06-05 18:00:00	SPY	ETF	275.41	275.5	275.37	275.37	64697.0
2018-06-05 18:30:00	SPY	ETF	275.37	275.4	275.31	275.4	9509.0
2018-06-05 19:00:00	SPY	ETF	275.37	275.38	275.32	275.36	2712.0
2018-06-05 19:30:00	SPY	ETF	275.33	275.47	275.33	275.42	12294.0
2018-06-05 20:00:00	SPY	ETF	275.1373	275.1373	275.1	275.1	832000.0
2018-06-05 04:00:00	QQQ	ETF	174.51	174.51	174.44	174.48	5627.0
2018-06-05 04:30:00	QQQ	ETF	174.53	174.61	174.53	174.61	6863.0
2018-06-05 05:00:00	QQQ	ETF	174.6	174.8	174.6	174.8	3659.0
2018-06-05 05:30:00	QQQ	ETF	174.76	175.0	174.76	174.88	21669.0
2018-06-05 06:00:00	QQQ	ETF	174.86	174.86	174.73	174.75	5193.0
2018-06-05 06:30:00	QQQ	ETF	174.73	174.76	174.66	174.66	3300.0
2018-06-05 07:00:00	QQQ	ETF	174.68	174.73	174.66	174.7	25589.0
2018-06-05 07:30:00	QQQ	ETF	174.69	174.71	174.59	174.61	19666.0
2018-06-05 08:00:00	QQQ	ETF	174.6999	174.71	174.44	174.45	103804.0
2018-06-05 08:30:00	QQQ	ETF	174.46	174.53	174.39	174.45	52765.0
2018-06-05 09:00:00	QQQ	ETF	174.44	174.74	174.4	174.67	137390.0
2018-06-05 09:30:00	QQQ	ETF	174.67	174.89	174.446	174.86	2182761.0
2018-06-05 10:00:00	QQQ	ETF	174.89	175.1157	174.82	175.01	1597086.0
2018-06-05 10:30:00	QQQ	ETF	175.01	175.13	174.65	174.901	1655913.0
2018-06-05 11:00:00	QQQ	ETF	174.905	174.94	174.36	174.4985	1950524.0
2018-06-05 11:30:00	QQQ	ETF	174.495	174.52	174.065	174.41	1430880.0
2018-06-05 12:00:00	QQQ	ETF	174.41	174.425	174.085	174.2499	933721.0

> showing 50 of 16,074 rows — these rows as CSV

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