PREVIEW / stock_30min / 2014-06-13

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-06-13.parquet
  size:    1.5 MB
  rows:    80,794
  symbols: 3,529

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-06-13 04:00:00	AAPL	Stock	23.0625	23.0625	22.9	22.905	18060.0
2014-06-13 04:30:00	AAPL	Stock	22.92	22.9375	22.92	22.935	22520.0
2014-06-13 05:00:00	AAPL	Stock	22.92	22.95	22.92	22.9275	25680.0
2014-06-13 05:30:00	AAPL	Stock	22.9025	22.915	22.8	22.81	47016.0
2014-06-13 06:00:00	AAPL	Stock	22.81	22.885	22.8025	22.885	100580.0
2014-06-13 06:30:00	AAPL	Stock	22.8875	22.8875	22.85	22.87	42420.0
2014-06-13 07:00:00	AAPL	Stock	22.87	22.925	22.86	22.92	240580.0
2014-06-13 07:30:00	AAPL	Stock	22.925	22.925	22.8625	22.9075	407228.0
2014-06-13 08:00:00	AAPL	Stock	22.9125	23.0375	22.85	22.975	1168564.0
2014-06-13 08:30:00	AAPL	Stock	22.9925	23.0925	22.9575	23.0825	747996.0
2014-06-13 09:00:00	AAPL	Stock	23.09	23.1575	23.025	23.055	1153368.0
2014-06-13 09:30:00	AAPL	Stock	23.055	23.11	22.9175	22.9365	32323500.0
2014-06-13 10:00:00	AAPL	Stock	22.9362	22.9875	22.82	22.965	26508000.0
2014-06-13 10:30:00	AAPL	Stock	22.97	23.035	22.91	23.03	14676000.0
2014-06-13 11:00:00	AAPL	Stock	23.03	23.0375	22.9375	22.966	8748516.0
2014-06-13 11:30:00	AAPL	Stock	22.9675	22.9775	22.85	22.8775	11858484.0
2014-06-13 12:00:00	AAPL	Stock	22.8775	22.9625	22.87	22.9235	8020788.0
2014-06-13 12:30:00	AAPL	Stock	22.925	22.925	22.865	22.8657	7310700.0
2014-06-13 13:00:00	AAPL	Stock	22.865	22.895	22.8325	22.8375	8100480.0
2014-06-13 13:30:00	AAPL	Stock	22.8375	22.875	22.7875	22.863	11948340.0
2014-06-13 14:00:00	AAPL	Stock	22.8625	22.925	22.8525	22.8725	9191108.0
2014-06-13 14:30:00	AAPL	Stock	22.875	22.875	22.835	22.835	8774600.0
2014-06-13 15:00:00	AAPL	Stock	22.8375	22.875	22.72	22.7318	18169328.0
2014-06-13 15:30:00	AAPL	Stock	22.7325	22.82	22.7275	22.815	24220004.0
2014-06-13 16:00:00	AAPL	Stock	22.815	22.8925	22.75	22.8525	10701792.0
2014-06-13 16:30:00	AAPL	Stock	22.855	22.97	22.8222	22.8575	309628.0
2014-06-13 17:00:00	AAPL	Stock	22.8575	22.8725	22.82	22.86	500644.0
2014-06-13 17:30:00	AAPL	Stock	22.8625	22.875	22.86	22.8725	145600.0
2014-06-13 18:00:00	AAPL	Stock	22.8725	22.88	22.8675	22.88	170848.0
2014-06-13 18:30:00	AAPL	Stock	22.875	22.88	22.87	22.87	51200.0
2014-06-13 19:00:00	AAPL	Stock	22.87	22.875	22.8625	22.875	38448.0
2014-06-13 19:30:00	AAPL	Stock	22.865	22.875	22.865	22.87	30264.0
2014-06-13 04:00:00	MSFT	Stock	40.8	40.8	40.8	40.8	130.0
2014-06-13 05:30:00	MSFT	Stock	40.85	40.89	40.85	40.89	2950.0
2014-06-13 06:30:00	MSFT	Stock	40.89	40.89	40.89	40.89	100.0
2014-06-13 07:00:00	MSFT	Stock	40.75	40.95	40.75	40.95	2280.0
2014-06-13 07:30:00	MSFT	Stock	40.93	41.08	40.93	41.08	8280.0
2014-06-13 08:00:00	MSFT	Stock	41.08	41.09	40.9	41.04	7243.0
2014-06-13 08:30:00	MSFT	Stock	41.05	41.19	40.99	41.18	35410.0
2014-06-13 09:00:00	MSFT	Stock	41.15	41.18	41.03	41.09	33720.0
2014-06-13 09:30:00	MSFT	Stock	41.08	41.19	40.86	41.185	3806072.0
2014-06-13 10:00:00	MSFT	Stock	41.182	41.56	41.07	41.49	4368046.0
2014-06-13 10:30:00	MSFT	Stock	41.49	41.565	41.345	41.39	2197784.0
2014-06-13 11:00:00	MSFT	Stock	41.4	41.44	41.32	41.36	1477988.0
2014-06-13 11:30:00	MSFT	Stock	41.36	41.37	41.11	41.19	1824031.0
2014-06-13 12:00:00	MSFT	Stock	41.19	41.32	41.16	41.315	968376.0
2014-06-13 12:30:00	MSFT	Stock	41.315	41.33	41.24	41.244	549969.0
2014-06-13 13:00:00	MSFT	Stock	41.244	41.31	41.18	41.298	685893.0
2014-06-13 13:30:00	MSFT	Stock	41.3	41.35	41.2	41.35	715877.0
2014-06-13 14:00:00	MSFT	Stock	41.34	41.38	41.29	41.295	784476.0

> showing 50 of 80,794 rows — these rows as CSV

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