PREVIEW / stock_30min / 2018-02-06

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-06.parquet
  size:    1.8 MB
  rows:    89,632
  symbols: 2,917

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-02-06 04:00:00	AAPL	Stock	38.9025	39.225	38.875	39.19	68172.0
2018-02-06 04:30:00	AAPL	Stock	39.22	39.22	38.905	39.0075	77756.0
2018-02-06 05:00:00	AAPL	Stock	38.93	38.9525	38.7875	38.815	96004.0
2018-02-06 05:30:00	AAPL	Stock	38.8	39.1725	38.79	39.17	38548.0
2018-02-06 06:00:00	AAPL	Stock	39.13	39.17	38.925	39.0075	99316.0
2018-02-06 06:30:00	AAPL	Stock	39.0075	39.0625	38.775	38.8	106756.0
2018-02-06 07:00:00	AAPL	Stock	38.815	39.1325	38.6225	38.925	384172.0
2018-02-06 07:30:00	AAPL	Stock	38.925	39.03	38.775	38.9475	241144.0
2018-02-06 08:00:00	AAPL	Stock	39.0	39.125	38.625	38.65	581660.0
2018-02-06 08:30:00	AAPL	Stock	38.6275	39.0075	38.5675	39.0	476500.0
2018-02-06 09:00:00	AAPL	Stock	39.0	39.1225	38.7175	38.7275	950052.0
2018-02-06 09:30:00	AAPL	Stock	38.7275	40.25	38.5	39.7145	49810272.0
2018-02-06 10:00:00	AAPL	Stock	39.7138	40.1	39.2	39.365	23364844.0
2018-02-06 10:30:00	AAPL	Stock	39.3715	39.685	39.0525	39.4675	15938788.0
2018-02-06 11:00:00	AAPL	Stock	39.47	39.58	39.125	39.423	11855120.0
2018-02-06 11:30:00	AAPL	Stock	39.42	39.85	39.1875	39.635	9673728.0
2018-02-06 12:00:00	AAPL	Stock	39.64	40.1425	39.625	40.105	12043024.0
2018-02-06 12:30:00	AAPL	Stock	40.11	40.223	39.8325	40.1332	11382252.0
2018-02-06 13:00:00	AAPL	Stock	40.1275	40.18	39.8075	40.125	8624664.0
2018-02-06 13:30:00	AAPL	Stock	40.1175	40.135	39.745	39.8225	9149456.0
2018-02-06 14:00:00	AAPL	Stock	39.8162	40.0325	39.6525	39.7225	9021276.0
2018-02-06 14:30:00	AAPL	Stock	39.725	40.49	39.655	40.445	16354092.0
2018-02-06 15:00:00	AAPL	Stock	40.4575	40.725	40.3825	40.7125	18221052.0
2018-02-06 15:30:00	AAPL	Stock	40.7125	40.93	40.5075	40.765	23536180.0
2018-02-06 16:00:00	AAPL	Stock	40.7575	40.87	40.675	40.675	16107356.0
2018-02-06 16:30:00	AAPL	Stock	40.675	40.7575	40.6675	40.7125	201408.0
2018-02-06 17:00:00	AAPL	Stock	40.7	40.7425	40.6775	40.73	145248.0
2018-02-06 17:30:00	AAPL	Stock	40.715	40.7925	40.7125	40.7375	69012.0
2018-02-06 18:00:00	AAPL	Stock	40.75	40.79	40.73	40.7375	36984.0
2018-02-06 18:30:00	AAPL	Stock	40.725	40.7475	40.6125	40.675	62148.0
2018-02-06 19:00:00	AAPL	Stock	40.725	40.75	40.635	40.6375	31584.0
2018-02-06 19:30:00	AAPL	Stock	40.6975	40.7475	40.6875	40.715	31696.0
2018-02-06 04:00:00	MSFT	Stock	87.0	88.29	87.0	88.0	14500.0
2018-02-06 04:30:00	MSFT	Stock	87.9	88.2	87.5	87.68	14374.0
2018-02-06 05:00:00	MSFT	Stock	87.51	87.51	87.0	87.09	9646.0
2018-02-06 05:30:00	MSFT	Stock	87.09	87.59	87.09	87.59	12168.0
2018-02-06 06:00:00	MSFT	Stock	87.52	87.52	87.21	87.22	6124.0
2018-02-06 06:30:00	MSFT	Stock	87.13	87.13	86.82	86.82	6471.0
2018-02-06 07:00:00	MSFT	Stock	87.0	87.15	86.0	86.5	25783.0
2018-02-06 07:30:00	MSFT	Stock	86.79	86.9	86.42	86.9	14646.0
2018-02-06 08:00:00	MSFT	Stock	87.0	87.4	86.35	86.9	148779.0
2018-02-06 08:30:00	MSFT	Stock	86.9	87.75	86.8	87.75	56082.0
2018-02-06 09:00:00	MSFT	Stock	87.61	87.75	86.7	86.92	196169.0
2018-02-06 09:30:00	MSFT	Stock	86.92	89.27	85.25	87.99	11606442.0
2018-02-06 10:00:00	MSFT	Stock	87.99	89.33	86.96	87.412	5567308.0
2018-02-06 10:30:00	MSFT	Stock	87.43	88.64	86.54	87.83	3893232.0
2018-02-06 11:00:00	MSFT	Stock	87.85	87.91	87.1	87.38	3473074.0
2018-02-06 11:30:00	MSFT	Stock	87.37	88.28	86.83	87.965	2958012.0
2018-02-06 12:00:00	MSFT	Stock	87.98	89.24	87.94	89.19	2917048.0
2018-02-06 12:30:00	MSFT	Stock	89.19	89.88	88.96	89.555	3353029.0

> showing 50 of 89,632 rows — these rows as CSV

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