PREVIEW / stock_30min / 2017-09-15

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-09-15.parquet
  size:    1.6 MB
  rows:    82,162
  symbols: 2,974

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-09-15 05:30:00	AAPL	Stock	39.55	39.57	39.5375	39.57	5600.0
2017-09-15 06:00:00	AAPL	Stock	39.5375	39.5375	39.5175	39.5175	16932.0
2017-09-15 06:30:00	AAPL	Stock	39.5125	39.5675	39.505	39.5675	8668.0
2017-09-15 07:00:00	AAPL	Stock	39.5275	39.575	39.525	39.57	13512.0
2017-09-15 07:30:00	AAPL	Stock	39.6	39.675	39.6	39.63	133464.0
2017-09-15 08:00:00	AAPL	Stock	39.6425	39.675	39.575	39.6375	148212.0
2017-09-15 08:30:00	AAPL	Stock	39.65	39.655	39.6	39.61	124644.0
2017-09-15 09:00:00	AAPL	Stock	39.6125	39.665	39.545	39.545	519472.0
2017-09-15 09:30:00	AAPL	Stock	39.6175	39.9725	39.5	39.915	47664272.0
2017-09-15 10:00:00	AAPL	Stock	39.915	40.055	39.895	39.995	14230900.0
2017-09-15 10:30:00	AAPL	Stock	39.9938	40.2425	39.98	40.2	12592144.0
2017-09-15 11:00:00	AAPL	Stock	40.1975	40.2125	40.0528	40.1325	6986632.0
2017-09-15 11:30:00	AAPL	Stock	40.1312	40.16	40.075	40.1435	4334788.0
2017-09-15 12:00:00	AAPL	Stock	40.1438	40.1675	40.0625	40.07	3217440.0
2017-09-15 12:30:00	AAPL	Stock	40.0675	40.0775	39.98	40.02	4585920.0
2017-09-15 13:00:00	AAPL	Stock	40.02	40.025	39.9575	39.9875	3734208.0
2017-09-15 13:30:00	AAPL	Stock	39.9875	40.0	39.93	39.98	3658772.0
2017-09-15 14:00:00	AAPL	Stock	39.9825	40.02	39.965	39.9975	4054212.0
2017-09-15 14:30:00	AAPL	Stock	39.995	40.017	39.9675	40.0078	4331972.0
2017-09-15 15:00:00	AAPL	Stock	40.0075	40.055	39.995	40.0035	5478392.0
2017-09-15 15:30:00	AAPL	Stock	40.0037	40.0112	39.955	39.97	16293948.0
2017-09-15 16:00:00	AAPL	Stock	39.97	40.025	39.95	39.9775	46579916.0
2017-09-15 16:30:00	AAPL	Stock	39.9875	40.0125	39.97	39.99	456904.0
2017-09-15 17:00:00	AAPL	Stock	40.0	40.0225	39.99	40.0225	9412.0
2017-09-15 17:30:00	AAPL	Stock	40.0075	40.02	40.0075	40.0075	17288.0
2017-09-15 18:00:00	AAPL	Stock	40.0075	40.0125	39.99	39.99	62372.0
2017-09-15 18:30:00	AAPL	Stock	39.99	40.0	39.99	40.0	5800.0
2017-09-15 19:00:00	AAPL	Stock	39.99	40.005	39.99	40.0	9712.0
2017-09-15 19:30:00	AAPL	Stock	40.0	40.02	40.0	40.02	44584.0
2017-09-15 05:30:00	MSFT	Stock	74.7	74.7	74.7	74.7	100.0
2017-09-15 06:00:00	MSFT	Stock	74.65	74.65	74.65	74.65	761.0
2017-09-15 07:30:00	MSFT	Stock	74.69	74.75	74.69	74.75	500.0
2017-09-15 08:00:00	MSFT	Stock	74.76	74.9	74.76	74.9	2600.0
2017-09-15 08:30:00	MSFT	Stock	74.8	74.8	74.65	74.65	1131.0
2017-09-15 09:00:00	MSFT	Stock	74.87	75.0	74.65	74.78	154300.0
2017-09-15 09:30:00	MSFT	Stock	74.78	75.02	74.16	74.16	11981497.0
2017-09-15 10:00:00	MSFT	Stock	74.16	74.47	74.07	74.395	1809240.0
2017-09-15 10:30:00	MSFT	Stock	74.395	75.335	74.39	75.298	2349098.0
2017-09-15 11:00:00	MSFT	Stock	75.295	75.39	75.235	75.34	1759097.0
2017-09-15 11:30:00	MSFT	Stock	75.348	75.35	75.16	75.26	1040671.0
2017-09-15 12:00:00	MSFT	Stock	75.265	75.34	75.21	75.296	693718.0
2017-09-15 12:30:00	MSFT	Stock	75.295	75.32	75.03	75.06	622496.0
2017-09-15 13:00:00	MSFT	Stock	75.07	75.14	75.05	75.064	419308.0
2017-09-15 13:30:00	MSFT	Stock	75.07	75.076	74.95	75.015	408008.0
2017-09-15 14:00:00	MSFT	Stock	75.02	75.05	74.97	75.005	496503.0
2017-09-15 14:30:00	MSFT	Stock	75.01	75.035	74.97	75.01	772025.0
2017-09-15 15:00:00	MSFT	Stock	75.01	75.15	74.98	75.08	829872.0
2017-09-15 15:30:00	MSFT	Stock	75.07	75.38	74.98	75.29	4902402.0
2017-09-15 16:00:00	MSFT	Stock	75.29	75.36	75.2	75.36	8061843.0
2017-09-15 16:30:00	MSFT	Stock	75.34	75.36	75.26	75.28	19619.0

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

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