PREVIEW / stock_30min / 2014-01-29

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-29.parquet
  size:    1.6 MB
  rows:    82,974
  symbols: 3,524

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-01-29 04:00:00	AAPL	Stock	18.1929	18.3125	18.1929	18.2514	247212.0
2014-01-29 04:30:00	AAPL	Stock	18.25	18.2682	18.2414	18.2589	54180.0
2014-01-29 05:00:00	AAPL	Stock	18.2589	18.2589	18.215	18.2161	127064.0
2014-01-29 05:30:00	AAPL	Stock	18.2161	18.2446	18.1804	18.2143	132916.0
2014-01-29 06:00:00	AAPL	Stock	18.2125	18.2143	18.1964	18.1964	66920.0
2014-01-29 06:30:00	AAPL	Stock	18.2071	18.2071	18.1429	18.1429	145348.0
2014-01-29 07:00:00	AAPL	Stock	18.1696	18.2107	18.1518	18.1646	342496.0
2014-01-29 07:30:00	AAPL	Stock	18.175	18.1857	18.0714	18.125	648200.0
2014-01-29 08:00:00	AAPL	Stock	18.125	18.2143	18.0914	18.0946	888888.0
2014-01-29 08:30:00	AAPL	Stock	18.1061	18.1232	18.0432	18.0486	1046136.0
2014-01-29 09:00:00	AAPL	Stock	18.0486	18.0511	17.9521	18.0	2883328.0
2014-01-29 09:30:00	AAPL	Stock	17.9982	18.1204	17.9336	18.0079	81908288.0
2014-01-29 10:00:00	AAPL	Stock	18.009	18.0289	17.8079	17.9089	78107008.0
2014-01-29 10:30:00	AAPL	Stock	17.9032	17.9196	17.8218	17.8754	40474336.0
2014-01-29 11:00:00	AAPL	Stock	17.8829	18.0143	17.8807	17.978	30940448.0
2014-01-29 11:30:00	AAPL	Stock	17.9789	18.0	17.9464	17.9675	14586348.0
2014-01-29 12:00:00	AAPL	Stock	17.9643	17.9719	17.8786	17.8828	14706720.0
2014-01-29 12:30:00	AAPL	Stock	17.8821	17.9204	17.8714	17.8864	11839128.0
2014-01-29 13:00:00	AAPL	Stock	17.8857	17.925	17.8614	17.8967	10268972.0
2014-01-29 13:30:00	AAPL	Stock	17.8975	17.9364	17.8896	17.9279	11272100.0
2014-01-29 14:00:00	AAPL	Stock	17.9294	17.9764	17.8554	17.8943	32324208.0
2014-01-29 14:30:00	AAPL	Stock	17.8927	17.9536	17.8571	17.8629	20256236.0
2014-01-29 15:00:00	AAPL	Stock	17.8643	17.8996	17.8311	17.8839	24935344.0
2014-01-29 15:30:00	AAPL	Stock	17.88	17.94	17.8646	17.8764	32728192.0
2014-01-29 16:00:00	AAPL	Stock	17.8775	18.0876	17.8668	17.8811	9487296.0
2014-01-29 16:30:00	AAPL	Stock	17.8786	17.9122	17.8668	17.8836	527940.0
2014-01-29 17:00:00	AAPL	Stock	17.8821	17.9	17.8768	17.9	265188.0
2014-01-29 17:30:00	AAPL	Stock	17.8929	17.9	17.8846	17.9	131432.0
2014-01-29 18:00:00	AAPL	Stock	17.9	17.9243	17.8775	17.9054	240856.0
2014-01-29 18:30:00	AAPL	Stock	17.9	17.9196	17.9	17.9196	85344.0
2014-01-29 19:00:00	AAPL	Stock	17.9136	17.9136	17.8964	17.8975	131712.0
2014-01-29 19:30:00	AAPL	Stock	17.8986	17.9086	17.8929	17.8929	158928.0
2014-01-29 07:00:00	MSFT	Stock	36.46	36.46	36.33	36.33	2400.0
2014-01-29 07:30:00	MSFT	Stock	36.23	36.23	36.23	36.23	500.0
2014-01-29 08:00:00	MSFT	Stock	36.47	36.47	36.17	36.17	1560.0
2014-01-29 08:30:00	MSFT	Stock	36.17	36.17	36.03	36.1	6412.0
2014-01-29 09:00:00	MSFT	Stock	36.17	36.27	35.89	36.01	41194.0
2014-01-29 09:30:00	MSFT	Stock	35.98	36.37	35.9	36.29	4237893.0
2014-01-29 10:00:00	MSFT	Stock	36.28	36.32	36.18	36.23	4500896.0
2014-01-29 10:30:00	MSFT	Stock	36.23	36.585	36.19	36.47	2659717.0
2014-01-29 11:00:00	MSFT	Stock	36.47	36.58	36.47	36.57	1853300.0
2014-01-29 11:30:00	MSFT	Stock	36.56	36.72	36.56	36.7	2808870.0
2014-01-29 12:00:00	MSFT	Stock	36.704	36.75	36.67	36.72	2250682.0
2014-01-29 12:30:00	MSFT	Stock	36.71	36.74	36.63	36.69	4062887.0
2014-01-29 13:00:00	MSFT	Stock	36.68	36.75	36.63	36.685	3139219.0
2014-01-29 13:30:00	MSFT	Stock	36.685	36.71	36.55	36.71	2164023.0
2014-01-29 14:00:00	MSFT	Stock	36.709	36.77	36.495	36.75	4782929.0
2014-01-29 14:30:00	MSFT	Stock	36.75	36.88	36.54	36.58	2929258.0
2014-01-29 15:00:00	MSFT	Stock	36.57	36.71	36.52	36.65	3261898.0
2014-01-29 15:30:00	MSFT	Stock	36.65	36.82	36.61	36.65	7502634.0

> showing 50 of 82,974 rows — these rows as CSV

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