PREVIEW / stock_30min / 2018-09-12

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-12.parquet
  size:    1.7 MB
  rows:    83,616
  symbols: 2,791

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-09-12 04:00:00	AAPL	Stock	56.25	56.375	56.25	56.305	67460.0
2018-09-12 04:30:00	AAPL	Stock	56.2775	56.3325	56.275	56.32	13980.0
2018-09-12 05:00:00	AAPL	Stock	56.31	56.31	56.275	56.275	19492.0
2018-09-12 05:30:00	AAPL	Stock	56.255	56.3	56.255	56.2875	15392.0
2018-09-12 06:00:00	AAPL	Stock	56.285	56.285	56.2425	56.265	42620.0
2018-09-12 06:30:00	AAPL	Stock	56.2525	56.265	56.19	56.245	28236.0
2018-09-12 07:00:00	AAPL	Stock	56.205	56.325	56.15	56.23	312064.0
2018-09-12 07:30:00	AAPL	Stock	56.205	56.2125	56.1275	56.21	163096.0
2018-09-12 08:00:00	AAPL	Stock	56.22	56.325	56.1325	56.21	571000.0
2018-09-12 08:30:00	AAPL	Stock	56.24	56.24	56.095	56.13	383508.0
2018-09-12 09:00:00	AAPL	Stock	56.135	56.235	56.095	56.2225	385756.0
2018-09-12 09:30:00	AAPL	Stock	56.235	56.25	55.0675	55.2065	25942604.0
2018-09-12 10:00:00	AAPL	Stock	55.2125	55.53	55.175	55.26	10377688.0
2018-09-12 10:30:00	AAPL	Stock	55.2675	55.2975	54.96	55.01	10227504.0
2018-09-12 11:00:00	AAPL	Stock	55.008	55.6048	54.98	55.5525	12752804.0
2018-09-12 11:30:00	AAPL	Stock	55.555	55.775	55.1862	55.2175	9016592.0
2018-09-12 12:00:00	AAPL	Stock	55.2175	55.4975	55.2075	55.4025	5564280.0
2018-09-12 12:30:00	AAPL	Stock	55.4025	55.465	55.2725	55.2862	4634028.0
2018-09-12 13:00:00	AAPL	Stock	55.2855	56.0	55.2825	55.9825	14912196.0
2018-09-12 13:30:00	AAPL	Stock	55.985	56.105	55.405	55.4945	15444316.0
2018-09-12 14:00:00	AAPL	Stock	55.4925	55.57	55.1625	55.2775	10107552.0
2018-09-12 14:30:00	AAPL	Stock	55.275	55.3748	54.97	55.0942	12059312.0
2018-09-12 15:00:00	AAPL	Stock	55.0938	55.62	55.0938	55.499	10834460.0
2018-09-12 15:30:00	AAPL	Stock	55.5025	55.515	55.09	55.265	15184660.0
2018-09-12 16:00:00	AAPL	Stock	55.2675	55.305	55.2275	55.295	8457672.0
2018-09-12 16:30:00	AAPL	Stock	55.295	55.2975	55.2675	55.2825	47264.0
2018-09-12 17:00:00	AAPL	Stock	55.2675	55.37	55.25	55.3075	203904.0
2018-09-12 17:30:00	AAPL	Stock	55.3075	55.32	55.2568	55.3062	36920.0
2018-09-12 18:00:00	AAPL	Stock	55.31	55.325	55.2225	55.25	90208.0
2018-09-12 18:30:00	AAPL	Stock	55.2525	55.275	55.2475	55.2675	22748.0
2018-09-12 19:00:00	AAPL	Stock	55.2875	55.3	55.2575	55.265	15232.0
2018-09-12 19:30:00	AAPL	Stock	55.275	55.275	55.2	55.225	52680.0
2018-09-12 04:00:00	MSFT	Stock	111.58	111.8	111.5	111.5	3163.0
2018-09-12 04:30:00	MSFT	Stock	111.79	111.79	111.79	111.79	498.0
2018-09-12 05:00:00	MSFT	Stock	111.75	111.9	111.7	111.8	3325.0
2018-09-12 05:30:00	MSFT	Stock	111.65	111.7	111.65	111.69	2372.0
2018-09-12 06:00:00	MSFT	Stock	111.7	111.7	111.7	111.7	1993.0
2018-09-12 07:00:00	MSFT	Stock	111.7	111.7	111.49	111.49	1540.0
2018-09-12 07:30:00	MSFT	Stock	111.5	111.5	111.24	111.3	5545.0
2018-09-12 08:00:00	MSFT	Stock	111.38	111.69	111.3	111.4	8493.0
2018-09-12 08:30:00	MSFT	Stock	111.45	111.5	111.2	111.27	11064.0
2018-09-12 09:00:00	MSFT	Stock	111.33	111.4	111.07	111.4	15750.0
2018-09-12 09:30:00	MSFT	Stock	111.43	111.641	111.0	111.22	1971739.0
2018-09-12 10:00:00	MSFT	Stock	111.22	111.68	111.0	111.13	1607441.0
2018-09-12 10:30:00	MSFT	Stock	111.13	111.146	110.51	110.775	1186705.0
2018-09-12 11:00:00	MSFT	Stock	110.78	111.6	110.73	111.5	1598326.0
2018-09-12 11:30:00	MSFT	Stock	111.49	111.595	110.67	110.68	1119778.0
2018-09-12 12:00:00	MSFT	Stock	110.68	111.33	110.67	111.31	775087.0
2018-09-12 12:30:00	MSFT	Stock	111.309	111.45	111.175	111.295	568777.0
2018-09-12 13:00:00	MSFT	Stock	111.295	111.38	111.04	111.34	563305.0

> showing 50 of 83,616 rows — these rows as CSV

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