PREVIEW / stock_30min / 2014-08-01

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-01.parquet
  size:    1.6 MB
  rows:    84,799
  symbols: 3,559

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-01 04:00:00	AAPL	Stock	23.82	23.82	23.625	23.625	24920.0
2014-08-01 04:30:00	AAPL	Stock	23.6	23.6	23.5	23.54	104196.0
2014-08-01 05:00:00	AAPL	Stock	23.5575	23.5575	23.425	23.425	72048.0
2014-08-01 05:30:00	AAPL	Stock	23.425	23.435	23.3275	23.3875	126456.0
2014-08-01 06:00:00	AAPL	Stock	23.4	23.485	23.3875	23.445	148304.0
2014-08-01 06:30:00	AAPL	Stock	23.445	23.5575	23.4275	23.55	154152.0
2014-08-01 07:00:00	AAPL	Stock	23.54	23.585	23.5	23.5725	353692.0
2014-08-01 07:30:00	AAPL	Stock	23.5725	23.6775	23.57	23.6775	345184.0
2014-08-01 08:00:00	AAPL	Stock	23.6825	23.8925	23.5	23.6625	817304.0
2014-08-01 08:30:00	AAPL	Stock	23.6625	23.8625	23.6625	23.7875	1388640.0
2014-08-01 09:00:00	AAPL	Stock	23.7925	23.8025	23.725	23.75	1277900.0
2014-08-01 09:30:00	AAPL	Stock	23.725	24.0375	23.7025	24.0075	32184068.0
2014-08-01 10:00:00	AAPL	Stock	24.01	24.025	23.845	23.969	16301104.0
2014-08-01 10:30:00	AAPL	Stock	23.9678	24.0325	23.89	23.9138	12338264.0
2014-08-01 11:00:00	AAPL	Stock	23.9138	23.965	23.815	23.9275	12237548.0
2014-08-01 11:30:00	AAPL	Stock	23.9275	23.9875	23.8175	23.86	10607492.0
2014-08-01 12:00:00	AAPL	Stock	23.86	23.9675	23.855	23.8925	9114032.0
2014-08-01 12:30:00	AAPL	Stock	23.8947	23.9375	23.825	23.9005	7125380.0
2014-08-01 13:00:00	AAPL	Stock	23.902	24.01	23.8625	24.01	8353340.0
2014-08-01 13:30:00	AAPL	Stock	24.01	24.0625	23.9778	24.0525	11007592.0
2014-08-01 14:00:00	AAPL	Stock	24.0525	24.155	24.0525	24.0875	11745692.0
2014-08-01 14:30:00	AAPL	Stock	24.0878	24.115	24.0275	24.0625	7974192.0
2014-08-01 15:00:00	AAPL	Stock	24.06	24.13	24.05	24.0925	8446024.0
2014-08-01 15:30:00	AAPL	Stock	24.0902	24.15	24.015	24.034	18748464.0
2014-08-01 16:00:00	AAPL	Stock	24.0325	24.06	23.8985	24.0475	5835408.0
2014-08-01 16:30:00	AAPL	Stock	24.045	24.05	24.0175	24.0375	328640.0
2014-08-01 17:00:00	AAPL	Stock	24.0375	24.04	24.0275	24.0375	314128.0
2014-08-01 17:30:00	AAPL	Stock	24.0275	24.0525	24.0275	24.04	49500.0
2014-08-01 18:00:00	AAPL	Stock	24.0525	24.0525	24.0325	24.0375	126332.0
2014-08-01 18:30:00	AAPL	Stock	24.035	24.0425	24.03	24.0425	12048.0
2014-08-01 19:00:00	AAPL	Stock	24.0325	24.045	24.0325	24.045	21804.0
2014-08-01 19:30:00	AAPL	Stock	24.04	24.05	24.0375	24.0475	25808.0
2014-08-01 04:00:00	MSFT	Stock	43.0	43.0	42.8	42.81	4780.0
2014-08-01 04:30:00	MSFT	Stock	42.81	42.83	42.76	42.76	5780.0
2014-08-01 05:00:00	MSFT	Stock	42.76	42.76	42.4	42.53	7500.0
2014-08-01 05:30:00	MSFT	Stock	42.45	42.49	42.45	42.49	1400.0
2014-08-01 06:00:00	MSFT	Stock	42.5	42.55	42.45	42.55	9100.0
2014-08-01 06:30:00	MSFT	Stock	42.56	42.56	42.56	42.56	6000.0
2014-08-01 07:00:00	MSFT	Stock	42.58	42.65	42.58	42.65	5923.0
2014-08-01 07:30:00	MSFT	Stock	42.65	42.87	42.65	42.75	12825.0
2014-08-01 08:00:00	MSFT	Stock	42.86	42.92	42.65	42.9	60963.0
2014-08-01 08:30:00	MSFT	Stock	42.95	43.08	42.91	43.04	11152.0
2014-08-01 09:00:00	MSFT	Stock	43.05	43.16	43.05	43.16	28623.0
2014-08-01 09:30:00	MSFT	Stock	43.21	43.25	42.85	43.23	4317267.0
2014-08-01 10:00:00	MSFT	Stock	43.23	43.24	43.11	43.2	2546394.0
2014-08-01 10:30:00	MSFT	Stock	43.21	43.21	42.98	43.015	1933737.0
2014-08-01 11:00:00	MSFT	Stock	43.01	43.24	42.91	43.1	2122438.0
2014-08-01 11:30:00	MSFT	Stock	43.11	43.13	42.68	42.81	2158763.0
2014-08-01 12:00:00	MSFT	Stock	42.82	42.89	42.75	42.78	1500769.0
2014-08-01 12:30:00	MSFT	Stock	42.78	42.81	42.6	42.75	1479383.0

> showing 50 of 84,799 rows — these rows as CSV

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