PREVIEW / stock_30min / 2017-12-07

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-07.parquet
  size:    1.6 MB
  rows:    83,060
  symbols: 2,935

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-12-07 04:30:00	AAPL	Stock	42.4125	42.4125	42.4125	42.4125	1000.0
2017-12-07 05:00:00	AAPL	Stock	42.4125	42.4125	42.4125	42.4125	5996.0
2017-12-07 05:30:00	AAPL	Stock	42.4175	42.4175	42.4175	42.4175	5600.0
2017-12-07 06:00:00	AAPL	Stock	42.4175	42.4175	42.375	42.4	33436.0
2017-12-07 06:30:00	AAPL	Stock	42.36	42.375	42.325	42.325	8932.0
2017-12-07 07:00:00	AAPL	Stock	42.3725	42.4225	42.3375	42.375	42236.0
2017-12-07 07:30:00	AAPL	Stock	42.355	42.42	42.35	42.35	44576.0
2017-12-07 08:00:00	AAPL	Stock	42.395	42.44	42.34	42.44	155112.0
2017-12-07 08:30:00	AAPL	Stock	42.4275	42.4275	42.34	42.3725	73752.0
2017-12-07 09:00:00	AAPL	Stock	42.355	42.375	42.245	42.26	130752.0
2017-12-07 09:30:00	AAPL	Stock	42.2575	42.595	42.2275	42.4975	13706964.0
2017-12-07 10:00:00	AAPL	Stock	42.4925	42.5	42.2425	42.4025	8495460.0
2017-12-07 10:30:00	AAPL	Stock	42.4075	42.5275	42.37	42.4325	5483268.0
2017-12-07 11:00:00	AAPL	Stock	42.435	42.445	42.285	42.34	5217204.0
2017-12-07 11:30:00	AAPL	Stock	42.34	42.465	42.3175	42.44	4879772.0
2017-12-07 12:00:00	AAPL	Stock	42.4375	42.495	42.385	42.435	3775652.0
2017-12-07 12:30:00	AAPL	Stock	42.435	42.49	42.42	42.485	2480100.0
2017-12-07 13:00:00	AAPL	Stock	42.485	42.55	42.4275	42.5425	3391472.0
2017-12-07 13:30:00	AAPL	Stock	42.545	42.61	42.325	42.4425	7128984.0
2017-12-07 14:00:00	AAPL	Stock	42.4475	42.5012	42.35	42.365	4015416.0
2017-12-07 14:30:00	AAPL	Stock	42.3662	42.3962	42.24	42.3675	5554228.0
2017-12-07 15:00:00	AAPL	Stock	42.37	42.425	42.34	42.4075	4443560.0
2017-12-07 15:30:00	AAPL	Stock	42.4062	42.4475	42.33	42.3325	9257316.0
2017-12-07 16:00:00	AAPL	Stock	42.33	42.39	42.33	42.355	11523772.0
2017-12-07 16:30:00	AAPL	Stock	42.355	42.375	42.3125	42.3525	74344.0
2017-12-07 17:00:00	AAPL	Stock	42.3525	42.3675	42.3375	42.345	35412.0
2017-12-07 17:30:00	AAPL	Stock	42.36	42.36	42.3475	42.3475	1476.0
2017-12-07 18:00:00	AAPL	Stock	42.3625	42.38	42.3625	42.38	11252.0
2017-12-07 18:30:00	AAPL	Stock	42.38	42.405	42.38	42.3925	8060.0
2017-12-07 19:00:00	AAPL	Stock	42.3925	42.4075	42.3875	42.3975	26684.0
2017-12-07 19:30:00	AAPL	Stock	42.4025	42.4125	42.375	42.375	9544.0
2017-12-07 05:00:00	MSFT	Stock	83.26	83.26	83.26	83.26	332.0
2017-12-07 06:30:00	MSFT	Stock	83.0	83.0	83.0	83.0	120.0
2017-12-07 07:00:00	MSFT	Stock	83.0	83.0	82.8	83.0	1602.0
2017-12-07 08:00:00	MSFT	Stock	82.8	83.05	82.8	82.99	7724.0
2017-12-07 08:30:00	MSFT	Stock	82.87	83.0	82.8	82.95	4045.0
2017-12-07 09:00:00	MSFT	Stock	82.98	83.0	82.54	82.62	20056.0
2017-12-07 09:30:00	MSFT	Stock	82.62	82.8	82.1	82.2	2719115.0
2017-12-07 10:00:00	MSFT	Stock	82.2	82.3	82.0	82.21	1948522.0
2017-12-07 10:30:00	MSFT	Stock	82.215	82.555	82.21	82.325	1612651.0
2017-12-07 11:00:00	MSFT	Stock	82.325	82.38	82.16	82.33	1284665.0
2017-12-07 11:30:00	MSFT	Stock	82.33	82.77	82.32	82.77	945603.0
2017-12-07 12:00:00	MSFT	Stock	82.78	82.78	82.48	82.558	728956.0
2017-12-07 12:30:00	MSFT	Stock	82.55	82.7	82.52	82.63	548322.0
2017-12-07 13:00:00	MSFT	Stock	82.64	82.72	82.446	82.496	831807.0
2017-12-07 13:30:00	MSFT	Stock	82.49	82.56	82.31	82.47	1046874.0
2017-12-07 14:00:00	MSFT	Stock	82.475	82.52	82.35	82.36	614232.0
2017-12-07 14:30:00	MSFT	Stock	82.37	82.47	82.17	82.47	871046.0
2017-12-07 15:00:00	MSFT	Stock	82.475	82.53	82.33	82.47	905159.0
2017-12-07 15:30:00	MSFT	Stock	82.48	82.52	82.38	82.49	1906674.0

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

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