PREVIEW / stock_30min / 2017-06-09

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-09.parquet
  size:    1.6 MB
  rows:    81,094
  symbols: 3,041

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-09 04:30:00	AAPL	Stock	38.75	38.75	38.75	38.75	460.0
2017-06-09 05:00:00	AAPL	Stock	38.7975	38.7975	38.7975	38.7975	628.0
2017-06-09 05:30:00	AAPL	Stock	38.825	38.8375	38.8	38.8375	11984.0
2017-06-09 06:00:00	AAPL	Stock	38.7875	38.7875	38.7875	38.7875	756.0
2017-06-09 06:30:00	AAPL	Stock	38.795	38.795	38.7875	38.7875	4164.0
2017-06-09 07:00:00	AAPL	Stock	38.7825	38.7875	38.7825	38.7875	10188.0
2017-06-09 07:30:00	AAPL	Stock	38.7875	38.7875	38.775	38.7875	19480.0
2017-06-09 08:00:00	AAPL	Stock	38.7875	38.8175	38.75	38.8	104888.0
2017-06-09 08:30:00	AAPL	Stock	38.8	38.805	38.7925	38.8025	20760.0
2017-06-09 09:00:00	AAPL	Stock	38.795	38.8	38.79	38.79	41460.0
2017-06-09 09:30:00	AAPL	Stock	38.7975	38.7975	38.6025	38.71	10099240.0
2017-06-09 10:00:00	AAPL	Stock	38.71	38.7955	38.6725	38.7525	5494584.0
2017-06-09 10:30:00	AAPL	Stock	38.754	38.7875	38.6275	38.6625	5125736.0
2017-06-09 11:00:00	AAPL	Stock	38.6625	38.7025	38.44	38.455	7044704.0
2017-06-09 11:30:00	AAPL	Stock	38.455	38.5	38.395	38.46	6824472.0
2017-06-09 12:00:00	AAPL	Stock	38.4612	38.4638	38.025	38.0562	12727064.0
2017-06-09 12:30:00	AAPL	Stock	38.0575	38.0725	37.6052	37.8325	22281352.0
2017-06-09 13:00:00	AAPL	Stock	37.8325	37.89	37.52	37.6317	14865908.0
2017-06-09 13:30:00	AAPL	Stock	37.6325	37.65	37.1075	37.4238	26604256.0
2017-06-09 14:00:00	AAPL	Stock	37.4275	37.6775	37.35	37.385	17425764.0
2017-06-09 14:30:00	AAPL	Stock	37.39	37.39	36.505	36.9075	34111372.0
2017-06-09 15:00:00	AAPL	Stock	36.91	37.295	36.895	37.25	21644376.0
2017-06-09 15:30:00	AAPL	Stock	37.2548	37.26	36.87	37.2425	36728160.0
2017-06-09 16:00:00	AAPL	Stock	37.2425	37.245	37.145	37.225	15149716.0
2017-06-09 16:30:00	AAPL	Stock	37.21	37.245	37.175	37.2225	710104.0
2017-06-09 17:00:00	AAPL	Stock	37.2225	37.245	37.1875	37.2325	214620.0
2017-06-09 17:30:00	AAPL	Stock	37.225	37.2375	37.2225	37.2375	41236.0
2017-06-09 18:00:00	AAPL	Stock	37.2275	37.245	37.2275	37.245	44936.0
2017-06-09 18:30:00	AAPL	Stock	37.245	37.25	37.23	37.245	55568.0
2017-06-09 19:00:00	AAPL	Stock	37.245	37.2475	37.23	37.24	55460.0
2017-06-09 19:30:00	AAPL	Stock	37.23	37.24	37.23	37.24	85348.0
2017-06-09 04:00:00	MSFT	Stock	72.0	72.0	72.0	72.0	567.0
2017-06-09 05:30:00	MSFT	Stock	72.3	72.3	72.25	72.25	2431.0
2017-06-09 06:00:00	MSFT	Stock	72.25	72.25	72.25	72.25	400.0
2017-06-09 07:00:00	MSFT	Stock	72.2	72.2	72.2	72.2	100.0
2017-06-09 08:00:00	MSFT	Stock	72.03	72.2	72.03	72.1	4265.0
2017-06-09 08:30:00	MSFT	Stock	72.17	72.17	72.11	72.11	2578.0
2017-06-09 09:00:00	MSFT	Stock	72.12	72.15	72.03	72.07	6803.0
2017-06-09 09:30:00	MSFT	Stock	72.02	72.08	71.51	71.61	2194166.0
2017-06-09 10:00:00	MSFT	Stock	71.611	72.03	71.575	71.92	1700601.0
2017-06-09 10:30:00	MSFT	Stock	71.93	71.96	71.69	71.725	936555.0
2017-06-09 11:00:00	MSFT	Stock	71.73	71.805	71.4	71.48	1628737.0
2017-06-09 11:30:00	MSFT	Stock	71.48	71.58	71.24	71.24	1693777.0
2017-06-09 12:00:00	MSFT	Stock	71.23	71.26	70.55	70.654	3118193.0
2017-06-09 12:30:00	MSFT	Stock	70.66	70.68	70.36	70.603	2262598.0
2017-06-09 13:00:00	MSFT	Stock	70.61	70.636	69.92	70.194	2828022.0
2017-06-09 13:30:00	MSFT	Stock	70.195	70.2	69.65	69.67	3426154.0
2017-06-09 14:00:00	MSFT	Stock	69.66	69.96	69.4	69.665	3073240.0
2017-06-09 14:30:00	MSFT	Stock	69.665	69.68	68.59	69.33	5161969.0
2017-06-09 15:00:00	MSFT	Stock	69.34	70.05	69.31	70.035	4277311.0

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

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