PREVIEW / stock_30min / 2018-07-16

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-07-16.parquet
  size:    1.7 MB
  rows:    82,605
  symbols: 2,801

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-07-16 05:00:00	AAPL	Stock	48.0	48.0	48.0	48.0	2800.0
2018-07-16 07:00:00	AAPL	Stock	47.92	47.9675	47.8875	47.89	70296.0
2018-07-16 07:30:00	AAPL	Stock	47.9	47.9125	47.85	47.91	43076.0
2018-07-16 08:00:00	AAPL	Stock	47.9425	47.9725	47.875	47.905	79696.0
2018-07-16 08:30:00	AAPL	Stock	47.905	47.915	47.8625	47.8625	48780.0
2018-07-16 09:00:00	AAPL	Stock	47.875	47.9075	47.8325	47.9075	43832.0
2018-07-16 09:30:00	AAPL	Stock	47.88	48.1625	47.88	48.0925	9303984.0
2018-07-16 10:00:00	AAPL	Stock	48.0925	48.1095	47.905	47.95	4693240.0
2018-07-16 10:30:00	AAPL	Stock	47.9512	47.9875	47.7825	47.7925	3964872.0
2018-07-16 11:00:00	AAPL	Stock	47.7925	47.855	47.7875	47.8025	2602052.0
2018-07-16 11:30:00	AAPL	Stock	47.8038	47.8475	47.743	47.8275	1974896.0
2018-07-16 12:00:00	AAPL	Stock	47.8275	47.84	47.7175	47.84	2770156.0
2018-07-16 12:30:00	AAPL	Stock	47.8388	47.8425	47.7202	47.7202	1882336.0
2018-07-16 13:00:00	AAPL	Stock	47.7225	47.7465	47.6475	47.6838	2606208.0
2018-07-16 13:30:00	AAPL	Stock	47.685	47.7125	47.6638	47.695	1721980.0
2018-07-16 14:00:00	AAPL	Stock	47.695	47.7075	47.655	47.6825	1980280.0
2018-07-16 14:30:00	AAPL	Stock	47.6825	47.6925	47.6038	47.6638	2375500.0
2018-07-16 15:00:00	AAPL	Stock	47.665	47.7075	47.6325	47.695	2098656.0
2018-07-16 15:30:00	AAPL	Stock	47.695	47.745	47.6375	47.73	6409004.0
2018-07-16 16:00:00	AAPL	Stock	47.7275	47.7275	47.4075	47.5175	8404004.0
2018-07-16 16:30:00	AAPL	Stock	47.4825	47.7275	47.4125	47.475	107696.0
2018-07-16 17:00:00	AAPL	Stock	47.4875	47.49	47.415	47.4825	16752.0
2018-07-16 17:30:00	AAPL	Stock	47.495	47.52	47.475	47.5	36628.0
2018-07-16 18:00:00	AAPL	Stock	47.495	47.5	47.4775	47.4775	25572.0
2018-07-16 18:30:00	AAPL	Stock	47.5	47.5175	47.495	47.5175	3800.0
2018-07-16 19:00:00	AAPL	Stock	47.5075	47.525	47.5	47.525	10440.0
2018-07-16 19:30:00	AAPL	Stock	47.51	47.525	47.475	47.4925	28272.0
2018-07-16 04:00:00	MSFT	Stock	105.98	105.98	105.98	105.98	100.0
2018-07-16 04:30:00	MSFT	Stock	105.97	105.97	105.97	105.97	100.0
2018-07-16 05:30:00	MSFT	Stock	105.93	105.96	105.87	105.87	700.0
2018-07-16 06:00:00	MSFT	Stock	105.87	105.87	105.71	105.71	600.0
2018-07-16 06:30:00	MSFT	Stock	105.7	105.79	105.7	105.77	2332.0
2018-07-16 07:00:00	MSFT	Stock	105.69	105.79	105.65	105.65	4997.0
2018-07-16 07:30:00	MSFT	Stock	105.53	105.7	105.53	105.7	3267.0
2018-07-16 08:00:00	MSFT	Stock	105.8	105.93	105.7	105.75	13298.0
2018-07-16 08:30:00	MSFT	Stock	105.75	105.75	105.5	105.64	24106.0
2018-07-16 09:00:00	MSFT	Stock	105.67	105.69	105.38	105.4	39097.0
2018-07-16 09:30:00	MSFT	Stock	105.4	105.82	105.24	105.42	2938797.0
2018-07-16 10:00:00	MSFT	Stock	105.425	105.585	105.26	105.41	1532169.0
2018-07-16 10:30:00	MSFT	Stock	105.41	105.473	105.08	105.09	1395330.0
2018-07-16 11:00:00	MSFT	Stock	105.09	105.295	105.08	105.21	888141.0
2018-07-16 11:30:00	MSFT	Stock	105.21	105.4	105.17	105.245	909133.0
2018-07-16 12:00:00	MSFT	Stock	105.245	105.29	104.96	105.247	1089984.0
2018-07-16 12:30:00	MSFT	Stock	105.25	105.27	105.055	105.11	654906.0
2018-07-16 13:00:00	MSFT	Stock	105.115	105.135	104.93	104.966	651935.0
2018-07-16 13:30:00	MSFT	Stock	104.97	105.08	104.77	104.805	793057.0
2018-07-16 14:00:00	MSFT	Stock	104.8	104.845	104.69	104.695	774993.0
2018-07-16 14:30:00	MSFT	Stock	104.69	104.765	104.515	104.615	905518.0
2018-07-16 15:00:00	MSFT	Stock	104.62	104.79	104.52	104.745	951518.0
2018-07-16 15:30:00	MSFT	Stock	104.75	104.97	104.75	104.92	2402556.0

> showing 50 of 82,605 rows — these rows as CSV

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