PREVIEW / stock_30min / 2018-06-13

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-06-13.parquet
  size:    1.7 MB
  rows:    84,000
  symbols: 2,837

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-06-13 04:00:00	AAPL	Stock	48.125	48.125	48.125	48.125	600.0
2018-06-13 05:00:00	AAPL	Stock	48.075	48.075	48.075	48.075	2000.0
2018-06-13 05:30:00	AAPL	Stock	48.075	48.075	48.075	48.075	800.0
2018-06-13 06:00:00	AAPL	Stock	48.0775	48.0775	48.0775	48.0775	800.0
2018-06-13 06:30:00	AAPL	Stock	48.0875	48.1	48.055	48.1	20212.0
2018-06-13 07:00:00	AAPL	Stock	48.1	48.1675	48.1	48.13	66092.0
2018-06-13 07:30:00	AAPL	Stock	48.13	48.1625	48.1225	48.1375	30580.0
2018-06-13 08:00:00	AAPL	Stock	48.155	48.155	48.08	48.1	72668.0
2018-06-13 08:30:00	AAPL	Stock	48.095	48.095	48.0725	48.08	39744.0
2018-06-13 09:00:00	AAPL	Stock	48.085	48.1575	48.075	48.1	98452.0
2018-06-13 09:30:00	AAPL	Stock	48.105	48.1475	47.9525	48.0875	7755032.0
2018-06-13 10:00:00	AAPL	Stock	48.09	48.125	48.015	48.1	3949696.0
2018-06-13 10:30:00	AAPL	Stock	48.1	48.1438	48.0275	48.125	3675540.0
2018-06-13 11:00:00	AAPL	Stock	48.1275	48.22	48.1275	48.165	3611540.0
2018-06-13 11:30:00	AAPL	Stock	48.1625	48.2125	48.1625	48.1862	1988416.0
2018-06-13 12:00:00	AAPL	Stock	48.1875	48.19	48.0525	48.085	2359180.0
2018-06-13 12:30:00	AAPL	Stock	48.0825	48.1025	48.0325	48.0468	2308872.0
2018-06-13 13:00:00	AAPL	Stock	48.0475	48.065	47.99	48.045	2280240.0
2018-06-13 13:30:00	AAPL	Stock	48.045	48.0725	48.0175	48.0425	1661756.0
2018-06-13 14:00:00	AAPL	Stock	48.0425	48.065	47.73	47.775	8207536.0
2018-06-13 14:30:00	AAPL	Stock	47.775	47.875	47.675	47.8675	6372124.0
2018-06-13 15:00:00	AAPL	Stock	47.8675	47.975	47.7325	47.78	5454868.0
2018-06-13 15:30:00	AAPL	Stock	47.78	47.8125	47.61	47.6775	11233532.0
2018-06-13 16:00:00	AAPL	Stock	47.675	47.8892	47.6395	47.65	12580388.0
2018-06-13 16:30:00	AAPL	Stock	47.65	47.675	47.65	47.65	62324.0
2018-06-13 17:00:00	AAPL	Stock	47.655	47.6725	47.6525	47.6675	8476.0
2018-06-13 17:30:00	AAPL	Stock	47.6725	47.675	47.6625	47.67	217740.0
2018-06-13 18:00:00	AAPL	Stock	47.67	47.675	47.66	47.66	11052.0
2018-06-13 18:30:00	AAPL	Stock	47.6725	47.675	47.665	47.675	26524.0
2018-06-13 19:00:00	AAPL	Stock	47.6675	47.6875	47.6675	47.675	9212.0
2018-06-13 19:30:00	AAPL	Stock	47.665	47.675	47.6625	47.6625	7600.0
2018-06-13 05:00:00	MSFT	Stock	101.85	101.85	101.85	101.85	100.0
2018-06-13 05:30:00	MSFT	Stock	101.85	101.88	101.85	101.88	200.0
2018-06-13 06:00:00	MSFT	Stock	101.83	101.83	101.73	101.73	300.0
2018-06-13 06:30:00	MSFT	Stock	101.79	101.79	101.79	101.79	200.0
2018-06-13 07:00:00	MSFT	Stock	101.45	101.75	101.45	101.74	1737.0
2018-06-13 07:30:00	MSFT	Stock	101.56	101.56	101.49	101.49	1421.0
2018-06-13 08:00:00	MSFT	Stock	101.59	101.76	101.35	101.5	5160.0
2018-06-13 08:30:00	MSFT	Stock	101.5	101.6	101.35	101.41	2593.0
2018-06-13 09:00:00	MSFT	Stock	101.55	101.79	101.4	101.69	8135.0
2018-06-13 09:30:00	MSFT	Stock	101.72	101.78	101.07	101.21	2550032.0
2018-06-13 10:00:00	MSFT	Stock	101.21	101.6	101.14	101.545	1527468.0
2018-06-13 10:30:00	MSFT	Stock	101.55	101.63	101.46	101.565	1297371.0
2018-06-13 11:00:00	MSFT	Stock	101.565	102.01	101.565	101.88	1290162.0
2018-06-13 11:30:00	MSFT	Stock	101.88	101.97	101.7	101.7	789532.0
2018-06-13 12:00:00	MSFT	Stock	101.705	101.715	101.4	101.44	918044.0
2018-06-13 12:30:00	MSFT	Stock	101.45	101.5	101.38	101.38	606828.0
2018-06-13 13:00:00	MSFT	Stock	101.38	101.38	101.21	101.35	648474.0
2018-06-13 13:30:00	MSFT	Stock	101.35	101.53	101.3	101.48	593748.0
2018-06-13 14:00:00	MSFT	Stock	101.48	101.5	100.58	100.815	2204983.0

> showing 50 of 84,000 rows — these rows as CSV

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