PREVIEW / stock_30min / 2017-01-20

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-20.parquet
  size:    1.6 MB
  rows:    80,966
  symbols: 3,089

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
2017-01-20 04:00:00	AAPL	Stock	29.9475	29.9475	29.945	29.945	1600.0
2017-01-20 05:30:00	AAPL	Stock	29.995	30.0	29.995	30.0	1924.0
2017-01-20 06:00:00	AAPL	Stock	30.035	30.0425	30.0225	30.0425	3804.0
2017-01-20 06:30:00	AAPL	Stock	30.0325	30.0375	30.0325	30.0375	1200.0
2017-01-20 07:00:00	AAPL	Stock	30.0425	30.0425	30.035	30.0375	26800.0
2017-01-20 07:30:00	AAPL	Stock	30.035	30.05	30.02	30.05	51760.0
2017-01-20 08:00:00	AAPL	Stock	30.05	30.0525	29.875	30.0375	87476.0
2017-01-20 08:30:00	AAPL	Stock	30.035	30.06	30.0125	30.0375	86648.0
2017-01-20 09:00:00	AAPL	Stock	30.0375	30.0975	30.005	30.0925	832380.0
2017-01-20 09:30:00	AAPL	Stock	30.05	30.1125	29.985	30.03	21344532.0
2017-01-20 10:00:00	AAPL	Stock	30.032	30.0375	29.9575	29.99	7276244.0
2017-01-20 10:30:00	AAPL	Stock	29.9888	30.03	29.98	30.0225	4660660.0
2017-01-20 11:00:00	AAPL	Stock	30.0235	30.0375	29.995	29.995	4215172.0
2017-01-20 11:30:00	AAPL	Stock	29.9975	30.04	29.9975	30.025	3302960.0
2017-01-20 12:00:00	AAPL	Stock	30.025	30.0425	29.96	29.98	7799124.0
2017-01-20 12:30:00	AAPL	Stock	29.9812	29.9912	29.941	29.953	5911468.0
2017-01-20 13:00:00	AAPL	Stock	29.955	30.0025	29.9475	29.99	4151880.0
2017-01-20 13:30:00	AAPL	Stock	29.99	29.9975	29.9525	29.9538	3077528.0
2017-01-20 14:00:00	AAPL	Stock	29.954	29.9788	29.9338	29.9612	3524648.0
2017-01-20 14:30:00	AAPL	Stock	29.96	29.985	29.935	29.975	4845684.0
2017-01-20 15:00:00	AAPL	Stock	29.975	29.995	29.96	29.9735	5153124.0
2017-01-20 15:30:00	AAPL	Stock	29.9738	30.005	29.9625	29.9975	13690416.0
2017-01-20 16:00:00	AAPL	Stock	30.0025	30.015	29.995	30.005	12761524.0
2017-01-20 16:30:00	AAPL	Stock	30.0	30.005	30.0	30.0025	221036.0
2017-01-20 17:00:00	AAPL	Stock	30.0025	30.005	30.0	30.0	46872.0
2017-01-20 17:30:00	AAPL	Stock	30.0075	30.0075	30.0075	30.0075	2000.0
2017-01-20 18:00:00	AAPL	Stock	30.0075	30.0075	30.0025	30.0025	4300.0
2017-01-20 18:30:00	AAPL	Stock	30.0075	30.01	30.005	30.005	13600.0
2017-01-20 19:00:00	AAPL	Stock	30.005	30.0075	30.005	30.0075	4400.0
2017-01-20 19:30:00	AAPL	Stock	30.01	30.01	30.0	30.01	8386032.0
2017-01-20 06:30:00	MSFT	Stock	62.57	62.57	62.57	62.57	850.0
2017-01-20 07:00:00	MSFT	Stock	62.66	62.66	62.66	62.66	189.0
2017-01-20 08:00:00	MSFT	Stock	62.5	62.69	62.5	62.66	3755.0
2017-01-20 08:30:00	MSFT	Stock	62.69	62.69	62.69	62.69	400.0
2017-01-20 09:00:00	MSFT	Stock	62.62	62.71	62.55	62.7	203828.0
2017-01-20 09:30:00	MSFT	Stock	62.66	62.8	62.37	62.739	5714481.0
2017-01-20 10:00:00	MSFT	Stock	62.735	62.82	62.6	62.6	1453454.0
2017-01-20 10:30:00	MSFT	Stock	62.6	62.7	62.5	62.506	1009314.0
2017-01-20 11:00:00	MSFT	Stock	62.51	62.54	62.44	62.49	866170.0
2017-01-20 11:30:00	MSFT	Stock	62.49	62.59	62.485	62.58	943629.0
2017-01-20 12:00:00	MSFT	Stock	62.58	62.625	62.37	62.545	2314949.0
2017-01-20 12:30:00	MSFT	Stock	62.54	62.58	62.403	62.54	1140145.0
2017-01-20 13:00:00	MSFT	Stock	62.54	62.625	62.53	62.59	749780.0
2017-01-20 13:30:00	MSFT	Stock	62.58	62.62	62.47	62.485	765846.0
2017-01-20 14:00:00	MSFT	Stock	62.488	62.58	62.48	62.545	793443.0
2017-01-20 14:30:00	MSFT	Stock	62.545	62.61	62.51	62.585	873579.0
2017-01-20 15:00:00	MSFT	Stock	62.585	62.7	62.555	62.555	1465636.0
2017-01-20 15:30:00	MSFT	Stock	62.56	62.75	62.535	62.73	4809601.0
2017-01-20 16:00:00	MSFT	Stock	62.74	62.76	62.6	62.74	3814919.0
2017-01-20 16:30:00	MSFT	Stock	62.77	62.99	62.74	62.93	51524.0

> showing 50 of 80,966 rows — these rows as CSV

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