PREVIEW / stock_30min / 2015-03-17

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-17.parquet
  size:    1.6 MB
  rows:    81,895
  symbols: 3,504

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-03-17 04:00:00	AAPL	Stock	31.3125	31.3125	31.175	31.175	14400.0
2015-03-17 04:30:00	AAPL	Stock	31.1875	31.1875	31.17	31.17	2796.0
2015-03-17 05:00:00	AAPL	Stock	31.15	31.16	31.1275	31.1275	6400.0
2015-03-17 05:30:00	AAPL	Stock	31.1175	31.1275	31.1175	31.1275	1200.0
2015-03-17 06:00:00	AAPL	Stock	31.1275	31.23	31.0075	31.0075	54244.0
2015-03-17 06:30:00	AAPL	Stock	31.0625	31.2175	31.05	31.15	40340.0
2015-03-17 07:00:00	AAPL	Stock	31.1675	31.205	31.1525	31.165	96404.0
2015-03-17 07:30:00	AAPL	Stock	31.1625	31.2	31.1375	31.1825	66760.0
2015-03-17 08:00:00	AAPL	Stock	31.1825	31.3175	31.1375	31.3025	508312.0
2015-03-17 08:30:00	AAPL	Stock	31.3	31.375	31.3	31.3675	664604.0
2015-03-17 09:00:00	AAPL	Stock	31.375	31.49	31.36	31.4725	1003160.0
2015-03-17 09:30:00	AAPL	Stock	31.475	31.645	31.4125	31.6085	35319868.0
2015-03-17 10:00:00	AAPL	Stock	31.607	31.735	31.56	31.7325	21402056.0
2015-03-17 10:30:00	AAPL	Stock	31.7325	31.7975	31.7	31.754	18792900.0
2015-03-17 11:00:00	AAPL	Stock	31.755	31.7575	31.545	31.61	16460676.0
2015-03-17 11:30:00	AAPL	Stock	31.6125	31.72	31.5825	31.705	10598004.0
2015-03-17 12:00:00	AAPL	Stock	31.7	31.7125	31.6285	31.6925	7810164.0
2015-03-17 12:30:00	AAPL	Stock	31.6925	31.7625	31.68	31.7548	8628120.0
2015-03-17 13:00:00	AAPL	Stock	31.7502	31.805	31.715	31.8025	8388972.0
2015-03-17 13:30:00	AAPL	Stock	31.8	31.825	31.7575	31.8175	10187580.0
2015-03-17 14:00:00	AAPL	Stock	31.8175	31.83	31.775	31.788	7067236.0
2015-03-17 14:30:00	AAPL	Stock	31.7892	31.795	31.73	31.775	8138180.0
2015-03-17 15:00:00	AAPL	Stock	31.775	31.825	31.765	31.7725	9626676.0
2015-03-17 15:30:00	AAPL	Stock	31.7725	31.8125	31.76	31.7625	15252996.0
2015-03-17 16:00:00	AAPL	Stock	31.76	31.7875	31.6875	31.78	10868064.0
2015-03-17 16:30:00	AAPL	Stock	31.78	31.785	31.76	31.775	67768.0
2015-03-17 17:00:00	AAPL	Stock	31.76	31.79	31.76	31.7755	125692.0
2015-03-17 17:30:00	AAPL	Stock	31.77	31.785	31.76	31.775	290268.0
2015-03-17 18:00:00	AAPL	Stock	31.775	31.775	31.7675	31.7675	105472.0
2015-03-17 18:30:00	AAPL	Stock	31.7675	31.785	31.7675	31.7675	18252.0
2015-03-17 19:00:00	AAPL	Stock	31.7675	31.79	31.765	31.78	46996.0
2015-03-17 19:30:00	AAPL	Stock	31.78	31.8025	31.7775	31.7925	55348.0
2015-03-17 05:00:00	MSFT	Stock	41.4	41.4	41.4	41.4	100.0
2015-03-17 07:00:00	MSFT	Stock	41.27	41.27	41.27	41.27	1300.0
2015-03-17 07:30:00	MSFT	Stock	41.08	41.24	41.08	41.24	370.0
2015-03-17 08:00:00	MSFT	Stock	41.25	41.34	41.25	41.34	1900.0
2015-03-17 08:30:00	MSFT	Stock	41.18	41.32	41.18	41.29	1500.0
2015-03-17 09:00:00	MSFT	Stock	41.38	41.38	41.32	41.38	5250.0
2015-03-17 09:30:00	MSFT	Stock	41.38	41.48	41.3	41.385	3891095.0
2015-03-17 10:00:00	MSFT	Stock	41.38	41.39	41.2	41.215	1965878.0
2015-03-17 10:30:00	MSFT	Stock	41.215	41.32	41.15	41.25	2000459.0
2015-03-17 11:00:00	MSFT	Stock	41.25	41.31	41.19	41.275	2017361.0
2015-03-17 11:30:00	MSFT	Stock	41.275	41.37	41.26	41.37	1912630.0
2015-03-17 12:00:00	MSFT	Stock	41.365	41.45	41.33	41.39	1456978.0
2015-03-17 12:30:00	MSFT	Stock	41.39	41.625	41.33	41.61	1684258.0
2015-03-17 13:00:00	MSFT	Stock	41.62	41.69	41.53	41.56	2022325.0
2015-03-17 13:30:00	MSFT	Stock	41.55	41.67	41.52	41.66	1407168.0
2015-03-17 14:00:00	MSFT	Stock	41.65	41.72	41.645	41.68	1333017.0
2015-03-17 14:30:00	MSFT	Stock	41.68	41.687	41.55	41.609	1606951.0
2015-03-17 15:00:00	MSFT	Stock	41.605	41.74	41.6	41.73	1913211.0

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

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