PREVIEW / stock_30min / 2014-08-20

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-20.parquet
  size:    1.6 MB
  rows:    80,963
  symbols: 3,569

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-08-20 04:00:00	AAPL	Stock	25.1075	25.235	25.1075	25.23	43096.0
2014-08-20 04:30:00	AAPL	Stock	25.2	25.245	25.2	25.2	41592.0
2014-08-20 05:00:00	AAPL	Stock	25.2025	25.245	25.2	25.225	54208.0
2014-08-20 05:30:00	AAPL	Stock	25.23	25.2375	25.205	25.21	16780.0
2014-08-20 06:00:00	AAPL	Stock	25.215	25.2225	25.1975	25.2	39084.0
2014-08-20 06:30:00	AAPL	Stock	25.2175	25.2375	25.2025	25.2175	74076.0
2014-08-20 07:00:00	AAPL	Stock	25.2075	25.2075	25.16	25.1625	171184.0
2014-08-20 07:30:00	AAPL	Stock	25.175	25.18	25.1575	25.1775	151584.0
2014-08-20 08:00:00	AAPL	Stock	25.1875	25.22	25.1	25.1	542080.0
2014-08-20 08:30:00	AAPL	Stock	25.1	25.11	25.0625	25.085	574092.0
2014-08-20 09:00:00	AAPL	Stock	25.08	25.1275	25.0775	25.12	490812.0
2014-08-20 09:30:00	AAPL	Stock	25.1125	25.1925	25.0625	25.11	32592396.0
2014-08-20 10:00:00	AAPL	Stock	25.1125	25.1175	25.015	25.015	19701304.0
2014-08-20 10:30:00	AAPL	Stock	25.0175	25.1075	24.9875	25.1	18039124.0
2014-08-20 11:00:00	AAPL	Stock	25.0988	25.1375	25.08	25.135	10777924.0
2014-08-20 11:30:00	AAPL	Stock	25.135	25.2175	25.135	25.1975	15868244.0
2014-08-20 12:00:00	AAPL	Stock	25.1975	25.22	25.1525	25.159	9600364.0
2014-08-20 12:30:00	AAPL	Stock	25.16	25.2225	25.1475	25.22	7223588.0
2014-08-20 13:00:00	AAPL	Stock	25.2175	25.2725	25.2175	25.245	11166348.0
2014-08-20 13:30:00	AAPL	Stock	25.245	25.2575	25.1905	25.2275	8416440.0
2014-08-20 14:00:00	AAPL	Stock	25.23	25.235	25.17	25.2175	12373132.0
2014-08-20 14:30:00	AAPL	Stock	25.2175	25.2275	25.2	25.215	8886332.0
2014-08-20 15:00:00	AAPL	Stock	25.2175	25.235	25.19	25.215	9533320.0
2014-08-20 15:30:00	AAPL	Stock	25.2138	25.2475	25.1375	25.1425	22390888.0
2014-08-20 16:00:00	AAPL	Stock	25.1425	25.215	25.0758	25.09	10081652.0
2014-08-20 16:30:00	AAPL	Stock	25.095	25.1455	25.085	25.0975	199448.0
2014-08-20 17:00:00	AAPL	Stock	25.1	25.211	25.095	25.1075	213784.0
2014-08-20 17:30:00	AAPL	Stock	25.1075	25.1125	25.1	25.1	74648.0
2014-08-20 18:00:00	AAPL	Stock	25.1025	25.105	25.095	25.1	97432.0
2014-08-20 18:30:00	AAPL	Stock	25.095	25.1	25.0925	25.1	37912.0
2014-08-20 19:00:00	AAPL	Stock	25.0975	25.0975	25.085	25.085	65968.0
2014-08-20 19:30:00	AAPL	Stock	25.09	25.1425	25.0875	25.12	213972.0
2014-08-20 06:30:00	MSFT	Stock	45.37	45.37	45.37	45.37	300.0
2014-08-20 07:30:00	MSFT	Stock	45.37	45.4	45.3	45.3	5900.0
2014-08-20 08:00:00	MSFT	Stock	45.4	45.4	45.35	45.35	1680.0
2014-08-20 08:30:00	MSFT	Stock	45.31	45.34	45.23	45.23	4897.0
2014-08-20 09:00:00	MSFT	Stock	45.3	45.34	45.29	45.34	4836.0
2014-08-20 09:30:00	MSFT	Stock	45.34	45.4	45.08	45.115	2822144.0
2014-08-20 10:00:00	MSFT	Stock	45.12	45.17	45.03	45.09	1751190.0
2014-08-20 10:30:00	MSFT	Stock	45.091	45.15	45.02	45.15	1562851.0
2014-08-20 11:00:00	MSFT	Stock	45.145	45.17	45.015	45.043	1268884.0
2014-08-20 11:30:00	MSFT	Stock	45.05	45.25	45.03	45.11	1636880.0
2014-08-20 12:00:00	MSFT	Stock	45.11	45.115	45.05	45.05	630289.0
2014-08-20 12:30:00	MSFT	Stock	45.05	45.15	45.03	45.07	743658.0
2014-08-20 13:00:00	MSFT	Stock	45.075	45.08	44.97	44.99	1447652.0
2014-08-20 13:30:00	MSFT	Stock	45.0	45.02	44.95	45.0	1645464.0
2014-08-20 14:00:00	MSFT	Stock	44.995	45.005	44.9	44.95	2080236.0
2014-08-20 14:30:00	MSFT	Stock	44.95	45.04	44.95	45.001	1617524.0
2014-08-20 15:00:00	MSFT	Stock	45.005	45.015	44.94	44.97	1591186.0
2014-08-20 15:30:00	MSFT	Stock	44.97	45.0	44.91	44.94	2604277.0

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

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