PREVIEW / stock_30min / 2017-05-03

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-03.parquet
  size:    1.6 MB
  rows:    81,624
  symbols: 3,037

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-05-03 04:00:00	AAPL	Stock	36.2475	36.325	36.2475	36.25	4296.0
2017-05-03 04:30:00	AAPL	Stock	36.225	36.3375	36.225	36.31	9280.0
2017-05-03 05:00:00	AAPL	Stock	36.3175	36.4	36.3075	36.4	15300.0
2017-05-03 05:30:00	AAPL	Stock	36.3875	36.3875	36.2925	36.2925	13032.0
2017-05-03 06:00:00	AAPL	Stock	36.3	36.3225	36.0875	36.25	28356.0
2017-05-03 06:30:00	AAPL	Stock	36.2375	36.2375	36.2125	36.2225	3656.0
2017-05-03 07:00:00	AAPL	Stock	36.225	36.47	36.225	36.4625	414592.0
2017-05-03 07:30:00	AAPL	Stock	36.46	36.6675	36.45	36.575	892272.0
2017-05-03 08:00:00	AAPL	Stock	36.565	36.65	36.155	36.4475	1312860.0
2017-05-03 08:30:00	AAPL	Stock	36.455	36.57	36.4125	36.525	726972.0
2017-05-03 09:00:00	AAPL	Stock	36.525	36.5725	36.38	36.3975	722364.0
2017-05-03 09:30:00	AAPL	Stock	36.3975	36.4675	36.0675	36.29	35512012.0
2017-05-03 10:00:00	AAPL	Stock	36.2875	36.545	36.19	36.54	20109788.0
2017-05-03 10:30:00	AAPL	Stock	36.54	36.625	36.445	36.4875	12356932.0
2017-05-03 11:00:00	AAPL	Stock	36.4865	36.5725	36.44	36.5612	6716700.0
2017-05-03 11:30:00	AAPL	Stock	36.56	36.585	36.5	36.5288	5270028.0
2017-05-03 12:00:00	AAPL	Stock	36.5275	36.745	36.525	36.745	10470768.0
2017-05-03 12:30:00	AAPL	Stock	36.745	36.8725	36.7075	36.76	11086356.0
2017-05-03 13:00:00	AAPL	Stock	36.7625	36.7975	36.7025	36.72	6160272.0
2017-05-03 13:30:00	AAPL	Stock	36.715	36.7675	36.6875	36.7475	4489816.0
2017-05-03 14:00:00	AAPL	Stock	36.75	36.83	36.705	36.775	7319968.0
2017-05-03 14:30:00	AAPL	Stock	36.775	36.865	36.75	36.84	6965848.0
2017-05-03 15:00:00	AAPL	Stock	36.839	36.855	36.76	36.8125	6727780.0
2017-05-03 15:30:00	AAPL	Stock	36.8125	36.84	36.625	36.765	22276660.0
2017-05-03 16:00:00	AAPL	Stock	36.76	36.765	36.555	36.575	7121500.0
2017-05-03 16:30:00	AAPL	Stock	36.575	36.765	36.4575	36.6125	417312.0
2017-05-03 17:00:00	AAPL	Stock	36.6125	36.6425	36.57	36.6125	134616.0
2017-05-03 17:30:00	AAPL	Stock	36.6225	36.6625	36.5775	36.5875	149156.0
2017-05-03 18:00:00	AAPL	Stock	36.6	36.66	36.6	36.655	107220.0
2017-05-03 18:30:00	AAPL	Stock	36.645	36.6575	36.625	36.64	36200.0
2017-05-03 19:00:00	AAPL	Stock	36.64	36.66	36.64	36.6575	25792.0
2017-05-03 19:30:00	AAPL	Stock	36.66	36.6875	36.6325	36.6875	56648.0
2017-05-03 04:30:00	MSFT	Stock	69.1	69.2	69.1	69.2	600.0
2017-05-03 06:00:00	MSFT	Stock	69.19	69.19	69.19	69.19	148.0
2017-05-03 06:30:00	MSFT	Stock	69.09	69.09	69.03	69.03	352.0
2017-05-03 07:30:00	MSFT	Stock	69.15	69.18	69.15	69.18	3371.0
2017-05-03 08:00:00	MSFT	Stock	69.18	69.2	69.1	69.17	7194.0
2017-05-03 08:30:00	MSFT	Stock	69.1	69.1	69.1	69.1	300.0
2017-05-03 09:00:00	MSFT	Stock	69.11	69.26	69.1	69.17	40224.0
2017-05-03 09:30:00	MSFT	Stock	69.38	69.38	69.05	69.13	2094430.0
2017-05-03 10:00:00	MSFT	Stock	69.125	69.18	68.92	68.99	2209911.0
2017-05-03 10:30:00	MSFT	Stock	68.98	69.01	68.8	68.903	1718839.0
2017-05-03 11:00:00	MSFT	Stock	68.905	68.99	68.885	68.945	1541290.0
2017-05-03 11:30:00	MSFT	Stock	68.94	68.95	68.88	68.885	1269031.0
2017-05-03 12:00:00	MSFT	Stock	68.885	68.95	68.86	68.945	1031320.0
2017-05-03 12:30:00	MSFT	Stock	68.94	68.956	68.87	68.895	769886.0
2017-05-03 13:00:00	MSFT	Stock	68.9	68.91	68.76	68.795	953818.0
2017-05-03 13:30:00	MSFT	Stock	68.79	68.83	68.75	68.77	999022.0
2017-05-03 14:00:00	MSFT	Stock	68.78	68.83	68.71	68.74	1509928.0
2017-05-03 14:30:00	MSFT	Stock	68.73	68.9	68.72	68.885	1281562.0

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

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