PREVIEW / stock_30min / 2017-03-06

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-06.parquet
  size:    1.6 MB
  rows:    83,514
  symbols: 3,097

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-03-06 04:30:00	AAPL	Stock	34.85	34.8725	34.845	34.8725	3828.0
2017-03-06 05:00:00	AAPL	Stock	34.8125	34.8125	34.8125	34.8125	432.0
2017-03-06 05:30:00	AAPL	Stock	34.86	34.86	34.86	34.86	3200.0
2017-03-06 06:00:00	AAPL	Stock	34.875	34.875	34.875	34.875	1900.0
2017-03-06 06:30:00	AAPL	Stock	34.885	34.885	34.84	34.84	5212.0
2017-03-06 07:00:00	AAPL	Stock	34.85	34.8625	34.825	34.845	26192.0
2017-03-06 07:30:00	AAPL	Stock	34.845	34.8475	34.815	34.8375	23724.0
2017-03-06 08:00:00	AAPL	Stock	34.825	34.8675	34.825	34.8475	68344.0
2017-03-06 08:30:00	AAPL	Stock	34.84	34.8625	34.8375	34.8575	57848.0
2017-03-06 09:00:00	AAPL	Stock	34.8575	34.87	34.83	34.85	116932.0
2017-03-06 09:30:00	AAPL	Stock	34.8412	34.9425	34.7712	34.8175	12082960.0
2017-03-06 10:00:00	AAPL	Stock	34.8182	34.8182	34.675	34.7075	7753360.0
2017-03-06 10:30:00	AAPL	Stock	34.705	34.735	34.665	34.67	5171336.0
2017-03-06 11:00:00	AAPL	Stock	34.6725	34.73	34.65	34.68	4091296.0
2017-03-06 11:30:00	AAPL	Stock	34.6805	34.695	34.6525	34.6775	2638524.0
2017-03-06 12:00:00	AAPL	Stock	34.676	34.695	34.649	34.6725	2524440.0
2017-03-06 12:30:00	AAPL	Stock	34.6738	34.7225	34.66	34.715	3238860.0
2017-03-06 13:00:00	AAPL	Stock	34.7162	34.8125	34.715	34.81	5193476.0
2017-03-06 13:30:00	AAPL	Stock	34.8112	34.8375	34.771	34.8225	3372272.0
2017-03-06 14:00:00	AAPL	Stock	34.822	34.835	34.8025	34.8315	2114712.0
2017-03-06 14:30:00	AAPL	Stock	34.8312	34.8575	34.8225	34.8375	2650400.0
2017-03-06 15:00:00	AAPL	Stock	34.8375	34.8648	34.815	34.815	3082344.0
2017-03-06 15:30:00	AAPL	Stock	34.8175	34.885	34.815	34.83	6290680.0
2017-03-06 16:00:00	AAPL	Stock	34.835	34.8625	34.835	34.8625	7719408.0
2017-03-06 16:30:00	AAPL	Stock	34.845	34.8475	34.835	34.8425	245880.0
2017-03-06 17:00:00	AAPL	Stock	34.84	34.84	34.8325	34.8325	24104.0
2017-03-06 17:30:00	AAPL	Stock	34.835	34.835	34.835	34.835	1616.0
2017-03-06 18:00:00	AAPL	Stock	34.82	34.82	34.82	34.82	2000.0
2017-03-06 18:30:00	AAPL	Stock	34.82	34.835	34.82	34.835	6456.0
2017-03-06 19:00:00	AAPL	Stock	34.83	34.83	34.83	34.83	700.0
2017-03-06 19:30:00	AAPL	Stock	34.82	34.85	34.82	34.8375	14876.0
2017-03-06 04:00:00	MSFT	Stock	64.0	64.0	64.0	64.0	100.0
2017-03-06 04:30:00	MSFT	Stock	64.0	64.0	64.0	64.0	400.0
2017-03-06 07:00:00	MSFT	Stock	64.19	64.19	64.15	64.15	2055.0
2017-03-06 07:30:00	MSFT	Stock	64.15	64.15	64.15	64.15	849.0
2017-03-06 08:00:00	MSFT	Stock	64.02	64.02	64.02	64.02	101.0
2017-03-06 08:30:00	MSFT	Stock	64.15	64.15	64.02	64.02	1717.0
2017-03-06 09:00:00	MSFT	Stock	64.04	64.1	63.98	64.02	15802.0
2017-03-06 09:30:00	MSFT	Stock	64.0	64.35	63.81	64.24	1881369.0
2017-03-06 10:00:00	MSFT	Stock	64.24	64.31	64.08	64.14	1283083.0
2017-03-06 10:30:00	MSFT	Stock	64.135	64.19	64.045	64.17	737814.0
2017-03-06 11:00:00	MSFT	Stock	64.17	64.29	64.13	64.26	611290.0
2017-03-06 11:30:00	MSFT	Stock	64.25	64.3	64.235	64.27	571010.0
2017-03-06 12:00:00	MSFT	Stock	64.27	64.33	64.24	64.291	495334.0
2017-03-06 12:30:00	MSFT	Stock	64.29	64.44	64.29	64.37	1223926.0
2017-03-06 13:00:00	MSFT	Stock	64.38	64.56	64.37	64.515	939975.0
2017-03-06 13:30:00	MSFT	Stock	64.51	64.535	64.44	64.455	846005.0
2017-03-06 14:00:00	MSFT	Stock	64.46	64.48	64.44	64.475	885038.0
2017-03-06 14:30:00	MSFT	Stock	64.47	64.48	64.42	64.45	596641.0
2017-03-06 15:00:00	MSFT	Stock	64.45	64.48	64.43	64.45	876731.0

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

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