PREVIEW / stock_30min / 2015-04-10

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-04-10.parquet
  size:    1.6 MB
  rows:    81,131
  symbols: 3,511

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-04-10 04:00:00	AAPL	Stock	31.5625	31.5975	31.4625	31.5	69256.0
2015-04-10 04:30:00	AAPL	Stock	31.5	31.5025	31.2625	31.3775	38408.0
2015-04-10 05:00:00	AAPL	Stock	31.4	31.4	31.3775	31.3775	12120.0
2015-04-10 05:30:00	AAPL	Stock	31.42	31.425	31.3775	31.4	11132.0
2015-04-10 06:00:00	AAPL	Stock	31.4725	31.52	31.4125	31.4325	76140.0
2015-04-10 06:30:00	AAPL	Stock	31.415	31.4375	31.4125	31.4125	24768.0
2015-04-10 07:00:00	AAPL	Stock	31.425	31.5	31.4225	31.495	196648.0
2015-04-10 07:30:00	AAPL	Stock	31.48	31.5375	31.475	31.4775	412876.0
2015-04-10 08:00:00	AAPL	Stock	31.5	31.545	31.425	31.4875	550572.0
2015-04-10 08:30:00	AAPL	Stock	31.4875	31.5225	31.4775	31.4878	451844.0
2015-04-10 09:00:00	AAPL	Stock	31.4875	31.51	31.4375	31.48	757536.0
2015-04-10 09:30:00	AAPL	Stock	31.4875	31.56	31.315	31.5098	27822188.0
2015-04-10 10:00:00	AAPL	Stock	31.51	31.61	31.5	31.5875	17691408.0
2015-04-10 10:30:00	AAPL	Stock	31.59	31.7025	31.5875	31.7	13795872.0
2015-04-10 11:00:00	AAPL	Stock	31.6975	31.7225	31.64	31.69	8268412.0
2015-04-10 11:30:00	AAPL	Stock	31.69	31.7025	31.58	31.5938	7666660.0
2015-04-10 12:00:00	AAPL	Stock	31.595	31.6388	31.5375	31.6332	6744844.0
2015-04-10 12:30:00	AAPL	Stock	31.635	31.6725	31.615	31.655	4483308.0
2015-04-10 13:00:00	AAPL	Stock	31.6575	31.6925	31.64	31.68	4694420.0
2015-04-10 13:30:00	AAPL	Stock	31.68	31.7725	31.67	31.7525	8836688.0
2015-04-10 14:00:00	AAPL	Stock	31.7525	31.7525	31.6862	31.72	7030336.0
2015-04-10 14:30:00	AAPL	Stock	31.7225	31.7975	31.7125	31.7725	9537484.0
2015-04-10 15:00:00	AAPL	Stock	31.7725	31.784	31.7225	31.7625	7698936.0
2015-04-10 15:30:00	AAPL	Stock	31.765	31.8025	31.735	31.775	16277348.0
2015-04-10 16:00:00	AAPL	Stock	31.775	31.795	31.7625	31.775	5322648.0
2015-04-10 16:30:00	AAPL	Stock	31.775	31.7875	31.755	31.755	159600.0
2015-04-10 17:00:00	AAPL	Stock	31.77	31.775	31.7575	31.7725	23092.0
2015-04-10 17:30:00	AAPL	Stock	31.775	31.775	31.755	31.7725	87952.0
2015-04-10 18:00:00	AAPL	Stock	31.7702	31.775	31.765	31.775	20144.0
2015-04-10 18:30:00	AAPL	Stock	31.775	31.775	31.76	31.76	35304.0
2015-04-10 19:00:00	AAPL	Stock	31.765	31.7675	31.7575	31.765	31220.0
2015-04-10 19:30:00	AAPL	Stock	31.7625	31.785	31.76	31.7725	56152.0
2015-04-10 04:00:00	MSFT	Stock	41.43	41.43	41.43	41.43	100.0
2015-04-10 05:00:00	MSFT	Stock	41.44	41.44	41.44	41.44	300.0
2015-04-10 05:30:00	MSFT	Stock	41.47	41.47	41.47	41.47	100.0
2015-04-10 07:00:00	MSFT	Stock	41.54	41.54	41.54	41.54	285.0
2015-04-10 07:30:00	MSFT	Stock	41.6	41.68	41.51	41.51	400.0
2015-04-10 08:00:00	MSFT	Stock	41.56	41.56	41.56	41.56	300.0
2015-04-10 08:30:00	MSFT	Stock	41.54	41.57	41.54	41.57	4152.0
2015-04-10 09:00:00	MSFT	Stock	41.65	41.67	41.6	41.63	23596.0
2015-04-10 09:30:00	MSFT	Stock	41.62	41.84	41.41	41.75	4314091.0
2015-04-10 10:00:00	MSFT	Stock	41.755	41.87	41.72	41.79	2705390.0
2015-04-10 10:30:00	MSFT	Stock	41.8	41.95	41.78	41.86	2553892.0
2015-04-10 11:00:00	MSFT	Stock	41.86	41.89	41.81	41.87	1354422.0
2015-04-10 11:30:00	MSFT	Stock	41.875	41.88	41.81	41.837	1311448.0
2015-04-10 12:00:00	MSFT	Stock	41.833	41.84	41.76	41.79	1226264.0
2015-04-10 12:30:00	MSFT	Stock	41.795	41.8	41.71	41.71	1193043.0
2015-04-10 13:00:00	MSFT	Stock	41.714	41.74	41.63	41.66	1027613.0
2015-04-10 13:30:00	MSFT	Stock	41.66	41.73	41.65	41.715	966996.0
2015-04-10 14:00:00	MSFT	Stock	41.71	41.73	41.64	41.66	1120961.0

> showing 50 of 81,131 rows — these rows as CSV

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