PREVIEW / stock_30min / 2014-09-02

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-09-02.parquet
  size:    1.6 MB
  rows:    83,288
  symbols: 3,579

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
2014-09-02 04:00:00	AAPL	Stock	25.66	25.955	25.66	25.9125	163608.0
2014-09-02 04:30:00	AAPL	Stock	25.9125	25.9325	25.9125	25.9225	26292.0
2014-09-02 05:00:00	AAPL	Stock	25.9225	25.9225	25.9175	25.9175	19324.0
2014-09-02 05:30:00	AAPL	Stock	25.92	25.9225	25.8625	25.88	84300.0
2014-09-02 06:00:00	AAPL	Stock	25.88	25.9	25.8625	25.8975	34700.0
2014-09-02 06:30:00	AAPL	Stock	25.8975	25.905	25.8	25.8	175416.0
2014-09-02 07:00:00	AAPL	Stock	25.8	25.8425	25.7925	25.7925	197156.0
2014-09-02 07:30:00	AAPL	Stock	25.8	25.81	25.785	25.785	240668.0
2014-09-02 08:00:00	AAPL	Stock	25.8	25.9	25.625	25.815	964408.0
2014-09-02 08:30:00	AAPL	Stock	25.8125	25.82	25.7875	25.8	355976.0
2014-09-02 09:00:00	AAPL	Stock	25.8	25.8225	25.7675	25.7725	733460.0
2014-09-02 09:30:00	AAPL	Stock	25.765	25.7975	25.68	25.75	35311252.0
2014-09-02 10:00:00	AAPL	Stock	25.7475	25.935	25.7475	25.902	23026716.0
2014-09-02 10:30:00	AAPL	Stock	25.9002	25.9225	25.8475	25.9125	13673808.0
2014-09-02 11:00:00	AAPL	Stock	25.91	25.9225	25.8525	25.895	12671260.0
2014-09-02 11:30:00	AAPL	Stock	25.8975	25.9	25.825	25.8263	9081308.0
2014-09-02 12:00:00	AAPL	Stock	25.8275	25.8875	25.805	25.8825	10064648.0
2014-09-02 12:30:00	AAPL	Stock	25.88	25.8825	25.8175	25.835	8998904.0
2014-09-02 13:00:00	AAPL	Stock	25.8337	25.8625	25.8025	25.8188	6678932.0
2014-09-02 13:30:00	AAPL	Stock	25.8175	25.8675	25.775	25.8625	11062072.0
2014-09-02 14:00:00	AAPL	Stock	25.8622	25.8625	25.7938	25.83	7095368.0
2014-09-02 14:30:00	AAPL	Stock	25.83	25.83	25.7425	25.801	14857820.0
2014-09-02 15:00:00	AAPL	Stock	25.8015	25.8275	25.785	25.8125	7117252.0
2014-09-02 15:30:00	AAPL	Stock	25.81	25.825	25.775	25.825	18691924.0
2014-09-02 16:00:00	AAPL	Stock	25.825	25.8712	25.8038	25.8325	5345724.0
2014-09-02 16:30:00	AAPL	Stock	25.83	25.845	25.7925	25.8375	26160.0
2014-09-02 17:00:00	AAPL	Stock	25.8375	25.84	25.83	25.8325	90520.0
2014-09-02 17:30:00	AAPL	Stock	25.8375	25.8375	25.82	25.825	975320.0
2014-09-02 18:00:00	AAPL	Stock	25.8175	25.825	25.775	25.825	136256.0
2014-09-02 18:30:00	AAPL	Stock	25.8225	25.825	25.805	25.8125	93620.0
2014-09-02 19:00:00	AAPL	Stock	25.8125	25.82	25.7875	25.8	68708.0
2014-09-02 19:30:00	AAPL	Stock	25.7925	25.82	25.7925	25.815	43976.0
2014-09-02 07:00:00	MSFT	Stock	45.49	45.49	45.49	45.49	100.0
2014-09-02 07:30:00	MSFT	Stock	45.46	45.46	45.46	45.46	925.0
2014-09-02 08:00:00	MSFT	Stock	45.45	45.45	45.44	45.44	1289.0
2014-09-02 08:30:00	MSFT	Stock	45.43	45.43	45.43	45.43	100.0
2014-09-02 09:00:00	MSFT	Stock	45.36	45.45	45.36	45.43	22895.0
2014-09-02 09:30:00	MSFT	Stock	45.43	45.46	44.96	44.99	3127989.0
2014-09-02 10:00:00	MSFT	Stock	45.0	45.05	44.88	44.93	1837967.0
2014-09-02 10:30:00	MSFT	Stock	44.93	44.99	44.9	44.944	1539557.0
2014-09-02 11:00:00	MSFT	Stock	44.95	44.96	44.86	44.92	1931379.0
2014-09-02 11:30:00	MSFT	Stock	44.92	44.97	44.89	44.92	867393.0
2014-09-02 12:00:00	MSFT	Stock	44.92	44.966	44.85	44.9	1516755.0
2014-09-02 12:30:00	MSFT	Stock	44.895	44.93	44.86	44.88	774761.0
2014-09-02 13:00:00	MSFT	Stock	44.88	44.92	44.862	44.875	575740.0
2014-09-02 13:30:00	MSFT	Stock	44.875	44.98	44.86	44.96	746106.0
2014-09-02 14:00:00	MSFT	Stock	44.96	44.99	44.95	44.96	607681.0
2014-09-02 14:30:00	MSFT	Stock	44.965	44.97	44.93	44.93	686214.0
2014-09-02 15:00:00	MSFT	Stock	44.94	44.95	44.9	44.945	754937.0
2014-09-02 15:30:00	MSFT	Stock	44.95	45.09	44.95	45.09	3278176.0

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

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