PREVIEW / stock_30min / 2014-12-04

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-12-04.parquet
  size:    1.6 MB
  rows:    84,044
  symbols: 3,536

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-12-04 04:00:00	AAPL	Stock	29.0375	29.0475	29.0375	29.0475	4400.0
2014-12-04 04:30:00	AAPL	Stock	29.0375	29.075	29.02	29.075	1600.0
2014-12-04 05:00:00	AAPL	Stock	29.085	29.1225	29.075	29.1225	4480.0
2014-12-04 05:30:00	AAPL	Stock	29.11	29.1175	29.0875	29.1025	16944.0
2014-12-04 06:00:00	AAPL	Stock	29.1	29.1025	29.1	29.1	7660.0
2014-12-04 06:30:00	AAPL	Stock	29.1025	29.1025	29.04	29.0425	40024.0
2014-12-04 07:00:00	AAPL	Stock	29.0625	29.075	29.0525	29.0625	60328.0
2014-12-04 07:30:00	AAPL	Stock	29.07	29.075	29.025	29.025	75228.0
2014-12-04 08:00:00	AAPL	Stock	29.0362	29.1	28.9875	29.015	323848.0
2014-12-04 08:30:00	AAPL	Stock	29.0175	29.05	28.89	28.9125	499816.0
2014-12-04 09:00:00	AAPL	Stock	28.9202	28.9825	28.9175	28.9425	338312.0
2014-12-04 09:30:00	AAPL	Stock	28.9375	29.19	28.9025	29.17	20384396.0
2014-12-04 10:00:00	AAPL	Stock	29.1725	29.3	29.15	29.2225	19680064.0
2014-12-04 10:30:00	AAPL	Stock	29.225	29.225	29.0875	29.1485	13624116.0
2014-12-04 11:00:00	AAPL	Stock	29.1488	29.15	28.995	29.0025	11094588.0
2014-12-04 11:30:00	AAPL	Stock	29.0025	29.1	28.975	29.075	9137956.0
2014-12-04 12:00:00	AAPL	Stock	29.0748	29.1325	29.0625	29.1075	5667812.0
2014-12-04 12:30:00	AAPL	Stock	29.11	29.145	28.9432	29.0275	12417040.0
2014-12-04 13:00:00	AAPL	Stock	29.0275	29.0625	29.005	29.04	4377192.0
2014-12-04 13:30:00	AAPL	Stock	29.04	29.0425	28.9775	29.0025	4505536.0
2014-12-04 14:00:00	AAPL	Stock	29.0025	29.0075	28.955	28.995	4614996.0
2014-12-04 14:30:00	AAPL	Stock	28.9975	28.9975	28.9188	28.955	5655376.0
2014-12-04 15:00:00	AAPL	Stock	28.955	28.97	28.8875	28.901	7439928.0
2014-12-04 15:30:00	AAPL	Stock	28.9025	28.9025	28.8225	28.8725	16958468.0
2014-12-04 16:00:00	AAPL	Stock	28.8725	29.1302	28.8125	28.845	20635420.0
2014-12-04 16:30:00	AAPL	Stock	28.8522	29.0618	28.8425	28.8522	34832.0
2014-12-04 17:00:00	AAPL	Stock	28.845	28.8725	28.815	28.845	54232.0
2014-12-04 17:30:00	AAPL	Stock	28.8525	28.86	28.8425	28.86	28860.0
2014-12-04 18:00:00	AAPL	Stock	28.86	28.8725	28.855	28.865	57556.0
2014-12-04 18:30:00	AAPL	Stock	28.865	28.9	28.8625	28.885	101680.0
2014-12-04 19:00:00	AAPL	Stock	28.8775	28.88	28.865	28.865	26612.0
2014-12-04 19:30:00	AAPL	Stock	28.87	28.8725	28.855	28.8575	29152.0
2014-12-04 07:30:00	MSFT	Stock	48.16	48.16	48.16	48.16	500.0
2014-12-04 08:00:00	MSFT	Stock	48.08	48.16	48.08	48.101	12000.0
2014-12-04 08:30:00	MSFT	Stock	48.16	48.25	48.05	48.05	19376.0
2014-12-04 09:00:00	MSFT	Stock	48.07	48.23	48.02	48.2	21033.0
2014-12-04 09:30:00	MSFT	Stock	48.2	48.92	48.2	48.69	3884876.0
2014-12-04 10:00:00	MSFT	Stock	48.7	48.8	48.54	48.69	1906818.0
2014-12-04 10:30:00	MSFT	Stock	48.7	48.79	48.61	48.775	2203516.0
2014-12-04 11:00:00	MSFT	Stock	48.77	48.91	48.66	48.7	1731792.0
2014-12-04 11:30:00	MSFT	Stock	48.7	48.82	48.63	48.82	1237764.0
2014-12-04 12:00:00	MSFT	Stock	48.825	48.95	48.82	48.915	1388871.0
2014-12-04 12:30:00	MSFT	Stock	48.91	49.06	48.893	48.94	1568711.0
2014-12-04 13:00:00	MSFT	Stock	48.94	49.0	48.88	48.99	1388700.0
2014-12-04 13:30:00	MSFT	Stock	48.985	49.02	48.935	48.97	1219533.0
2014-12-04 14:00:00	MSFT	Stock	48.97	49.01	48.95	48.96	978260.0
2014-12-04 14:30:00	MSFT	Stock	48.955	49.02	48.91	49.02	2388361.0
2014-12-04 15:00:00	MSFT	Stock	49.02	49.05	48.88	48.91	2470324.0
2014-12-04 15:30:00	MSFT	Stock	48.9	48.94	48.8	48.85	3925119.0
2014-12-04 16:00:00	MSFT	Stock	48.84	48.842	48.79	48.84	3061612.0

> showing 50 of 84,044 rows — these rows as CSV

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