PREVIEW / stock_30min / 2017-06-01

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-01.parquet
  size:    1.6 MB
  rows:    82,760
  symbols: 3,042

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-06-01 04:00:00	AAPL	Stock	38.25	38.325	38.25	38.325	9600.0
2017-06-01 04:30:00	AAPL	Stock	38.375	38.425	38.375	38.425	4400.0
2017-06-01 05:30:00	AAPL	Stock	38.35	38.35	38.35	38.35	5380.0
2017-06-01 07:00:00	AAPL	Stock	38.345	38.345	38.3125	38.3125	12468.0
2017-06-01 07:30:00	AAPL	Stock	38.29	38.31	38.2875	38.2875	2520.0
2017-06-01 08:00:00	AAPL	Stock	38.3225	38.3475	38.19	38.3475	213252.0
2017-06-01 08:30:00	AAPL	Stock	38.3475	38.3475	38.2675	38.2675	59672.0
2017-06-01 09:00:00	AAPL	Stock	38.315	38.3175	38.2875	38.2925	19508.0
2017-06-01 09:30:00	AAPL	Stock	38.2925	38.3325	38.19	38.21	7958800.0
2017-06-01 10:00:00	AAPL	Stock	38.21	38.25	38.055	38.095	6942792.0
2017-06-01 10:30:00	AAPL	Stock	38.095	38.1675	38.0862	38.1488	3353076.0
2017-06-01 11:00:00	AAPL	Stock	38.1525	38.23	38.1425	38.205	3776344.0
2017-06-01 11:30:00	AAPL	Stock	38.205	38.235	38.1525	38.2262	2505652.0
2017-06-01 12:00:00	AAPL	Stock	38.226	38.255	38.1875	38.25	2124292.0
2017-06-01 12:30:00	AAPL	Stock	38.2488	38.275	38.2178	38.2375	2495316.0
2017-06-01 13:00:00	AAPL	Stock	38.2375	38.2875	38.2325	38.2785	3278100.0
2017-06-01 13:30:00	AAPL	Stock	38.2775	38.2775	38.22	38.2425	2392240.0
2017-06-01 14:00:00	AAPL	Stock	38.2425	38.2585	38.1975	38.2028	2333720.0
2017-06-01 14:30:00	AAPL	Stock	38.2025	38.2292	38.1725	38.1925	3044812.0
2017-06-01 15:00:00	AAPL	Stock	38.1875	38.245	38.1875	38.2038	2385344.0
2017-06-01 15:30:00	AAPL	Stock	38.205	38.3025	38.175	38.295	9270704.0
2017-06-01 16:00:00	AAPL	Stock	38.2975	38.31	38.23	38.3	4554588.0
2017-06-01 16:30:00	AAPL	Stock	38.295	38.3	38.275	38.275	21016.0
2017-06-01 17:00:00	AAPL	Stock	38.2775	38.295	38.2375	38.2575	174004.0
2017-06-01 17:30:00	AAPL	Stock	38.2875	38.2925	38.2825	38.2925	4900.0
2017-06-01 18:00:00	AAPL	Stock	38.28	38.2875	38.28	38.2875	5000.0
2017-06-01 18:30:00	AAPL	Stock	38.285	38.295	38.2675	38.2875	21444.0
2017-06-01 19:00:00	AAPL	Stock	38.2875	38.2875	38.2875	38.2875	400.0
2017-06-01 19:30:00	AAPL	Stock	38.2925	38.295	38.29	38.295	12652.0
2017-06-01 04:00:00	MSFT	Stock	70.1	70.1	70.1	70.1	308.0
2017-06-01 04:30:00	MSFT	Stock	70.3	70.3	70.3	70.3	1200.0
2017-06-01 05:00:00	MSFT	Stock	70.3	70.3	70.3	70.3	601.0
2017-06-01 05:30:00	MSFT	Stock	70.3	70.3	70.3	70.3	1900.0
2017-06-01 06:00:00	MSFT	Stock	70.11	70.11	70.11	70.11	550.0
2017-06-01 08:00:00	MSFT	Stock	69.84	70.24	69.84	70.24	35061.0
2017-06-01 08:30:00	MSFT	Stock	69.84	70.15	69.84	70.15	2887.0
2017-06-01 09:00:00	MSFT	Stock	70.16	70.23	70.05	70.23	9180.0
2017-06-01 09:30:00	MSFT	Stock	70.23	70.61	69.8	69.86	3513733.0
2017-06-01 10:00:00	MSFT	Stock	69.86	69.93	69.451	69.53	2527034.0
2017-06-01 10:30:00	MSFT	Stock	69.525	69.76	69.52	69.57	1305908.0
2017-06-01 11:00:00	MSFT	Stock	69.57	69.73	69.55	69.69	905056.0
2017-06-01 11:30:00	MSFT	Stock	69.7	69.815	69.67	69.81	779290.0
2017-06-01 12:00:00	MSFT	Stock	69.81	69.87	69.73	69.735	1334881.0
2017-06-01 12:30:00	MSFT	Stock	69.73	69.85	69.72	69.84	524539.0
2017-06-01 13:00:00	MSFT	Stock	69.84	69.89	69.82	69.83	624577.0
2017-06-01 13:30:00	MSFT	Stock	69.82	69.85	69.65	69.705	967635.0
2017-06-01 14:00:00	MSFT	Stock	69.7	69.879	69.695	69.842	864389.0
2017-06-01 14:30:00	MSFT	Stock	69.85	69.85	69.71	69.71	631006.0
2017-06-01 15:00:00	MSFT	Stock	69.71	69.93	69.71	69.875	687537.0
2017-06-01 15:30:00	MSFT	Stock	69.88	70.15	69.83	70.12	2845879.0

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

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