PREVIEW / stock_30min / 2016-09-15

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-09-15.parquet
  size:    1.6 MB
  rows:    81,459
  symbols: 3,223

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
2016-09-15 04:00:00	AAPL	Stock	27.9225	28.045	27.8925	28.045	30028.0
2016-09-15 04:30:00	AAPL	Stock	28.025	28.0625	28.0225	28.05	7580.0
2016-09-15 05:00:00	AAPL	Stock	28.0825	28.105	28.0575	28.105	5272.0
2016-09-15 05:30:00	AAPL	Stock	28.1	28.1725	28.09	28.165	43760.0
2016-09-15 06:00:00	AAPL	Stock	28.15	28.24	28.1375	28.24	184112.0
2016-09-15 06:30:00	AAPL	Stock	28.235	28.25	28.16	28.1975	161008.0
2016-09-15 07:00:00	AAPL	Stock	28.2	28.25	28.1875	28.2	295896.0
2016-09-15 07:30:00	AAPL	Stock	28.2	28.275	28.1875	28.2675	272160.0
2016-09-15 08:00:00	AAPL	Stock	28.255	28.385	28.1875	28.35	1678044.0
2016-09-15 08:30:00	AAPL	Stock	28.3625	28.4975	28.3175	28.48	1921276.0
2016-09-15 09:00:00	AAPL	Stock	28.48	28.5	28.375	28.46	2623400.0
2016-09-15 09:30:00	AAPL	Stock	28.465	28.7375	28.3725	28.735	78999724.0
2016-09-15 10:00:00	AAPL	Stock	28.7325	28.8125	28.645	28.79	42952736.0
2016-09-15 10:30:00	AAPL	Stock	28.7925	28.8775	28.735	28.81	31796384.0
2016-09-15 11:00:00	AAPL	Stock	28.8075	28.85	28.71	28.7475	23306168.0
2016-09-15 11:30:00	AAPL	Stock	28.75	28.8	28.68	28.7462	15145664.0
2016-09-15 12:00:00	AAPL	Stock	28.7462	28.875	28.7315	28.7812	16036360.0
2016-09-15 12:30:00	AAPL	Stock	28.78	28.7875	28.6925	28.761	13834404.0
2016-09-15 13:00:00	AAPL	Stock	28.7625	28.8078	28.6712	28.7075	12497972.0
2016-09-15 13:30:00	AAPL	Stock	28.71	28.79	28.7025	28.7825	12643348.0
2016-09-15 14:00:00	AAPL	Stock	28.7825	28.8225	28.7525	28.76	10178412.0
2016-09-15 14:30:00	AAPL	Stock	28.7625	28.85	28.7525	28.8422	12353332.0
2016-09-15 15:00:00	AAPL	Stock	28.8425	28.8725	28.7575	28.8328	16627404.0
2016-09-15 15:30:00	AAPL	Stock	28.8325	28.9325	28.8275	28.8925	31066064.0
2016-09-15 16:00:00	AAPL	Stock	28.8875	28.9125	28.751	28.8375	15806836.0
2016-09-15 16:30:00	AAPL	Stock	28.8375	28.85	28.82	28.85	276008.0
2016-09-15 17:00:00	AAPL	Stock	28.855	28.8925	28.8475	28.8525	889124.0
2016-09-15 17:30:00	AAPL	Stock	28.855	28.8975	28.85	28.8675	243484.0
2016-09-15 18:00:00	AAPL	Stock	28.88	28.9	28.845	28.845	118452.0
2016-09-15 18:30:00	AAPL	Stock	28.845	28.87	28.83	28.8675	101360.0
2016-09-15 19:00:00	AAPL	Stock	28.8675	28.8675	28.85	28.865	61376.0
2016-09-15 19:30:00	AAPL	Stock	28.865	28.875	28.85	28.85	86024.0
2016-09-15 07:00:00	MSFT	Stock	56.26	56.26	56.26	56.26	220.0
2016-09-15 08:00:00	MSFT	Stock	56.35	56.35	56.26	56.26	650.0
2016-09-15 08:30:00	MSFT	Stock	56.35	56.36	56.07	56.17	18029.0
2016-09-15 09:00:00	MSFT	Stock	56.22	56.22	56.1	56.1	1785.0
2016-09-15 09:30:00	MSFT	Stock	56.15	56.33	55.98	56.22	2978641.0
2016-09-15 10:00:00	MSFT	Stock	56.22	56.63	56.167	56.62	2135428.0
2016-09-15 10:30:00	MSFT	Stock	56.63	56.87	56.464	56.86	1445522.0
2016-09-15 11:00:00	MSFT	Stock	56.86	56.93	56.735	56.89	1443662.0
2016-09-15 11:30:00	MSFT	Stock	56.89	56.99	56.85	56.885	1213399.0
2016-09-15 12:00:00	MSFT	Stock	56.89	56.99	56.88	56.975	952974.0
2016-09-15 12:30:00	MSFT	Stock	56.97	57.0	56.835	56.875	1106317.0
2016-09-15 13:00:00	MSFT	Stock	56.88	57.02	56.87	56.985	977828.0
2016-09-15 13:30:00	MSFT	Stock	56.99	57.12	56.96	57.12	1080727.0
2016-09-15 14:00:00	MSFT	Stock	57.12	57.26	57.065	57.21	1409963.0
2016-09-15 14:30:00	MSFT	Stock	57.21	57.35	57.21	57.284	1278122.0
2016-09-15 15:00:00	MSFT	Stock	57.29	57.35	57.2	57.255	1526456.0
2016-09-15 15:30:00	MSFT	Stock	57.256	57.31	57.18	57.19	3467388.0
2016-09-15 16:00:00	MSFT	Stock	57.19	57.2	57.15	57.19	4334760.0

> showing 50 of 81,459 rows — these rows as CSV

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