PREVIEW / stock_30min / 2016-02-23

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-23.parquet
  size:    1.5 MB
  rows:    81,708
  symbols: 3,341

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-02-23 04:30:00	AAPL	Stock	24.0625	24.0625	24.0625	24.0625	4000.0
2016-02-23 05:00:00	AAPL	Stock	24.0625	24.0625	24.0625	24.0625	400.0
2016-02-23 06:00:00	AAPL	Stock	24.1125	24.1125	24.1	24.1	4000.0
2016-02-23 06:30:00	AAPL	Stock	24.1	24.1	24.1	24.1	1932.0
2016-02-23 07:00:00	AAPL	Stock	24.1175	24.125	24.115	24.115	52040.0
2016-02-23 07:30:00	AAPL	Stock	24.145	24.15	24.09	24.1	33540.0
2016-02-23 08:00:00	AAPL	Stock	24.115	24.135	24.0625	24.08	283852.0
2016-02-23 08:30:00	AAPL	Stock	24.075	24.1475	24.0675	24.1275	98540.0
2016-02-23 09:00:00	AAPL	Stock	24.12	24.125	24.0725	24.0975	188640.0
2016-02-23 09:30:00	AAPL	Stock	24.1	24.125	24.032	24.045	11601916.0
2016-02-23 10:00:00	AAPL	Stock	24.0425	24.055	23.9288	23.945	12746252.0
2016-02-23 10:30:00	AAPL	Stock	23.9475	23.9575	23.805	23.8162	10133428.0
2016-02-23 11:00:00	AAPL	Stock	23.815	23.8375	23.7725	23.8075	7737056.0
2016-02-23 11:30:00	AAPL	Stock	23.81	23.895	23.7875	23.8325	6413276.0
2016-02-23 12:00:00	AAPL	Stock	23.8325	23.8375	23.7938	23.815	3626488.0
2016-02-23 12:30:00	AAPL	Stock	23.815	23.8525	23.81	23.8245	2904028.0
2016-02-23 13:00:00	AAPL	Stock	23.8225	23.825	23.77	23.775	3839024.0
2016-02-23 13:30:00	AAPL	Stock	23.7775	23.79	23.74	23.7875	5716632.0
2016-02-23 14:00:00	AAPL	Stock	23.7862	23.8075	23.765	23.7762	4773716.0
2016-02-23 14:30:00	AAPL	Stock	23.775	23.795	23.7138	23.7325	5616172.0
2016-02-23 15:00:00	AAPL	Stock	23.7325	23.7475	23.6675	23.685	8624836.0
2016-02-23 15:30:00	AAPL	Stock	23.6875	23.7425	23.6375	23.6725	19941796.0
2016-02-23 16:00:00	AAPL	Stock	23.6725	24.06	23.6225	23.6275	12538820.0
2016-02-23 16:30:00	AAPL	Stock	23.6625	23.6625	23.625	23.65	34908.0
2016-02-23 17:00:00	AAPL	Stock	23.64	23.655	23.6325	23.6325	52064.0
2016-02-23 17:30:00	AAPL	Stock	23.6325	23.6375	23.6	23.6	54144.0
2016-02-23 18:00:00	AAPL	Stock	23.6125	23.6125	23.585	23.585	48804.0
2016-02-23 18:30:00	AAPL	Stock	23.585	23.6	23.5675	23.5875	54916.0
2016-02-23 19:00:00	AAPL	Stock	23.5975	23.6	23.585	23.5875	25644.0
2016-02-23 19:30:00	AAPL	Stock	23.5875	23.5875	23.55	23.575	54244.0
2016-02-23 07:00:00	MSFT	Stock	52.35	52.4	52.35	52.4	1100.0
2016-02-23 07:30:00	MSFT	Stock	52.4	52.4	52.32	52.32	300.0
2016-02-23 08:00:00	MSFT	Stock	52.4	52.4	52.2	52.2	10837.0
2016-02-23 08:30:00	MSFT	Stock	52.2	52.42	52.2	52.41	4035.0
2016-02-23 09:00:00	MSFT	Stock	52.35	52.39	52.29	52.29	14641.0
2016-02-23 09:30:00	MSFT	Stock	52.26	52.37	51.93	52.005	2468022.0
2016-02-23 10:00:00	MSFT	Stock	52.0	52.05	51.71	51.77	2140505.0
2016-02-23 10:30:00	MSFT	Stock	51.78	51.89	51.54	51.605	1679870.0
2016-02-23 11:00:00	MSFT	Stock	51.61	51.67	51.43	51.5	1478813.0
2016-02-23 11:30:00	MSFT	Stock	51.5	51.58	51.32	51.375	1652693.0
2016-02-23 12:00:00	MSFT	Stock	51.37	51.45	51.325	51.375	1173364.0
2016-02-23 12:30:00	MSFT	Stock	51.375	51.52	51.37	51.52	784380.0
2016-02-23 13:00:00	MSFT	Stock	51.52	51.56	51.37	51.395	1103361.0
2016-02-23 13:30:00	MSFT	Stock	51.4	51.41	51.16	51.39	1679628.0
2016-02-23 14:00:00	MSFT	Stock	51.395	51.41	51.25	51.35	1284460.0
2016-02-23 14:30:00	MSFT	Stock	51.35	51.37	51.11	51.12	1313889.0
2016-02-23 15:00:00	MSFT	Stock	51.115	51.17	50.98	51.035	2462139.0
2016-02-23 15:30:00	MSFT	Stock	51.035	51.28	51.03	51.18	4008896.0
2016-02-23 16:00:00	MSFT	Stock	51.18	51.26	51.05	51.05	3441653.0
2016-02-23 16:30:00	MSFT	Stock	51.18	51.18	51.05	51.05	300400.0

> showing 50 of 81,708 rows — these rows as CSV

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