PREVIEW / etf_30min / 2016-03-24

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-24.parquet
  size:    387 KB
  rows:    13,110

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
2016-03-24 04:00:00	SPY	ETF	202.88	202.93	202.53	202.8	15825.0
2016-03-24 04:30:00	SPY	ETF	202.77	202.77	202.53	202.66	5661.0
2016-03-24 05:00:00	SPY	ETF	202.68	202.68	202.39	202.56	8810.0
2016-03-24 05:30:00	SPY	ETF	202.48	202.6	202.47	202.6	3700.0
2016-03-24 06:00:00	SPY	ETF	202.45	202.51	202.3	202.43	16164.0
2016-03-24 06:30:00	SPY	ETF	202.33	202.53	202.23	202.23	26038.0
2016-03-24 07:00:00	SPY	ETF	202.24	202.29	202.18	202.25	130076.0
2016-03-24 07:30:00	SPY	ETF	202.29	202.32	202.14	202.22	117772.0
2016-03-24 08:00:00	SPY	ETF	202.22	203.255	202.19	202.3	462196.0
2016-03-24 08:30:00	SPY	ETF	202.25	202.35	201.82	202.06	1437357.0
2016-03-24 09:00:00	SPY	ETF	202.05	202.08	201.87	202.0	800263.0
2016-03-24 09:30:00	SPY	ETF	202.0	202.3	201.74	202.25	10426879.0
2016-03-24 10:00:00	SPY	ETF	202.25	202.325	201.92	202.0	5059893.0
2016-03-24 10:30:00	SPY	ETF	202.0	202.52	201.96	202.47	6000911.0
2016-03-24 11:00:00	SPY	ETF	202.47	202.65	202.2	202.2	4114172.0
2016-03-24 11:30:00	SPY	ETF	202.2001	202.37	202.09	202.3	2997814.0
2016-03-24 12:00:00	SPY	ETF	202.3	202.66	202.07	202.25	6171356.0
2016-03-24 12:30:00	SPY	ETF	202.25	202.28	201.99	202.2	3328934.0
2016-03-24 13:00:00	SPY	ETF	202.2	202.54	202.18	202.49	3153037.0
2016-03-24 13:30:00	SPY	ETF	202.49	202.63	202.36	202.531	1992289.0
2016-03-24 14:00:00	SPY	ETF	202.54	202.66	202.33	202.6	3232585.0
2016-03-24 14:30:00	SPY	ETF	202.6	202.93	202.53	202.8	3898465.0
2016-03-24 15:00:00	SPY	ETF	202.8	203.1	202.66	203.03	6788446.0
2016-03-24 15:30:00	SPY	ETF	203.025	203.16	202.92	203.14	13177003.0
2016-03-24 16:00:00	SPY	ETF	203.15	203.39	203.1	203.33	7872534.0
2016-03-24 16:30:00	SPY	ETF	203.32	203.48	203.25	203.48	353597.0
2016-03-24 17:00:00	SPY	ETF	203.43	203.48	203.38	203.43	64864.0
2016-03-24 17:30:00	SPY	ETF	203.42	203.43	203.42	203.43	39123.0
2016-03-24 18:00:00	SPY	ETF	203.43	203.46	203.37	203.46	110061.0
2016-03-24 18:30:00	SPY	ETF	203.46	203.61	203.46	203.52	105194.0
2016-03-24 19:00:00	SPY	ETF	203.54	203.56	203.52	203.52	33523.0
2016-03-24 19:30:00	SPY	ETF	203.52	203.52	203.46	203.52	46757.0
2016-03-24 04:00:00	QQQ	ETF	107.0	107.0	106.86	106.86	1078.0
2016-03-24 04:30:00	QQQ	ETF	106.9	106.9	106.85	106.85	1100.0
2016-03-24 05:00:00	QQQ	ETF	106.74	106.74	106.74	106.74	2000.0
2016-03-24 05:30:00	QQQ	ETF	106.74	106.74	106.74	106.74	1000.0
2016-03-24 06:00:00	QQQ	ETF	106.74	106.75	106.72	106.72	5300.0
2016-03-24 06:30:00	QQQ	ETF	106.75	106.75	106.69	106.69	3664.0
2016-03-24 07:00:00	QQQ	ETF	106.66	106.7	106.66	106.7	11549.0
2016-03-24 07:30:00	QQQ	ETF	106.71	106.71	106.61	106.67	15550.0
2016-03-24 08:00:00	QQQ	ETF	106.67	106.77	106.67	106.75	19524.0
2016-03-24 08:30:00	QQQ	ETF	106.74	106.78	106.55	106.68	94236.0
2016-03-24 09:00:00	QQQ	ETF	106.64	106.73	106.6	106.68	42342.0
2016-03-24 09:30:00	QQQ	ETF	106.67	106.97	106.53	106.95	2996929.0
2016-03-24 10:00:00	QQQ	ETF	106.94	107.02	106.75	106.7999	1407951.0
2016-03-24 10:30:00	QQQ	ETF	106.79	107.185	106.775	107.14	1026092.0
2016-03-24 11:00:00	QQQ	ETF	107.14	107.26	106.96	106.96	1174306.0
2016-03-24 11:30:00	QQQ	ETF	106.955	107.09	106.892	107.0	647217.0
2016-03-24 12:00:00	QQQ	ETF	106.99	107.13	106.78	106.87	847136.0
2016-03-24 12:30:00	QQQ	ETF	106.87	106.89	106.7	106.82	517945.0

> showing 50 of 13,110 rows — these rows as CSV

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