PREVIEW / stock_5min / 2011-06-27

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-06-27.parquet
  size:    4.9 MB
  rows:    338,678
  symbols: 3,551

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
2011-06-27 04:45:00	AAPL	Stock	11.6789	11.6789	11.6789	11.6789	8400.0
2011-06-27 05:00:00	AAPL	Stock	11.7046	11.7046	11.7046	11.7046	2800.0
2011-06-27 05:05:00	AAPL	Stock	11.6839	11.6839	11.6839	11.6839	2800.0
2011-06-27 06:20:00	AAPL	Stock	11.7104	11.7146	11.7104	11.7146	25200.0
2011-06-27 06:55:00	AAPL	Stock	11.7232	11.7232	11.7143	11.7143	11200.0
2011-06-27 07:00:00	AAPL	Stock	11.7082	11.7082	11.7082	11.7082	2800.0
2011-06-27 07:05:00	AAPL	Stock	11.7214	11.7214	11.7214	11.7214	12600.0
2011-06-27 07:10:00	AAPL	Stock	11.7143	11.7232	11.7139	11.7143	50400.0
2011-06-27 07:15:00	AAPL	Stock	11.7214	11.7286	11.7214	11.7286	30520.0
2011-06-27 07:20:00	AAPL	Stock	11.7311	11.7511	11.7311	11.7511	138880.0
2011-06-27 07:25:00	AAPL	Stock	11.75	11.75	11.7396	11.7425	51100.0
2011-06-27 07:30:00	AAPL	Stock	11.7496	11.7661	11.7464	11.7554	231000.0
2011-06-27 07:35:00	AAPL	Stock	11.7511	11.7561	11.7511	11.7554	36400.0
2011-06-27 07:40:00	AAPL	Stock	11.7454	11.75	11.7454	11.75	5600.0
2011-06-27 07:45:00	AAPL	Stock	11.7504	11.7504	11.75	11.7504	16800.0
2011-06-27 07:50:00	AAPL	Stock	11.7536	11.7607	11.7468	11.7471	60060.0
2011-06-27 07:55:00	AAPL	Stock	11.7475	11.75	11.7414	11.7446	64260.0
2011-06-27 08:00:00	AAPL	Stock	11.7457	11.7457	11.7261	11.7318	328720.0
2011-06-27 08:05:00	AAPL	Stock	11.7321	11.7339	11.7254	11.7321	89320.0
2011-06-27 08:10:00	AAPL	Stock	11.7286	11.7286	11.7286	11.7286	4200.0
2011-06-27 08:15:00	AAPL	Stock	11.7279	11.7329	11.7279	11.7329	39200.0
2011-06-27 08:20:00	AAPL	Stock	11.7321	11.7321	11.7321	11.7321	5600.0
2011-06-27 08:25:00	AAPL	Stock	11.7354	11.7354	11.7289	11.7289	30800.0
2011-06-27 08:30:00	AAPL	Stock	11.7286	11.7321	11.7236	11.7236	57736.0
2011-06-27 08:35:00	AAPL	Stock	11.7239	11.7321	11.7143	11.715	143500.0
2011-06-27 08:40:00	AAPL	Stock	11.7179	11.7236	11.7143	11.7236	106428.0
2011-06-27 08:45:00	AAPL	Stock	11.725	11.75	11.725	11.7464	355740.0
2011-06-27 08:50:00	AAPL	Stock	11.7475	11.7475	11.7389	11.7429	96600.0
2011-06-27 08:55:00	AAPL	Stock	11.7407	11.7429	11.7343	11.7343	39088.0
2011-06-27 09:00:00	AAPL	Stock	11.7339	11.7346	11.7186	11.7204	194012.0
2011-06-27 09:05:00	AAPL	Stock	11.72	11.725	11.7146	11.7196	92316.0
2011-06-27 09:10:00	AAPL	Stock	11.7196	11.7236	11.7143	11.7164	390208.0
2011-06-27 09:15:00	AAPL	Stock	11.7161	11.7193	11.7143	11.7179	98392.0
2011-06-27 09:20:00	AAPL	Stock	11.715	11.7161	11.7043	11.7132	242116.0
2011-06-27 09:25:00	AAPL	Stock	11.7129	11.7139	11.6864	11.7021	405328.0
2011-06-27 09:30:00	AAPL	Stock	11.7011	11.7539	11.6875	11.7282	12707128.0
2011-06-27 09:35:00	AAPL	Stock	11.7282	11.7318	11.6907	11.7214	8979404.0
2011-06-27 09:40:00	AAPL	Stock	11.7214	11.7675	11.715	11.7625	10143840.0
2011-06-27 09:45:00	AAPL	Stock	11.7651	11.7736	11.7525	11.7728	6666940.0
2011-06-27 09:50:00	AAPL	Stock	11.7734	11.7929	11.7564	11.7769	8303848.0
2011-06-27 09:55:00	AAPL	Stock	11.7779	11.7975	11.77	11.7739	5580428.0
2011-06-27 10:00:00	AAPL	Stock	11.7771	11.7911	11.7643	11.7846	4557000.0
2011-06-27 10:05:00	AAPL	Stock	11.7832	11.785	11.7639	11.7639	4289460.0
2011-06-27 10:10:00	AAPL	Stock	11.7641	11.7764	11.7589	11.7764	3585820.0
2011-06-27 10:15:00	AAPL	Stock	11.7764	11.7896	11.7714	11.7896	5626292.0
2011-06-27 10:20:00	AAPL	Stock	11.7889	11.8193	11.7821	11.8167	7207592.0
2011-06-27 10:25:00	AAPL	Stock	11.8166	11.84	11.8064	11.84	6953996.0
2011-06-27 10:30:00	AAPL	Stock	11.8411	11.8529	11.8179	11.825	6192396.0
2011-06-27 10:35:00	AAPL	Stock	11.8264	11.8375	11.8175	11.8236	3758132.0
2011-06-27 10:40:00	AAPL	Stock	11.8239	11.8296	11.8107	11.8274	4044628.0

> showing 50 of 338,678 rows — these rows as CSV

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