PREVIEW / etf_30min / 2018-01-11

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-11.parquet
  size:    486 KB
  rows:    16,695

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-01-11 04:00:00	SPY	ETF	274.69	274.69	274.53	274.53	4120.0
2018-01-11 04:30:00	SPY	ETF	274.56	274.58	274.53	274.56	15000.0
2018-01-11 05:00:00	SPY	ETF	274.53	274.58	274.41	274.44	22010.0
2018-01-11 05:30:00	SPY	ETF	274.42	274.57	274.42	274.56	8500.0
2018-01-11 06:00:00	SPY	ETF	274.59	274.69	274.59	274.67	9800.0
2018-01-11 06:30:00	SPY	ETF	274.67	274.67	274.58	274.6	5969.0
2018-01-11 07:00:00	SPY	ETF	274.58	274.94	274.58	274.9	329026.0
2018-01-11 07:30:00	SPY	ETF	274.93	274.94	274.76	274.83	107231.0
2018-01-11 08:00:00	SPY	ETF	274.8	274.88	274.63	274.87	121261.0
2018-01-11 08:30:00	SPY	ETF	274.83	274.88	274.61	274.61	129974.0
2018-01-11 09:00:00	SPY	ETF	274.63	274.79	274.61	274.75	149007.0
2018-01-11 09:30:00	SPY	ETF	274.75	275.07	274.56	275.07	4517302.0
2018-01-11 10:00:00	SPY	ETF	275.065	275.24	274.74	274.86	3642790.0
2018-01-11 10:30:00	SPY	ETF	274.87	275.12	274.64	275.12	2882143.0
2018-01-11 11:00:00	SPY	ETF	275.12	275.3326	275.06	275.06	3840145.0
2018-01-11 11:30:00	SPY	ETF	275.06	275.2	274.99	275.1945	2087572.0
2018-01-11 12:00:00	SPY	ETF	275.2	275.44	275.13	275.36	3375912.0
2018-01-11 12:30:00	SPY	ETF	275.365	275.75	275.365	275.65	4382579.0
2018-01-11 13:00:00	SPY	ETF	275.66	275.83	275.57	275.66	3783320.0
2018-01-11 13:30:00	SPY	ETF	275.665	275.69	275.52	275.55	4932344.0
2018-01-11 14:00:00	SPY	ETF	275.555	275.59	275.48	275.57	1544145.0
2018-01-11 14:30:00	SPY	ETF	275.575	275.64	275.49	275.6	2243215.0
2018-01-11 15:00:00	SPY	ETF	275.6	275.83	275.55	275.74	4039789.0
2018-01-11 15:30:00	SPY	ETF	275.73	276.09	275.61	276.08	11373970.0
2018-01-11 16:00:00	SPY	ETF	276.08	276.28	274.8904	274.8904	4953334.0
2018-01-11 16:30:00	SPY	ETF	276.2	276.3	275.955	276.24	1372811.0
2018-01-11 17:00:00	SPY	ETF	276.22	276.22	276.12	276.18	233784.0
2018-01-11 17:30:00	SPY	ETF	276.2	276.22	276.13	276.13	17809.0
2018-01-11 18:00:00	SPY	ETF	276.15	276.22	276.13	276.13	51585.0
2018-01-11 18:30:00	SPY	ETF	276.13	276.16	276.13	276.16	5678.0
2018-01-11 19:00:00	SPY	ETF	276.15	276.15	275.99	276.09	42313.0
2018-01-11 19:30:00	SPY	ETF	276.04	276.14	276.03	276.12	7222.0
2018-01-11 04:00:00	QQQ	ETF	162.39	162.39	162.39	162.39	100.0
2018-01-11 04:30:00	QQQ	ETF	162.38	162.42	162.38	162.42	22500.0
2018-01-11 05:00:00	QQQ	ETF	162.41	162.41	162.3	162.3	1300.0
2018-01-11 05:30:00	QQQ	ETF	162.4	162.42	162.39	162.39	1400.0
2018-01-11 06:00:00	QQQ	ETF	162.42	162.48	162.4	162.48	6300.0
2018-01-11 06:30:00	QQQ	ETF	162.5	162.5	162.42	162.48	3102.0
2018-01-11 07:00:00	QQQ	ETF	162.48	162.68	162.47	162.67	28945.0
2018-01-11 07:30:00	QQQ	ETF	162.78	162.78	162.67	162.7	24332.0
2018-01-11 08:00:00	QQQ	ETF	162.18	162.72	162.18	162.63	45016.0
2018-01-11 08:30:00	QQQ	ETF	162.63	162.66	162.47	162.5	64995.0
2018-01-11 09:00:00	QQQ	ETF	162.48	162.57	162.48	162.5	70100.0
2018-01-11 09:30:00	QQQ	ETF	162.48	162.62	162.32	162.5936	1887333.0
2018-01-11 10:00:00	QQQ	ETF	162.585	162.76	162.4	162.46	1637748.0
2018-01-11 10:30:00	QQQ	ETF	162.455	162.56	162.21	162.54	1294026.0
2018-01-11 11:00:00	QQQ	ETF	162.54	162.68	162.52	162.52	916554.0
2018-01-11 11:30:00	QQQ	ETF	162.53	162.71	162.51	162.6956	412123.0
2018-01-11 12:00:00	QQQ	ETF	162.69	162.875	162.6	162.81	613859.0
2018-01-11 12:30:00	QQQ	ETF	162.82	163.13	162.801	163.11	1236272.0

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

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