PREVIEW / stock_30min / 2014-05-22

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-22.parquet
  size:    1.5 MB
  rows:    80,833
  symbols: 3,543

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-05-22 04:00:00	AAPL	Stock	21.6746	21.7011	21.6746	21.7011	14000.0
2014-05-22 06:00:00	AAPL	Stock	21.6786	21.6786	21.6786	21.6786	2800.0
2014-05-22 06:30:00	AAPL	Stock	21.6893	21.6893	21.6893	21.6893	14000.0
2014-05-22 07:00:00	AAPL	Stock	21.6821	21.6821	21.6818	21.6821	24584.0
2014-05-22 07:30:00	AAPL	Stock	21.6821	21.6889	21.675	21.6829	33600.0
2014-05-22 08:00:00	AAPL	Stock	21.6732	21.6882	21.6571	21.6696	303744.0
2014-05-22 08:30:00	AAPL	Stock	21.6682	21.6761	21.6607	21.6718	117236.0
2014-05-22 09:00:00	AAPL	Stock	21.6743	21.6964	21.6625	21.6625	1043448.0
2014-05-22 09:30:00	AAPL	Stock	21.6643	21.7093	21.6146	21.6484	32819220.0
2014-05-22 10:00:00	AAPL	Stock	21.6546	21.6546	21.575	21.6218	16274076.0
2014-05-22 10:30:00	AAPL	Stock	21.6239	21.6521	21.6043	21.6379	8963948.0
2014-05-22 11:00:00	AAPL	Stock	21.6371	21.6468	21.6125	21.6346	10208016.0
2014-05-22 11:30:00	AAPL	Stock	21.6346	21.6764	21.63	21.6314	6408024.0
2014-05-22 12:00:00	AAPL	Stock	21.6389	21.6454	21.6168	21.6232	3431400.0
2014-05-22 12:30:00	AAPL	Stock	21.6261	21.6511	21.6143	21.6375	3627988.0
2014-05-22 13:00:00	AAPL	Stock	21.6386	21.6568	21.6336	21.6546	4037964.0
2014-05-22 13:30:00	AAPL	Stock	21.6543	21.7086	21.6507	21.7018	13023668.0
2014-05-22 14:00:00	AAPL	Stock	21.7018	21.7804	21.7018	21.7596	16203208.0
2014-05-22 14:30:00	AAPL	Stock	21.7589	21.7764	21.7154	21.7393	9203208.0
2014-05-22 15:00:00	AAPL	Stock	21.7414	21.7579	21.7107	21.735	9314424.0
2014-05-22 15:30:00	AAPL	Stock	21.7364	21.7504	21.6429	21.6904	19436816.0
2014-05-22 16:00:00	AAPL	Stock	21.6893	21.7179	21.6427	21.6671	7494508.0
2014-05-22 16:30:00	AAPL	Stock	21.6661	21.6668	21.6518	21.6518	50484.0
2014-05-22 17:00:00	AAPL	Stock	21.6611	21.6611	21.6611	21.6611	28000.0
2014-05-22 17:30:00	AAPL	Stock	21.6704	21.6893	21.6704	21.6893	54180.0
2014-05-22 18:00:00	AAPL	Stock	21.6689	21.6693	21.6646	21.6693	72800.0
2014-05-22 18:30:00	AAPL	Stock	21.6693	21.6693	21.6686	21.6686	6608.0
2014-05-22 19:00:00	AAPL	Stock	21.6643	21.6696	21.6607	21.6696	14560.0
2014-05-22 19:30:00	AAPL	Stock	21.6696	21.6696	21.6589	21.6607	69804.0
2014-05-22 08:30:00	MSFT	Stock	40.27	40.27	40.27	40.27	963.0
2014-05-22 09:00:00	MSFT	Stock	40.33	40.34	40.31	40.34	6535.0
2014-05-22 09:30:00	MSFT	Stock	40.29	40.35	40.02	40.03	2847368.0
2014-05-22 10:00:00	MSFT	Stock	40.031	40.06	39.85	39.868	1755496.0
2014-05-22 10:30:00	MSFT	Stock	39.86	39.99	39.85	39.97	1674135.0
2014-05-22 11:00:00	MSFT	Stock	39.97	40.03	39.95	40.02	1319609.0
2014-05-22 11:30:00	MSFT	Stock	40.02	40.065	40.0	40.02	1068326.0
2014-05-22 12:00:00	MSFT	Stock	40.01	40.025	39.98	40.01	865271.0
2014-05-22 12:30:00	MSFT	Stock	40.015	40.045	39.97	39.985	1060449.0
2014-05-22 13:00:00	MSFT	Stock	39.985	40.03	39.98	40.025	794105.0
2014-05-22 13:30:00	MSFT	Stock	40.03	40.16	40.024	40.117	1123469.0
2014-05-22 14:00:00	MSFT	Stock	40.12	40.16	40.11	40.16	554085.0
2014-05-22 14:30:00	MSFT	Stock	40.156	40.215	40.14	40.215	817789.0
2014-05-22 15:00:00	MSFT	Stock	40.21	40.215	40.11	40.14	1292677.0
2014-05-22 15:30:00	MSFT	Stock	40.145	40.16	40.065	40.105	2577902.0
2014-05-22 16:00:00	MSFT	Stock	40.1	40.12	40.008	40.11	1582934.0
2014-05-22 16:30:00	MSFT	Stock	40.038	40.038	40.038	40.038	361.0
2014-05-22 17:00:00	MSFT	Stock	40.12	40.12	40.12	40.12	100.0
2014-05-22 17:30:00	MSFT	Stock	40.12	40.12	40.12	40.12	200.0
2014-05-22 18:00:00	MSFT	Stock	40.14	40.14	40.14	40.14	600.0
2014-05-22 19:00:00	MSFT	Stock	40.15	40.15	40.15	40.15	400.0

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

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