PREVIEW / stock_30min / 2013-02-14

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-02-14.parquet
  size:    1.4 MB
  rows:    75,249
  symbols: 3,465

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-02-14 05:00:00	AAPL	Stock	16.6518	16.6518	16.6429	16.6429	39200.0
2013-02-14 05:30:00	AAPL	Stock	16.6304	16.6607	16.6304	16.6429	8400.0
2013-02-14 06:00:00	AAPL	Stock	16.6071	16.6071	16.5982	16.6029	49168.0
2013-02-14 06:30:00	AAPL	Stock	16.625	16.625	16.5982	16.5982	97720.0
2013-02-14 07:00:00	AAPL	Stock	16.5982	16.63	16.5946	16.63	132384.0
2013-02-14 07:30:00	AAPL	Stock	16.6214	16.6375	16.6193	16.635	63980.0
2013-02-14 08:00:00	AAPL	Stock	16.6293	16.6521	16.5982	16.6429	350056.0
2013-02-14 08:30:00	AAPL	Stock	16.6457	16.6789	16.6157	16.6175	526652.0
2013-02-14 09:00:00	AAPL	Stock	16.6225	16.6789	16.575	16.5904	22624224.0
2013-02-14 09:30:00	AAPL	Stock	16.5868	16.7421	16.5721	16.6164	58097256.0
2013-02-14 10:00:00	AAPL	Stock	16.6232	16.7389	16.6093	16.7184	29686216.0
2013-02-14 10:30:00	AAPL	Stock	16.7186	16.7686	16.6857	16.7186	22689968.0
2013-02-14 11:00:00	AAPL	Stock	16.7205	16.7568	16.6893	16.7421	14596540.0
2013-02-14 11:30:00	AAPL	Stock	16.7396	16.7607	16.6897	16.7082	13976844.0
2013-02-14 12:00:00	AAPL	Stock	16.7079	16.8404	16.7021	16.78	28851732.0
2013-02-14 12:30:00	AAPL	Stock	16.78	16.8443	16.7724	16.8364	15088192.0
2013-02-14 13:00:00	AAPL	Stock	16.8361	16.8436	16.7564	16.7709	14302792.0
2013-02-14 13:30:00	AAPL	Stock	16.7718	16.7811	16.7186	16.7436	17119592.0
2013-02-14 14:00:00	AAPL	Stock	16.7411	16.7696	16.6871	16.6996	19978896.0
2013-02-14 14:30:00	AAPL	Stock	16.6996	16.7129	16.6365	16.6493	21000476.0
2013-02-14 15:00:00	AAPL	Stock	16.6532	16.6986	16.64	16.6707	22501276.0
2013-02-14 15:30:00	AAPL	Stock	16.6714	16.7018	16.635	16.6643	29253112.0
2013-02-14 16:00:00	AAPL	Stock	16.6639	16.7395	16.6575	16.6821	8540700.0
2013-02-14 16:30:00	AAPL	Stock	16.6829	16.6882	16.589	16.6707	8155056.0
2013-02-14 17:00:00	AAPL	Stock	16.6736	16.6757	16.6629	16.6725	190120.0
2013-02-14 17:30:00	AAPL	Stock	16.6732	16.6946	16.6732	16.6946	85372.0
2013-02-14 18:00:00	AAPL	Stock	16.6796	16.6796	16.6714	16.6746	39480.0
2013-02-14 18:30:00	AAPL	Stock	16.6739	16.6854	16.6714	16.6854	99288.0
2013-02-14 19:00:00	AAPL	Stock	16.68	16.6857	16.6786	16.6857	24556.0
2013-02-14 19:30:00	AAPL	Stock	16.6857	16.6929	16.6839	16.6893	106064.0
2013-02-14 07:30:00	MSFT	Stock	27.94	27.94	27.94	27.94	200.0
2013-02-14 08:00:00	MSFT	Stock	27.94	28.0	27.91	28.0	3112.0
2013-02-14 08:30:00	MSFT	Stock	28.1	28.1	27.94	27.94	15700.0
2013-02-14 09:00:00	MSFT	Stock	27.94	28.03	27.87	27.87	6163137.0
2013-02-14 09:30:00	MSFT	Stock	27.92	28.01	27.87	27.94	3145771.0
2013-02-14 10:00:00	MSFT	Stock	27.94	28.01	27.92	27.985	2233001.0
2013-02-14 10:30:00	MSFT	Stock	27.985	28.055	27.98	28.036	1575491.0
2013-02-14 11:00:00	MSFT	Stock	28.035	28.06	27.975	27.98	1625034.0
2013-02-14 11:30:00	MSFT	Stock	27.98	28.01	27.95	27.984	1559721.0
2013-02-14 12:00:00	MSFT	Stock	27.985	28.01	27.97	28.0	1776780.0
2013-02-14 12:30:00	MSFT	Stock	28.0	28.005	27.95	27.98	1145630.0
2013-02-14 13:00:00	MSFT	Stock	27.98	28.03	27.96	27.96	1214623.0
2013-02-14 13:30:00	MSFT	Stock	27.96	28.0	27.96	27.975	1568757.0
2013-02-14 14:00:00	MSFT	Stock	27.98	28.03	27.96	27.99	1441437.0
2013-02-14 14:30:00	MSFT	Stock	27.991	28.0	27.97	27.991	1095384.0
2013-02-14 15:00:00	MSFT	Stock	27.995	28.03	27.97	28.02	1546763.0
2013-02-14 15:30:00	MSFT	Stock	28.02	28.05	27.95	28.031	4548771.0
2013-02-14 16:00:00	MSFT	Stock	28.04	28.045	27.986	27.99	1522440.0
2013-02-14 16:30:00	MSFT	Stock	28.03	28.04	28.01	28.03	1780.0
2013-02-14 17:00:00	MSFT	Stock	28.03	28.04	27.99	27.99	34848.0

> showing 50 of 75,249 rows — these rows as CSV

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