PREVIEW / stock_30min / 2015-02-09

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-09.parquet
  size:    1.6 MB
  rows:    82,600
  symbols: 3,522

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
2015-02-09 04:00:00	AAPL	Stock	29.6875	29.6875	29.6	29.62	20912.0
2015-02-09 04:30:00	AAPL	Stock	29.5925	29.5925	29.5475	29.5575	5112.0
2015-02-09 05:00:00	AAPL	Stock	29.5375	29.5575	29.5375	29.5375	29400.0
2015-02-09 05:30:00	AAPL	Stock	29.545	29.58	29.5	29.5	24572.0
2015-02-09 06:00:00	AAPL	Stock	29.525	29.56	29.5125	29.5125	22428.0
2015-02-09 06:30:00	AAPL	Stock	29.5125	29.55	29.5	29.55	13768.0
2015-02-09 07:00:00	AAPL	Stock	29.5375	29.575	29.5375	29.5675	26400.0
2015-02-09 07:30:00	AAPL	Stock	29.575	29.6075	29.575	29.5925	35112.0
2015-02-09 08:00:00	AAPL	Stock	29.6075	29.6875	29.5025	29.675	362088.0
2015-02-09 08:30:00	AAPL	Stock	29.685	29.685	29.625	29.6675	231976.0
2015-02-09 09:00:00	AAPL	Stock	29.6625	29.67	29.6125	29.645	165400.0
2015-02-09 09:30:00	AAPL	Stock	29.6375	29.81	29.6075	29.7	20843052.0
2015-02-09 10:00:00	AAPL	Stock	29.6975	29.845	29.695	29.7435	13737476.0
2015-02-09 10:30:00	AAPL	Stock	29.7425	29.8075	29.7	29.7225	11016440.0
2015-02-09 11:00:00	AAPL	Stock	29.7225	29.8615	29.7125	29.846	9695588.0
2015-02-09 11:30:00	AAPL	Stock	29.8475	29.8925	29.8125	29.8388	7861524.0
2015-02-09 12:00:00	AAPL	Stock	29.8388	29.875	29.8125	29.8675	5581112.0
2015-02-09 12:30:00	AAPL	Stock	29.8675	29.9	29.859	29.8875	5434548.0
2015-02-09 13:00:00	AAPL	Stock	29.885	29.9375	29.8625	29.8635	8084344.0
2015-02-09 13:30:00	AAPL	Stock	29.8625	29.9225	29.84	29.8962	6514392.0
2015-02-09 14:00:00	AAPL	Stock	29.8978	29.9575	29.8675	29.9428	8046560.0
2015-02-09 14:30:00	AAPL	Stock	29.9448	29.96	29.8475	29.86	8219452.0
2015-02-09 15:00:00	AAPL	Stock	29.8575	29.8975	29.7775	29.8925	11386532.0
2015-02-09 15:30:00	AAPL	Stock	29.895	29.9575	29.84	29.93	18601928.0
2015-02-09 16:00:00	AAPL	Stock	29.926	29.9475	29.718	29.945	5034408.0
2015-02-09 16:30:00	AAPL	Stock	29.9475	29.9475	29.8368	29.8368	64472.0
2015-02-09 17:00:00	AAPL	Stock	29.9425	29.9625	29.93	29.96	232408.0
2015-02-09 17:30:00	AAPL	Stock	29.9575	29.9725	29.93	29.9725	1849608.0
2015-02-09 18:00:00	AAPL	Stock	29.9725	29.975	29.93	29.93	147400.0
2015-02-09 18:30:00	AAPL	Stock	29.97	29.9775	29.97	29.9775	31432.0
2015-02-09 19:00:00	AAPL	Stock	29.9775	29.985	29.975	29.98	41300.0
2015-02-09 19:30:00	AAPL	Stock	29.985	29.985	29.965	29.975	66824.0
2015-02-09 07:30:00	MSFT	Stock	42.2	42.2	42.2	42.2	200.0
2015-02-09 08:00:00	MSFT	Stock	42.25	42.29	42.15	42.26	7364.0
2015-02-09 08:30:00	MSFT	Stock	42.21	42.28	42.16	42.28	1201.0
2015-02-09 09:00:00	MSFT	Stock	42.19	42.28	42.19	42.25	7480.0
2015-02-09 09:30:00	MSFT	Stock	42.24	42.55	42.21	42.34	3155554.0
2015-02-09 10:00:00	MSFT	Stock	42.34	42.53	42.28	42.415	2014474.0
2015-02-09 10:30:00	MSFT	Stock	42.41	42.5	42.29	42.311	1889562.0
2015-02-09 11:00:00	MSFT	Stock	42.31	42.68	42.31	42.66	2590039.0
2015-02-09 11:30:00	MSFT	Stock	42.66	42.74	42.58	42.6	1688624.0
2015-02-09 12:00:00	MSFT	Stock	42.6	42.68	42.58	42.655	1280845.0
2015-02-09 12:30:00	MSFT	Stock	42.67	42.69	42.58	42.605	1073698.0
2015-02-09 13:00:00	MSFT	Stock	42.605	42.64	42.49	42.5	1473105.0
2015-02-09 13:30:00	MSFT	Stock	42.492	42.5	42.41	42.43	1571666.0
2015-02-09 14:00:00	MSFT	Stock	42.43	42.45	42.37	42.45	1354444.0
2015-02-09 14:30:00	MSFT	Stock	42.446	42.48	42.38	42.4	1087456.0
2015-02-09 15:00:00	MSFT	Stock	42.39	42.5	42.33	42.48	1967383.0
2015-02-09 15:30:00	MSFT	Stock	42.48	42.54	42.34	42.35	3448378.0
2015-02-09 16:00:00	MSFT	Stock	42.36	42.459	42.34	42.36	1858415.0

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

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