PREVIEW / stock_30min / 2014-07-24

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-24.parquet
  size:    1.6 MB
  rows:    82,143
  symbols: 3,557

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-07-24 04:00:00	AAPL	Stock	24.3275	24.3725	24.325	24.3425	12080.0
2014-07-24 04:30:00	AAPL	Stock	24.3425	24.3425	24.3125	24.32	28700.0
2014-07-24 05:00:00	AAPL	Stock	24.3225	24.325	24.3	24.325	10296.0
2014-07-24 05:30:00	AAPL	Stock	24.3125	24.3125	24.3125	24.3125	1200.0
2014-07-24 06:00:00	AAPL	Stock	24.325	24.3625	24.325	24.3625	51188.0
2014-07-24 06:30:00	AAPL	Stock	24.345	24.3525	24.3325	24.35	49232.0
2014-07-24 07:00:00	AAPL	Stock	24.325	24.345	24.245	24.2875	213976.0
2014-07-24 07:30:00	AAPL	Stock	24.2875	24.35	24.285	24.3	364896.0
2014-07-24 08:00:00	AAPL	Stock	24.3	24.3475	24.25	24.3125	359772.0
2014-07-24 08:30:00	AAPL	Stock	24.3125	24.3125	24.16	24.2175	582388.0
2014-07-24 09:00:00	AAPL	Stock	24.2125	24.275	24.185	24.2575	685488.0
2014-07-24 09:30:00	AAPL	Stock	24.2575	24.33	24.145	24.195	28938048.0
2014-07-24 10:00:00	AAPL	Stock	24.1975	24.21	24.105	24.1928	17615896.0
2014-07-24 10:30:00	AAPL	Stock	24.195	24.195	24.1125	24.1425	8303564.0
2014-07-24 11:00:00	AAPL	Stock	24.145	24.232	24.145	24.2225	10958052.0
2014-07-24 11:30:00	AAPL	Stock	24.2238	24.27	24.2175	24.2475	9450168.0
2014-07-24 12:00:00	AAPL	Stock	24.2475	24.325	24.245	24.2582	9645388.0
2014-07-24 12:30:00	AAPL	Stock	24.2575	24.2588	24.1925	24.2175	5900804.0
2014-07-24 13:00:00	AAPL	Stock	24.2175	24.225	24.1525	24.1925	7289252.0
2014-07-24 13:30:00	AAPL	Stock	24.1925	24.235	24.17	24.205	5817576.0
2014-07-24 14:00:00	AAPL	Stock	24.205	24.25	24.2025	24.235	5598272.0
2014-07-24 14:30:00	AAPL	Stock	24.2338	24.2438	24.195	24.2125	7392456.0
2014-07-24 15:00:00	AAPL	Stock	24.215	24.265	24.2082	24.2252	9147016.0
2014-07-24 15:30:00	AAPL	Stock	24.2275	24.2625	24.225	24.255	15387940.0
2014-07-24 16:00:00	AAPL	Stock	24.2575	24.3258	24.2232	24.2375	19054344.0
2014-07-24 16:30:00	AAPL	Stock	24.2325	24.2575	24.2	24.2125	84332.0
2014-07-24 17:00:00	AAPL	Stock	24.2362	24.2575	24.125	24.125	743496.0
2014-07-24 17:30:00	AAPL	Stock	24.1425	24.2975	24.1425	24.1875	50248.0
2014-07-24 18:00:00	AAPL	Stock	24.1875	24.2175	24.185	24.2075	60948.0
2014-07-24 18:30:00	AAPL	Stock	24.2575	24.2575	24.2	24.205	164640.0
2014-07-24 19:00:00	AAPL	Stock	24.215	24.22	24.1875	24.2	48644.0
2014-07-24 19:30:00	AAPL	Stock	24.2	24.2	24.1875	24.1875	43976.0
2014-07-24 05:00:00	MSFT	Stock	44.99	44.99	44.99	44.99	100.0
2014-07-24 07:00:00	MSFT	Stock	45.04	45.04	45.04	45.04	100.0
2014-07-24 08:00:00	MSFT	Stock	44.87	45.06	44.84	44.84	2738.0
2014-07-24 08:30:00	MSFT	Stock	44.8	45.0	44.8	44.89	8162.0
2014-07-24 09:00:00	MSFT	Stock	44.86	44.98	44.82	44.92	26317.0
2014-07-24 09:30:00	MSFT	Stock	44.93	45.0	44.59	44.6	3586259.0
2014-07-24 10:00:00	MSFT	Stock	44.6	44.63	44.48	44.56	2473178.0
2014-07-24 10:30:00	MSFT	Stock	44.555	44.7	44.5	44.675	2066319.0
2014-07-24 11:00:00	MSFT	Stock	44.67	44.72	44.66	44.665	1654045.0
2014-07-24 11:30:00	MSFT	Stock	44.665	44.72	44.65	44.655	1372798.0
2014-07-24 12:00:00	MSFT	Stock	44.65	44.68	44.53	44.54	1519328.0
2014-07-24 12:30:00	MSFT	Stock	44.535	44.55	44.375	44.38	1554473.0
2014-07-24 13:00:00	MSFT	Stock	44.38	44.5	44.32	44.5	1767889.0
2014-07-24 13:30:00	MSFT	Stock	44.5	44.52	44.43	44.52	1445129.0
2014-07-24 14:00:00	MSFT	Stock	44.515	44.52	44.46	44.465	1070556.0
2014-07-24 14:30:00	MSFT	Stock	44.47	44.5	44.41	44.455	1242065.0
2014-07-24 15:00:00	MSFT	Stock	44.46	44.51	44.44	44.505	1710453.0
2014-07-24 15:30:00	MSFT	Stock	44.51	44.51	44.38	44.38	5250694.0

> showing 50 of 82,143 rows — these rows as CSV

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