PREVIEW / stock_5min / 2011-09-09

all stock 5-min files

  file:    by_date/stock_5min/2011/2011-09-09.parquet
  size:    4.9 MB
  rows:    330,819
  symbols: 3,490

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-09-09 04:45:00	AAPL	Stock	13.6732	13.6732	13.6732	13.6732	4200.0
2011-09-09 05:05:00	AAPL	Stock	13.7046	13.7046	13.7046	13.7046	2800.0
2011-09-09 05:15:00	AAPL	Stock	13.7046	13.7046	13.7046	13.7046	2800.0
2011-09-09 05:45:00	AAPL	Stock	13.7021	13.7054	13.7021	13.7054	30800.0
2011-09-09 05:50:00	AAPL	Stock	13.7054	13.7054	13.7054	13.7054	16800.0
2011-09-09 05:55:00	AAPL	Stock	13.6786	13.6786	13.6786	13.6786	14000.0
2011-09-09 06:05:00	AAPL	Stock	13.7211	13.7211	13.7211	13.7211	2800.0
2011-09-09 06:40:00	AAPL	Stock	13.6818	13.7046	13.6818	13.7046	62160.0
2011-09-09 06:45:00	AAPL	Stock	13.6693	13.6693	13.6679	13.6679	5600.0
2011-09-09 07:00:00	AAPL	Stock	13.6682	13.6789	13.6682	13.6789	8400.0
2011-09-09 07:05:00	AAPL	Stock	13.6704	13.6786	13.6607	13.6611	54068.0
2011-09-09 07:10:00	AAPL	Stock	13.6786	13.6786	13.6704	13.6704	7000.0
2011-09-09 07:20:00	AAPL	Stock	13.7	13.7004	13.7	13.7004	5600.0
2011-09-09 07:25:00	AAPL	Stock	13.6993	13.6993	13.6929	13.6929	86380.0
2011-09-09 07:30:00	AAPL	Stock	13.6825	13.6825	13.6825	13.6825	2800.0
2011-09-09 07:35:00	AAPL	Stock	13.6839	13.6839	13.6732	13.6732	40600.0
2011-09-09 07:40:00	AAPL	Stock	13.6725	13.6839	13.6721	13.6839	56000.0
2011-09-09 07:45:00	AAPL	Stock	13.6839	13.6857	13.6839	13.6857	16800.0
2011-09-09 07:50:00	AAPL	Stock	13.6857	13.6857	13.6786	13.6786	5600.0
2011-09-09 07:55:00	AAPL	Stock	13.6768	13.6893	13.675	13.6893	84000.0
2011-09-09 08:00:00	AAPL	Stock	13.6893	13.7007	13.6875	13.6964	89516.0
2011-09-09 08:05:00	AAPL	Stock	13.7007	13.7571	13.6957	13.7546	675920.0
2011-09-09 08:10:00	AAPL	Stock	13.7539	13.7679	13.7511	13.7518	306068.0
2011-09-09 08:15:00	AAPL	Stock	13.7536	13.7643	13.7504	13.7536	153972.0
2011-09-09 08:20:00	AAPL	Stock	13.7604	13.8032	13.7568	13.7921	511700.0
2011-09-09 08:25:00	AAPL	Stock	13.7879	13.8029	13.7857	13.7975	78848.0
2011-09-09 08:30:00	AAPL	Stock	13.805	13.805	13.7821	13.7821	174972.0
2011-09-09 08:35:00	AAPL	Stock	13.7793	13.7871	13.7768	13.7868	94640.0
2011-09-09 08:40:00	AAPL	Stock	13.7857	13.7911	13.7857	13.7911	22400.0
2011-09-09 08:45:00	AAPL	Stock	13.7871	13.7907	13.7754	13.7857	92484.0
2011-09-09 08:50:00	AAPL	Stock	13.7829	13.7829	13.7721	13.7721	67200.0
2011-09-09 08:55:00	AAPL	Stock	13.7764	13.7764	13.755	13.755	128884.0
2011-09-09 09:00:00	AAPL	Stock	13.7514	13.7536	13.7229	13.7357	573804.0
2011-09-09 09:05:00	AAPL	Stock	13.7375	13.7446	13.7257	13.7321	267428.0
2011-09-09 09:10:00	AAPL	Stock	13.7293	13.7293	13.6846	13.7107	498652.0
2011-09-09 09:15:00	AAPL	Stock	13.7057	13.7286	13.6982	13.7179	351764.0
2011-09-09 09:20:00	AAPL	Stock	13.7146	13.7246	13.7143	13.7246	260820.0
2011-09-09 09:25:00	AAPL	Stock	13.7239	13.7314	13.71	13.7218	499548.0
2011-09-09 09:30:00	AAPL	Stock	13.715	13.7586	13.6654	13.7504	16202480.0
2011-09-09 09:35:00	AAPL	Stock	13.7518	13.7536	13.7082	13.7414	15726900.0
2011-09-09 09:40:00	AAPL	Stock	13.74	13.7539	13.7154	13.7204	12480356.0
2011-09-09 09:45:00	AAPL	Stock	13.7227	13.7339	13.6746	13.7279	12537140.0
2011-09-09 09:50:00	AAPL	Stock	13.7304	13.7307	13.6861	13.7129	9194472.0
2011-09-09 09:55:00	AAPL	Stock	13.7089	13.7425	13.6996	13.7129	8405432.0
2011-09-09 10:00:00	AAPL	Stock	13.715	13.7386	13.7075	13.7311	5159896.0
2011-09-09 10:05:00	AAPL	Stock	13.7336	13.7443	13.7229	13.7336	4477536.0
2011-09-09 10:10:00	AAPL	Stock	13.7293	13.7407	13.7071	13.7143	4884124.0
2011-09-09 10:15:00	AAPL	Stock	13.7139	13.7321	13.7064	13.7289	4946452.0
2011-09-09 10:20:00	AAPL	Stock	13.7289	13.75	13.7193	13.75	5009592.0
2011-09-09 10:25:00	AAPL	Stock	13.7496	13.7768	13.7364	13.7739	12124868.0

> showing 50 of 330,819 rows — these rows as CSV

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