PREVIEW / stock_30min / 2014-08-05

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-05.parquet
  size:    1.6 MB
  rows:    83,213
  symbols: 3,586

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-08-05 05:00:00	AAPL	Stock	23.9325	23.9325	23.9275	23.9275	3000.0
2014-08-05 05:30:00	AAPL	Stock	23.925	23.925	23.925	23.925	2000.0
2014-08-05 06:00:00	AAPL	Stock	23.9175	23.9225	23.9175	23.9175	6856.0
2014-08-05 06:30:00	AAPL	Stock	23.875	23.875	23.875	23.875	1920.0
2014-08-05 07:00:00	AAPL	Stock	23.9175	23.9175	23.865	23.9	39240.0
2014-08-05 07:30:00	AAPL	Stock	23.895	23.895	23.875	23.8775	25696.0
2014-08-05 08:00:00	AAPL	Stock	23.8825	23.9325	23.8325	23.8775	377176.0
2014-08-05 08:30:00	AAPL	Stock	23.875	23.8875	23.8525	23.8675	179920.0
2014-08-05 09:00:00	AAPL	Stock	23.8775	23.8975	23.83	23.8475	263304.0
2014-08-05 09:30:00	AAPL	Stock	23.845	23.8625	23.59	23.6225	28834512.0
2014-08-05 10:00:00	AAPL	Stock	23.6225	23.7475	23.6025	23.7175	16140456.0
2014-08-05 10:30:00	AAPL	Stock	23.7175	23.7975	23.7	23.7275	11046720.0
2014-08-05 11:00:00	AAPL	Stock	23.73	23.765	23.6675	23.73	8790188.0
2014-08-05 11:30:00	AAPL	Stock	23.7325	23.765	23.67	23.6975	6683176.0
2014-08-05 12:00:00	AAPL	Stock	23.6975	23.7475	23.6575	23.7	6631548.0
2014-08-05 12:30:00	AAPL	Stock	23.7013	23.7325	23.6725	23.7325	6850212.0
2014-08-05 13:00:00	AAPL	Stock	23.73	23.8725	23.7025	23.86	19829728.0
2014-08-05 13:30:00	AAPL	Stock	23.86	23.92	23.6675	23.76	26115036.0
2014-08-05 14:00:00	AAPL	Stock	23.7575	23.7738	23.63	23.7525	16549156.0
2014-08-05 14:30:00	AAPL	Stock	23.7538	23.82	23.745	23.7575	11125168.0
2014-08-05 15:00:00	AAPL	Stock	23.7575	23.7975	23.705	23.7502	10316624.0
2014-08-05 15:30:00	AAPL	Stock	23.7512	23.845	23.7512	23.785	18470576.0
2014-08-05 16:00:00	AAPL	Stock	23.78	23.7938	23.6862	23.78	8742612.0
2014-08-05 16:30:00	AAPL	Stock	23.78	23.7975	23.7775	23.78	414508.0
2014-08-05 17:00:00	AAPL	Stock	23.79	23.795	23.7875	23.795	22120.0
2014-08-05 17:30:00	AAPL	Stock	23.7875	23.7975	23.78	23.7925	54992.0
2014-08-05 18:00:00	AAPL	Stock	23.7925	23.8275	23.7925	23.8175	42896.0
2014-08-05 18:30:00	AAPL	Stock	23.82	23.83	23.8125	23.83	37396.0
2014-08-05 19:00:00	AAPL	Stock	23.835	23.835	23.8175	23.825	57208.0
2014-08-05 19:30:00	AAPL	Stock	23.82	23.8725	23.8175	23.8625	73424.0
2014-08-05 05:00:00	MSFT	Stock	43.3	43.3	43.3	43.3	100.0
2014-08-05 06:00:00	MSFT	Stock	43.3	43.3	43.3	43.3	300.0
2014-08-05 08:00:00	MSFT	Stock	43.35	43.39	43.25	43.32	5312.0
2014-08-05 08:30:00	MSFT	Stock	43.26	43.3	43.2	43.3	7695.0
2014-08-05 09:00:00	MSFT	Stock	43.3	43.37	43.26	43.31	10437.0
2014-08-05 09:30:00	MSFT	Stock	43.3	43.46	43.0	43.05	2842823.0
2014-08-05 10:00:00	MSFT	Stock	43.06	43.07	42.885	43.045	2380146.0
2014-08-05 10:30:00	MSFT	Stock	43.04	43.18	43.03	43.12	1735542.0
2014-08-05 11:00:00	MSFT	Stock	43.11	43.28	43.005	43.24	1257311.0
2014-08-05 11:30:00	MSFT	Stock	43.25	43.31	43.1	43.18	1075848.0
2014-08-05 12:00:00	MSFT	Stock	43.165	43.21	43.05	43.134	974206.0
2014-08-05 12:30:00	MSFT	Stock	43.135	43.18	43.06	43.17	969769.0
2014-08-05 13:00:00	MSFT	Stock	43.165	43.275	43.11	43.27	744154.0
2014-08-05 13:30:00	MSFT	Stock	43.265	43.28	42.85	42.905	2173371.0
2014-08-05 14:00:00	MSFT	Stock	42.91	43.04	42.83	43.03	1576233.0
2014-08-05 14:30:00	MSFT	Stock	43.03	43.07	42.895	42.92	1078214.0
2014-08-05 15:00:00	MSFT	Stock	42.925	42.99	42.855	42.955	1738095.0
2014-08-05 15:30:00	MSFT	Stock	42.96	43.14	42.959	43.08	3100909.0
2014-08-05 16:00:00	MSFT	Stock	43.085	43.096	43.0	43.0	3523165.0
2014-08-05 16:30:00	MSFT	Stock	43.047	43.08	43.0	43.0	110523.0

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

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