PREVIEW / stock_30min / 2011-03-08

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-03-08.parquet
  size:    1.4 MB
  rows:    76,702
  symbols: 3,530

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-03-08 04:00:00	AAPL	Stock	12.7318	12.7489	12.7318	12.7489	14000.0
2011-03-08 04:30:00	AAPL	Stock	12.7489	12.7489	12.7489	12.7489	5600.0
2011-03-08 06:30:00	AAPL	Stock	12.7321	12.7321	12.7321	12.7321	2800.0
2011-03-08 07:00:00	AAPL	Stock	12.7321	12.7411	12.6929	12.7393	88340.0
2011-03-08 07:30:00	AAPL	Stock	12.7143	12.7279	12.6971	12.7061	152432.0
2011-03-08 08:00:00	AAPL	Stock	12.6804	12.705	12.6561	12.6682	756616.0
2011-03-08 08:30:00	AAPL	Stock	12.6679	12.6914	12.6557	12.675	257152.0
2011-03-08 09:00:00	AAPL	Stock	12.6743	12.6814	12.6575	12.6771	500248.0
2011-03-08 09:30:00	AAPL	Stock	12.6768	12.7054	12.5804	12.6429	57671208.0
2011-03-08 10:00:00	AAPL	Stock	12.6432	12.7414	12.6329	12.6839	71809780.0
2011-03-08 10:30:00	AAPL	Stock	12.6843	12.7321	12.68	12.7264	28711648.0
2011-03-08 11:00:00	AAPL	Stock	12.7268	12.7589	12.7075	12.7571	28457968.0
2011-03-08 11:30:00	AAPL	Stock	12.7568	12.7632	12.7311	12.7546	21585928.0
2011-03-08 12:00:00	AAPL	Stock	12.7533	12.7643	12.7386	12.7404	15391516.0
2011-03-08 12:30:00	AAPL	Stock	12.7389	12.7554	12.7304	12.7443	12716256.0
2011-03-08 13:00:00	AAPL	Stock	12.745	12.7575	12.7418	12.7521	8369676.0
2011-03-08 13:30:00	AAPL	Stock	12.7525	12.7596	12.74	12.7448	10566584.0
2011-03-08 14:00:00	AAPL	Stock	12.7454	12.7496	12.6936	12.6982	19455016.0
2011-03-08 14:30:00	AAPL	Stock	12.6975	12.7425	12.6814	12.7351	19199012.0
2011-03-08 15:00:00	AAPL	Stock	12.735	12.7429	12.7143	12.7325	15217860.0
2011-03-08 15:30:00	AAPL	Stock	12.7329	12.7346	12.6993	12.7025	29890168.0
2011-03-08 16:00:00	AAPL	Stock	12.7032	12.7107	12.6881	12.7054	10257128.0
2011-03-08 16:30:00	AAPL	Stock	12.705	12.7322	12.6982	12.6989	452368.0
2011-03-08 17:00:00	AAPL	Stock	12.6956	12.7082	12.6956	12.7082	485380.0
2011-03-08 17:30:00	AAPL	Stock	12.7046	12.7071	12.7	12.7029	91700.0
2011-03-08 18:00:00	AAPL	Stock	12.7018	12.7064	12.7	12.7032	149184.0
2011-03-08 18:30:00	AAPL	Stock	12.7036	12.7036	12.7036	12.7036	26152.0
2011-03-08 19:00:00	AAPL	Stock	12.7018	12.7036	12.7018	12.7018	35448.0
2011-03-08 19:30:00	AAPL	Stock	12.7021	12.7057	12.6968	12.7018	182308.0
2011-03-08 04:00:00	MSFT	Stock	25.79	25.79	25.79	25.79	100.0
2011-03-08 04:30:00	MSFT	Stock	25.79	25.79	25.79	25.79	200.0
2011-03-08 05:00:00	MSFT	Stock	25.79	25.79	25.79	25.79	900.0
2011-03-08 06:30:00	MSFT	Stock	25.79	25.79	25.79	25.79	100.0
2011-03-08 07:00:00	MSFT	Stock	25.79	25.8	25.79	25.8	700.0
2011-03-08 07:30:00	MSFT	Stock	25.82	25.82	25.75	25.75	240.0
2011-03-08 08:00:00	MSFT	Stock	25.81	25.81	25.75	25.75	5203.0
2011-03-08 08:30:00	MSFT	Stock	25.75	25.79	25.72	25.78	18256.0
2011-03-08 09:00:00	MSFT	Stock	25.78	25.81	25.77	25.79	23076.0
2011-03-08 09:30:00	MSFT	Stock	25.78	25.8	25.65	25.715	4634609.0
2011-03-08 10:00:00	MSFT	Stock	25.72	25.94	25.71	25.88	4528056.0
2011-03-08 10:30:00	MSFT	Stock	25.88	25.89	25.78	25.838	3278507.0
2011-03-08 11:00:00	MSFT	Stock	25.83	25.89	25.782	25.89	3164732.0
2011-03-08 11:30:00	MSFT	Stock	25.89	25.91	25.84	25.9	3268812.0
2011-03-08 12:00:00	MSFT	Stock	25.9	25.92	25.86	25.885	2719633.0
2011-03-08 12:30:00	MSFT	Stock	25.89	25.94	25.86	25.93	1954310.0
2011-03-08 13:00:00	MSFT	Stock	25.92	25.93	25.88	25.91	2007776.0
2011-03-08 13:30:00	MSFT	Stock	25.92	25.94	25.84	25.93	2427399.0
2011-03-08 14:00:00	MSFT	Stock	25.93	25.95	25.84	25.89	3199660.0
2011-03-08 14:30:00	MSFT	Stock	25.885	25.99	25.84	25.95	4933047.0
2011-03-08 15:00:00	MSFT	Stock	25.955	26.02	25.91	25.975	4346662.0

> showing 50 of 76,702 rows — these rows as CSV

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