PREVIEW / stock_30min / 2018-06-15

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-15.parquet
  size:    1.7 MB
  rows:    84,333
  symbols: 2,815

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
2018-06-15 04:00:00	AAPL	Stock	47.545	47.545	47.545	47.545	744.0
2018-06-15 04:30:00	AAPL	Stock	47.6225	47.6825	47.6225	47.6825	1708.0
2018-06-15 05:00:00	AAPL	Stock	47.625	47.625	47.625	47.625	828.0
2018-06-15 05:30:00	AAPL	Stock	47.585	47.585	47.5725	47.5725	7336.0
2018-06-15 06:00:00	AAPL	Stock	47.5725	47.575	47.5	47.5075	22328.0
2018-06-15 06:30:00	AAPL	Stock	47.4525	47.505	47.4525	47.505	13820.0
2018-06-15 07:00:00	AAPL	Stock	47.5475	47.57	47.5	47.5025	59156.0
2018-06-15 07:30:00	AAPL	Stock	47.545	47.6375	47.5375	47.6025	33436.0
2018-06-15 08:00:00	AAPL	Stock	47.575	47.8	47.5	47.5625	120668.0
2018-06-15 08:30:00	AAPL	Stock	47.545	47.5625	47.45	47.4725	268884.0
2018-06-15 09:00:00	AAPL	Stock	47.4625	47.68	47.375	47.5075	917116.0
2018-06-15 09:30:00	AAPL	Stock	47.51	47.54	47.2178	47.315	39676040.0
2018-06-15 10:00:00	AAPL	Stock	47.3175	47.3725	47.2125	47.2175	6645324.0
2018-06-15 10:30:00	AAPL	Stock	47.2125	47.2675	47.065	47.183	9334432.0
2018-06-15 11:00:00	AAPL	Stock	47.1825	47.2375	47.075	47.1975	7092840.0
2018-06-15 11:30:00	AAPL	Stock	47.1975	47.3175	47.1325	47.2775	4586332.0
2018-06-15 12:00:00	AAPL	Stock	47.275	47.28	47.205	47.2242	3463396.0
2018-06-15 12:30:00	AAPL	Stock	47.225	47.2525	47.175	47.21	2998300.0
2018-06-15 13:00:00	AAPL	Stock	47.21	47.305	47.1825	47.21	4959532.0
2018-06-15 13:30:00	AAPL	Stock	47.2088	47.2225	47.1575	47.1675	3400596.0
2018-06-15 14:00:00	AAPL	Stock	47.1675	47.3725	47.1375	47.3425	5390680.0
2018-06-15 14:30:00	AAPL	Stock	47.3425	47.37	47.2725	47.3075	4808604.0
2018-06-15 15:00:00	AAPL	Stock	47.3065	47.3125	47.175	47.24	5476820.0
2018-06-15 15:30:00	AAPL	Stock	47.24	47.3175	47.1375	47.23	16077576.0
2018-06-15 16:00:00	AAPL	Stock	47.21	47.23	47.15	47.2175	90522468.0
2018-06-15 16:30:00	AAPL	Stock	47.2125	47.2475	47.2	47.2	109128.0
2018-06-15 17:00:00	AAPL	Stock	47.185	47.21	46.922	47.1875	330696.0
2018-06-15 17:30:00	AAPL	Stock	47.18	47.2	47.17	47.17	15836.0
2018-06-15 18:00:00	AAPL	Stock	47.1925	47.1925	47.17	47.175	10696.0
2018-06-15 18:30:00	AAPL	Stock	47.1825	47.2225	47.175	47.2225	10944.0
2018-06-15 19:00:00	AAPL	Stock	47.2	47.2	47.1875	47.2	7340.0
2018-06-15 19:30:00	AAPL	Stock	47.2	47.205	47.2	47.2	4520.0
2018-06-15 07:00:00	MSFT	Stock	101.3	101.3	101.04	101.04	649.0
2018-06-15 07:30:00	MSFT	Stock	101.15	101.39	101.15	101.34	1383.0
2018-06-15 08:00:00	MSFT	Stock	101.047	101.38	101.04	101.15	4550.0
2018-06-15 08:30:00	MSFT	Stock	101.08	101.3	100.9	101.02	27482.0
2018-06-15 09:00:00	MSFT	Stock	101.05	102.0	100.82	101.49	514098.0
2018-06-15 09:30:00	MSFT	Stock	101.49	101.53	100.26	100.84	13457715.0
2018-06-15 10:00:00	MSFT	Stock	100.85	101.22	100.64	101.08	1851301.0
2018-06-15 10:30:00	MSFT	Stock	101.09	101.24	100.77	101.11	1703427.0
2018-06-15 11:00:00	MSFT	Stock	101.105	101.18	100.8	100.8	1081936.0
2018-06-15 11:30:00	MSFT	Stock	100.8	100.91	100.62	100.758	1198085.0
2018-06-15 12:00:00	MSFT	Stock	100.75	100.855	100.62	100.83	853929.0
2018-06-15 12:30:00	MSFT	Stock	100.83	100.99	100.825	100.96	631666.0
2018-06-15 13:00:00	MSFT	Stock	100.96	100.99	100.78	100.82	650199.0
2018-06-15 13:30:00	MSFT	Stock	100.81	100.82	100.62	100.67	751980.0
2018-06-15 14:00:00	MSFT	Stock	100.68	101.11	100.64	101.06	1010825.0
2018-06-15 14:30:00	MSFT	Stock	101.06	101.15	101.02	101.09	879145.0
2018-06-15 15:00:00	MSFT	Stock	101.085	101.15	101.01	101.14	1042012.0
2018-06-15 15:30:00	MSFT	Stock	101.14	101.235	100.07	100.22	7711166.0

> showing 50 of 84,333 rows — these rows as CSV

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