PREVIEW / stock_30min / 2014-01-27

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-27.parquet
  size:    1.6 MB
  rows:    83,289
  symbols: 3,542

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-01-27 04:00:00	AAPL	Stock	19.6061	19.6068	19.5989	19.6068	44436.0
2014-01-27 04:30:00	AAPL	Stock	19.6054	19.6404	19.6054	19.6336	45808.0
2014-01-27 05:00:00	AAPL	Stock	19.6361	19.6425	19.6254	19.6393	96180.0
2014-01-27 05:30:00	AAPL	Stock	19.62	19.62	19.6143	19.6189	50400.0
2014-01-27 06:00:00	AAPL	Stock	19.625	19.6418	19.6054	19.6246	66920.0
2014-01-27 06:30:00	AAPL	Stock	19.6393	19.7032	19.625	19.7032	132776.0
2014-01-27 07:00:00	AAPL	Stock	19.6964	19.7411	19.6696	19.7304	745332.0
2014-01-27 07:30:00	AAPL	Stock	19.7282	19.7304	19.6829	19.6829	540288.0
2014-01-27 08:00:00	AAPL	Stock	19.6857	19.7321	19.6418	19.6418	1817368.0
2014-01-27 08:30:00	AAPL	Stock	19.645	19.675	19.6325	19.6525	569576.0
2014-01-27 09:00:00	AAPL	Stock	19.6525	19.6646	19.6314	19.6607	876708.0
2014-01-27 09:30:00	AAPL	Stock	19.6454	19.8143	19.6454	19.7407	55605116.0
2014-01-27 10:00:00	AAPL	Stock	19.7411	19.7946	19.6914	19.7024	36661296.0
2014-01-27 10:30:00	AAPL	Stock	19.7036	19.7643	19.6661	19.7329	27777120.0
2014-01-27 11:00:00	AAPL	Stock	19.7289	19.7325	19.6214	19.6607	25138596.0
2014-01-27 11:30:00	AAPL	Stock	19.6582	19.6789	19.5861	19.5964	18084556.0
2014-01-27 12:00:00	AAPL	Stock	19.6011	19.6071	19.4911	19.58	23562840.0
2014-01-27 12:30:00	AAPL	Stock	19.5927	19.6607	19.52	19.5989	16800672.0
2014-01-27 13:00:00	AAPL	Stock	19.5979	19.6607	19.5796	19.6421	12678484.0
2014-01-27 13:30:00	AAPL	Stock	19.6398	19.7286	19.625	19.7207	14509236.0
2014-01-27 14:00:00	AAPL	Stock	19.7235	19.7564	19.7054	19.7304	16569196.0
2014-01-27 14:30:00	AAPL	Stock	19.7279	19.8125	19.7197	19.8018	20049596.0
2014-01-27 15:00:00	AAPL	Stock	19.8023	19.8027	19.7382	19.7525	18072040.0
2014-01-27 15:30:00	AAPL	Stock	19.7475	19.7696	19.6618	19.6625	39742416.0
2014-01-27 16:00:00	AAPL	Stock	19.6607	19.7454	19.6071	19.7036	23568132.0
2014-01-27 16:30:00	AAPL	Stock	19.7307	20.0714	18.3929	18.5089	56314972.0
2014-01-27 17:00:00	AAPL	Stock	18.5007	18.5275	17.9679	18.0839	39500748.0
2014-01-27 17:30:00	AAPL	Stock	18.1039	18.1371	17.8757	18.0568	15460172.0
2014-01-27 18:00:00	AAPL	Stock	18.0661	18.1854	18.0361	18.1854	4262104.0
2014-01-27 18:30:00	AAPL	Stock	18.1793	19.6607	18.1039	18.1071	1650348.0
2014-01-27 19:00:00	AAPL	Stock	18.1139	18.1139	18.0607	18.0718	1341256.0
2014-01-27 19:30:00	AAPL	Stock	18.0714	18.1229	18.0361	18.0714	1423772.0
2014-01-27 04:30:00	MSFT	Stock	37.2	37.21	37.2	37.21	900.0
2014-01-27 06:00:00	MSFT	Stock	37.18	37.18	37.18	37.18	100.0
2014-01-27 06:30:00	MSFT	Stock	37.07	37.07	37.07	37.07	108.0
2014-01-27 07:00:00	MSFT	Stock	37.01	37.06	37.01	37.06	800.0
2014-01-27 07:30:00	MSFT	Stock	36.95	36.95	36.91	36.91	1615.0
2014-01-27 08:00:00	MSFT	Stock	37.0	37.05	36.8	36.9	29587.0
2014-01-27 08:30:00	MSFT	Stock	36.86	37.0	36.83	37.0	15189.0
2014-01-27 09:00:00	MSFT	Stock	36.99	36.99	36.78	36.81	33050.0
2014-01-27 09:30:00	MSFT	Stock	36.83	36.89	36.435	36.46	4259689.0
2014-01-27 10:00:00	MSFT	Stock	36.46	36.5	36.26	36.36	3567919.0
2014-01-27 10:30:00	MSFT	Stock	36.36	36.495	36.21	36.25	3337729.0
2014-01-27 11:00:00	MSFT	Stock	36.25	36.42	36.21	36.32	2202726.0
2014-01-27 11:30:00	MSFT	Stock	36.32	36.33	36.16	36.181	1477582.0
2014-01-27 12:00:00	MSFT	Stock	36.18	36.18	36.0	36.08	2878639.0
2014-01-27 12:30:00	MSFT	Stock	36.075	36.25	35.98	36.17	2649240.0
2014-01-27 13:00:00	MSFT	Stock	36.17	36.29	36.11	36.17	1751190.0
2014-01-27 13:30:00	MSFT	Stock	36.163	36.39	36.1	36.34	3423285.0
2014-01-27 14:00:00	MSFT	Stock	36.35	36.4	36.23	36.27	1823097.0

> showing 50 of 83,289 rows — these rows as CSV

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