PREVIEW / stock_30min / 2017-08-21

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-21.parquet
  size:    1.6 MB
  rows:    79,370
  symbols: 2,969

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-08-21 04:00:00	AAPL	Stock	39.3625	39.3625	39.36	39.36	1268.0
2017-08-21 04:30:00	AAPL	Stock	39.2875	39.3	39.2875	39.3	4052.0
2017-08-21 05:00:00	AAPL	Stock	39.325	39.325	39.325	39.325	400.0
2017-08-21 05:30:00	AAPL	Stock	39.3675	39.3675	39.35	39.35	2200.0
2017-08-21 06:00:00	AAPL	Stock	39.35	39.37	39.3425	39.37	9776.0
2017-08-21 06:30:00	AAPL	Stock	39.415	39.44	39.415	39.4175	13708.0
2017-08-21 07:00:00	AAPL	Stock	39.425	39.4375	39.415	39.4275	12316.0
2017-08-21 07:30:00	AAPL	Stock	39.4375	39.4625	39.43	39.4375	29644.0
2017-08-21 08:00:00	AAPL	Stock	39.4175	39.46	39.4	39.425	83580.0
2017-08-21 08:30:00	AAPL	Stock	39.4325	39.45	39.3875	39.425	111192.0
2017-08-21 09:00:00	AAPL	Stock	39.4225	39.425	39.355	39.375	85388.0
2017-08-21 09:30:00	AAPL	Stock	39.375	39.4725	39.2175	39.2242	12286696.0
2017-08-21 10:00:00	AAPL	Stock	39.2225	39.2675	38.7775	38.92	16055112.0
2017-08-21 10:30:00	AAPL	Stock	38.9175	38.9875	38.79	38.955	8651232.0
2017-08-21 11:00:00	AAPL	Stock	38.955	39.1475	38.8575	39.1025	7081912.0
2017-08-21 11:30:00	AAPL	Stock	39.1025	39.3225	39.1025	39.2325	6127212.0
2017-08-21 12:00:00	AAPL	Stock	39.2325	39.3625	39.195	39.3225	3951032.0
2017-08-21 12:30:00	AAPL	Stock	39.32	39.35	39.24	39.3025	3860656.0
2017-08-21 13:00:00	AAPL	Stock	39.3025	39.32	39.195	39.22	3313696.0
2017-08-21 13:30:00	AAPL	Stock	39.2212	39.2675	39.1325	39.1425	3524688.0
2017-08-21 14:00:00	AAPL	Stock	39.1475	39.2025	39.1175	39.1825	2608904.0
2017-08-21 14:30:00	AAPL	Stock	39.18	39.2075	39.1312	39.1845	2710584.0
2017-08-21 15:00:00	AAPL	Stock	39.1825	39.19	39.03	39.1862	4976680.0
2017-08-21 15:30:00	AAPL	Stock	39.1875	39.3525	39.185	39.29	9695600.0
2017-08-21 16:00:00	AAPL	Stock	39.2925	39.3025	39.285	39.3025	9138704.0
2017-08-21 16:30:00	AAPL	Stock	39.2875	39.3025	39.28	39.3	85872.0
2017-08-21 17:00:00	AAPL	Stock	39.2775	39.2875	39.25	39.2575	63792.0
2017-08-21 17:30:00	AAPL	Stock	39.2625	39.29	39.255	39.29	15060.0
2017-08-21 18:00:00	AAPL	Stock	39.29	39.3025	39.285	39.29	66272.0
2017-08-21 18:30:00	AAPL	Stock	39.29	39.3025	39.2875	39.3025	21868.0
2017-08-21 19:30:00	AAPL	Stock	39.3	39.305	39.2725	39.3	12400.0
2017-08-21 06:30:00	MSFT	Stock	72.45	72.45	72.45	72.45	100.0
2017-08-21 08:00:00	MSFT	Stock	72.5	72.5	72.5	72.5	650.0
2017-08-21 09:00:00	MSFT	Stock	72.58	72.58	72.5	72.5	1322.0
2017-08-21 09:30:00	MSFT	Stock	72.47	72.48	72.055	72.083	1506123.0
2017-08-21 10:00:00	MSFT	Stock	72.07	72.14	71.815	71.86	1374749.0
2017-08-21 10:30:00	MSFT	Stock	71.85	71.98	71.79	71.84	1113675.0
2017-08-21 11:00:00	MSFT	Stock	71.83	72.135	71.75	72.02	1182236.0
2017-08-21 11:30:00	MSFT	Stock	72.03	72.29	72.03	72.11	902406.0
2017-08-21 12:00:00	MSFT	Stock	72.11	72.35	72.09	72.264	668052.0
2017-08-21 12:30:00	MSFT	Stock	72.26	72.3	72.085	72.121	822243.0
2017-08-21 13:00:00	MSFT	Stock	72.12	72.15	71.96	71.99	576073.0
2017-08-21 13:30:00	MSFT	Stock	71.99	72.05	71.934	71.98	529471.0
2017-08-21 14:00:00	MSFT	Stock	71.975	72.05	71.96	71.99	567679.0
2017-08-21 14:30:00	MSFT	Stock	71.98	72.05	71.855	71.935	874646.0
2017-08-21 15:00:00	MSFT	Stock	71.93	71.99	71.7	71.985	1033879.0
2017-08-21 15:30:00	MSFT	Stock	71.985	72.21	71.925	72.14	2385644.0
2017-08-21 16:00:00	MSFT	Stock	72.15	72.25	72.05	72.25	2703155.0
2017-08-21 16:30:00	MSFT	Stock	72.15	72.16	72.15	72.16	714.0
2017-08-21 18:00:00	MSFT	Stock	72.16	72.16	72.15	72.15	20972.0

> showing 50 of 79,370 rows — these rows as CSV

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