PREVIEW / stock_30min / 2016-12-01

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-01.parquet
  size:    1.6 MB
  rows:    83,322
  symbols: 3,167

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-12-01 04:00:00	AAPL	Stock	27.56	27.56	27.56	27.56	880.0
2016-12-01 06:00:00	AAPL	Stock	27.5575	27.5575	27.5	27.5125	6260.0
2016-12-01 06:30:00	AAPL	Stock	27.5125	27.515	27.5	27.5	16076.0
2016-12-01 07:00:00	AAPL	Stock	27.495	27.555	27.475	27.4875	42816.0
2016-12-01 07:30:00	AAPL	Stock	27.4775	27.55	27.4775	27.525	62920.0
2016-12-01 08:00:00	AAPL	Stock	27.525	27.5625	27.4875	27.5475	72064.0
2016-12-01 08:30:00	AAPL	Stock	27.55	27.5875	27.55	27.5775	158108.0
2016-12-01 09:00:00	AAPL	Stock	27.57	27.5825	27.545	27.5825	476972.0
2016-12-01 09:30:00	AAPL	Stock	27.5975	27.695	27.475	27.555	20768644.0
2016-12-01 10:00:00	AAPL	Stock	27.5625	27.735	27.505	27.505	12090720.0
2016-12-01 10:30:00	AAPL	Stock	27.5085	27.5085	27.3125	27.4425	16154300.0
2016-12-01 11:00:00	AAPL	Stock	27.4425	27.51	27.39	27.465	8924804.0
2016-12-01 11:30:00	AAPL	Stock	27.465	27.5638	27.46	27.5375	5110176.0
2016-12-01 12:00:00	AAPL	Stock	27.5358	27.5675	27.4725	27.4875	4448504.0
2016-12-01 12:30:00	AAPL	Stock	27.4875	27.5425	27.4275	27.44	3838008.0
2016-12-01 13:00:00	AAPL	Stock	27.44	27.44	27.3525	27.395	5862084.0
2016-12-01 13:30:00	AAPL	Stock	27.3925	27.4425	27.3675	27.3725	4564192.0
2016-12-01 14:00:00	AAPL	Stock	27.3725	27.4775	27.36	27.4325	5096908.0
2016-12-01 14:30:00	AAPL	Stock	27.4325	27.4862	27.4275	27.44	5250484.0
2016-12-01 15:00:00	AAPL	Stock	27.44	27.46	27.3175	27.36	6625616.0
2016-12-01 15:30:00	AAPL	Stock	27.36	27.39	27.2575	27.3675	20075968.0
2016-12-01 16:00:00	AAPL	Stock	27.3725	27.4225	27.3355	27.39	14466520.0
2016-12-01 16:30:00	AAPL	Stock	27.39	27.405	27.3725	27.4	147056.0
2016-12-01 17:00:00	AAPL	Stock	27.3975	27.4125	27.39	27.39	8628.0
2016-12-01 17:30:00	AAPL	Stock	27.39	27.39	27.3875	27.3875	31020.0
2016-12-01 18:00:00	AAPL	Stock	27.3925	27.3925	27.37	27.37	88356.0
2016-12-01 18:30:00	AAPL	Stock	27.375	27.375	27.3725	27.3725	5848.0
2016-12-01 19:00:00	AAPL	Stock	27.3875	27.3975	27.3875	27.3975	8800.0
2016-12-01 19:30:00	AAPL	Stock	27.4	27.425	27.3925	27.425	36876.0
2016-12-01 05:00:00	MSFT	Stock	60.31	60.31	60.31	60.31	256.0
2016-12-01 05:30:00	MSFT	Stock	60.3	60.3	60.3	60.3	400.0
2016-12-01 06:30:00	MSFT	Stock	60.29	60.29	60.29	60.29	145.0
2016-12-01 07:30:00	MSFT	Stock	60.2	60.2	60.2	60.2	300.0
2016-12-01 08:00:00	MSFT	Stock	60.21	60.21	60.19	60.19	3100.0
2016-12-01 08:30:00	MSFT	Stock	60.21	60.3	60.21	60.3	4000.0
2016-12-01 09:00:00	MSFT	Stock	60.33	60.37	60.07	60.09	17839.0
2016-12-01 09:30:00	MSFT	Stock	60.07	60.15	59.82	59.95	3694375.0
2016-12-01 10:00:00	MSFT	Stock	59.95	60.07	59.62	59.629	2336571.0
2016-12-01 10:30:00	MSFT	Stock	59.62	59.713	59.21	59.426	3461693.0
2016-12-01 11:00:00	MSFT	Stock	59.42	59.566	59.28	59.506	2645170.0
2016-12-01 11:30:00	MSFT	Stock	59.505	59.52	59.295	59.36	1556228.0
2016-12-01 12:00:00	MSFT	Stock	59.36	59.36	59.03	59.065	2093132.0
2016-12-01 12:30:00	MSFT	Stock	59.066	59.17	58.95	59.006	2155452.0
2016-12-01 13:00:00	MSFT	Stock	59.0	59.09	58.935	59.03	1229960.0
2016-12-01 13:30:00	MSFT	Stock	59.03	59.205	59.02	59.11	1236333.0
2016-12-01 14:00:00	MSFT	Stock	59.11	59.36	59.105	59.25	1316954.0
2016-12-01 14:30:00	MSFT	Stock	59.25	59.36	59.23	59.255	1096552.0
2016-12-01 15:00:00	MSFT	Stock	59.25	59.28	59.01	59.036	1366476.0
2016-12-01 15:30:00	MSFT	Stock	59.035	59.23	58.99	59.18	3381509.0
2016-12-01 16:00:00	MSFT	Stock	59.19	59.298	59.01	59.02	3796108.0

> showing 50 of 83,322 rows — these rows as CSV

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