PREVIEW / stock_30min / 2013-07-25

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-07-25.parquet
  size:    1.5 MB
  rows:    79,004
  symbols: 3,495

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
2013-07-25 04:00:00	AAPL	Stock	15.7714	15.7857	15.7714	15.7857	8400.0
2013-07-25 04:30:00	AAPL	Stock	15.7589	15.7589	15.7589	15.7589	2800.0
2013-07-25 05:00:00	AAPL	Stock	15.7493	15.7493	15.7143	15.7143	25704.0
2013-07-25 05:30:00	AAPL	Stock	15.7143	15.7143	15.6786	15.6786	17416.0
2013-07-25 06:00:00	AAPL	Stock	15.6786	15.6786	15.6786	15.6786	16800.0
2013-07-25 06:30:00	AAPL	Stock	15.7036	15.7036	15.7036	15.7036	2800.0
2013-07-25 07:00:00	AAPL	Stock	15.6911	15.7143	15.6893	15.7143	147224.0
2013-07-25 07:30:00	AAPL	Stock	15.7168	15.7314	15.7157	15.7268	238532.0
2013-07-25 08:00:00	AAPL	Stock	15.7214	15.7679	15.6786	15.7239	805896.0
2013-07-25 08:30:00	AAPL	Stock	15.7214	15.7593	15.7214	15.7536	467180.0
2013-07-25 09:00:00	AAPL	Stock	15.7539	15.7575	15.7286	15.7379	885248.0
2013-07-25 09:30:00	AAPL	Stock	15.7396	15.7643	15.5851	15.6414	56726936.0
2013-07-25 10:00:00	AAPL	Stock	15.6429	15.6568	15.5646	15.6018	32504724.0
2013-07-25 10:30:00	AAPL	Stock	15.6019	15.6721	15.5831	15.623	15119748.0
2013-07-25 11:00:00	AAPL	Stock	15.6282	15.6286	15.5864	15.6096	9462684.0
2013-07-25 11:30:00	AAPL	Stock	15.6107	15.6404	15.6071	15.6254	9837912.0
2013-07-25 12:00:00	AAPL	Stock	15.6286	15.6875	15.6179	15.6764	10257268.0
2013-07-25 12:30:00	AAPL	Stock	15.6779	15.7393	15.6729	15.7321	16286704.0
2013-07-25 13:00:00	AAPL	Stock	15.7314	15.7393	15.6819	15.7196	10518900.0
2013-07-25 13:30:00	AAPL	Stock	15.7207	15.7421	15.6743	15.6954	9093392.0
2013-07-25 14:00:00	AAPL	Stock	15.6893	15.705	15.6486	15.6539	7872760.0
2013-07-25 14:30:00	AAPL	Stock	15.6557	15.7	15.6393	15.6586	10321780.0
2013-07-25 15:00:00	AAPL	Stock	15.6568	15.6932	15.6496	15.6746	8776852.0
2013-07-25 15:30:00	AAPL	Stock	15.6746	15.6882	15.6539	15.6607	19012812.0
2013-07-25 16:00:00	AAPL	Stock	15.6639	15.7142	15.6536	15.6714	7667884.0
2013-07-25 16:30:00	AAPL	Stock	15.6679	15.6786	15.6509	15.6607	197652.0
2013-07-25 17:00:00	AAPL	Stock	15.6675	15.6729	15.6475	15.6639	170016.0
2013-07-25 17:30:00	AAPL	Stock	15.65	15.6546	15.6475	15.6529	46200.0
2013-07-25 18:00:00	AAPL	Stock	15.655	15.6643	15.6504	15.6643	37800.0
2013-07-25 18:30:00	AAPL	Stock	15.6625	15.6643	15.6554	15.6589	112812.0
2013-07-25 19:00:00	AAPL	Stock	15.6518	15.6518	15.6518	15.6518	16800.0
2013-07-25 19:30:00	AAPL	Stock	15.6521	15.6525	15.6518	15.6521	28448.0
2013-07-25 04:00:00	MSFT	Stock	31.94	31.94	31.94	31.94	600.0
2013-07-25 05:00:00	MSFT	Stock	31.94	31.94	31.57	31.57	2600.0
2013-07-25 06:00:00	MSFT	Stock	31.75	31.75	31.75	31.75	300.0
2013-07-25 06:30:00	MSFT	Stock	31.62	31.62	31.62	31.62	200.0
2013-07-25 07:00:00	MSFT	Stock	31.69	31.75	31.69	31.75	6248.0
2013-07-25 07:30:00	MSFT	Stock	31.77	31.77	31.77	31.77	100.0
2013-07-25 08:00:00	MSFT	Stock	31.9	31.9	31.7	31.84	11724.0
2013-07-25 08:30:00	MSFT	Stock	31.85	31.91	31.85	31.88	5300.0
2013-07-25 09:00:00	MSFT	Stock	31.86	31.86	31.61	31.61	52522.0
2013-07-25 09:30:00	MSFT	Stock	31.62	31.66	31.42	31.566	8547597.0
2013-07-25 10:00:00	MSFT	Stock	31.56	31.62	31.52	31.57	5105501.0
2013-07-25 10:30:00	MSFT	Stock	31.565	31.57	31.384	31.41	4424620.0
2013-07-25 11:00:00	MSFT	Stock	31.41	31.41	31.25	31.3	6132567.0
2013-07-25 11:30:00	MSFT	Stock	31.31	31.37	31.25	31.34	3939117.0
2013-07-25 12:00:00	MSFT	Stock	31.35	31.35	31.27	31.344	2759653.0
2013-07-25 12:30:00	MSFT	Stock	31.345	31.37	31.3	31.35	3360679.0
2013-07-25 13:00:00	MSFT	Stock	31.35	31.43	31.34	31.42	1907724.0
2013-07-25 13:30:00	MSFT	Stock	31.42	31.43	31.39	31.4	3135928.0

> showing 50 of 79,004 rows — these rows as CSV

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