PREVIEW / stock_30min / 2015-02-05

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-02-05.parquet
  size:    1.6 MB
  rows:    84,280
  symbols: 3,518

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
2015-02-05 04:00:00	AAPL	Stock	29.84	29.9	29.81	29.875	23200.0
2015-02-05 04:30:00	AAPL	Stock	29.875	29.8875	29.875	29.8825	33520.0
2015-02-05 05:00:00	AAPL	Stock	29.8875	29.935	29.8825	29.9275	21764.0
2015-02-05 05:30:00	AAPL	Stock	29.9175	29.935	29.9	29.935	20492.0
2015-02-05 06:00:00	AAPL	Stock	29.935	29.975	29.915	29.9225	54828.0
2015-02-05 06:30:00	AAPL	Stock	29.925	29.9575	29.915	29.9375	32448.0
2015-02-05 07:00:00	AAPL	Stock	29.925	29.975	29.925	29.97	189180.0
2015-02-05 07:30:00	AAPL	Stock	29.975	29.98	29.9375	29.9375	119584.0
2015-02-05 08:00:00	AAPL	Stock	29.95	29.9825	29.9125	29.9475	616348.0
2015-02-05 08:30:00	AAPL	Stock	29.9475	30.0375	29.93	30.035	2060876.0
2015-02-05 09:00:00	AAPL	Stock	30.025	30.05	29.9625	29.9625	729796.0
2015-02-05 09:30:00	AAPL	Stock	30.005	30.0512	29.88	29.9448	29364780.0
2015-02-05 10:00:00	AAPL	Stock	29.945	29.9975	29.8375	29.8752	17213244.0
2015-02-05 10:30:00	AAPL	Stock	29.875	29.975	29.8625	29.915	10099068.0
2015-02-05 11:00:00	AAPL	Stock	29.915	30.0	29.8925	29.9975	9359708.0
2015-02-05 11:30:00	AAPL	Stock	29.995	30.0575	29.9175	29.9625	12922200.0
2015-02-05 12:00:00	AAPL	Stock	29.9625	29.975	29.9112	29.9325	6048812.0
2015-02-05 12:30:00	AAPL	Stock	29.935	29.9688	29.9175	29.9315	4806764.0
2015-02-05 13:00:00	AAPL	Stock	29.94	29.9825	29.9275	29.965	5201552.0
2015-02-05 13:30:00	AAPL	Stock	29.965	29.9762	29.93	29.9342	4393840.0
2015-02-05 14:00:00	AAPL	Stock	29.9365	29.9725	29.895	29.9358	6864852.0
2015-02-05 14:30:00	AAPL	Stock	29.9342	29.9448	29.875	29.8902	8470268.0
2015-02-05 15:00:00	AAPL	Stock	29.8925	29.9325	29.8125	29.925	10837360.0
2015-02-05 15:30:00	AAPL	Stock	29.9275	30.0025	29.91	29.985	19047280.0
2015-02-05 16:00:00	AAPL	Stock	29.985	29.9875	29.9425	29.985	4554204.0
2015-02-05 16:30:00	AAPL	Stock	29.9478	30.0065	29.904	29.9375	274920.0
2015-02-05 17:00:00	AAPL	Stock	29.95	29.985	29.95	29.9675	225632.0
2015-02-05 17:30:00	AAPL	Stock	29.9675	29.975	29.96	29.9675	28676.0
2015-02-05 18:00:00	AAPL	Stock	29.9675	29.99	29.9675	29.99	51524.0
2015-02-05 18:30:00	AAPL	Stock	29.985	29.985	29.96	29.97	36724.0
2015-02-05 19:00:00	AAPL	Stock	29.9625	29.975	29.9625	29.965	20112.0
2015-02-05 19:30:00	AAPL	Stock	29.97	29.9725	29.965	29.9725	40852.0
2015-02-05 05:00:00	MSFT	Stock	41.94	42.01	41.94	42.01	2200.0
2015-02-05 05:30:00	MSFT	Stock	41.97	42.01	41.97	42.01	1300.0
2015-02-05 06:30:00	MSFT	Stock	41.85	41.85	41.84	41.85	700.0
2015-02-05 07:00:00	MSFT	Stock	41.96	42.05	41.93	42.0	4027.0
2015-02-05 08:00:00	MSFT	Stock	42.01	42.19	42.01	42.01	5238.0
2015-02-05 08:30:00	MSFT	Stock	42.01	42.1	42.01	42.02	12590.0
2015-02-05 09:00:00	MSFT	Stock	42.02	42.21	41.98	42.21	25885.0
2015-02-05 09:30:00	MSFT	Stock	42.22	42.33	41.855	42.32	4717987.0
2015-02-05 10:00:00	MSFT	Stock	42.32	42.64	42.295	42.51	4747980.0
2015-02-05 10:30:00	MSFT	Stock	42.505	42.6	42.49	42.54	2290349.0
2015-02-05 11:00:00	MSFT	Stock	42.54	42.58	42.45	42.5	2674786.0
2015-02-05 11:30:00	MSFT	Stock	42.5	42.52	42.39	42.47	1403927.0
2015-02-05 12:00:00	MSFT	Stock	42.47	42.5	42.27	42.284	2079022.0
2015-02-05 12:30:00	MSFT	Stock	42.28	42.31	42.25	42.26	2316927.0
2015-02-05 13:00:00	MSFT	Stock	42.26	42.35	42.25	42.29	1633833.0
2015-02-05 13:30:00	MSFT	Stock	42.293	42.38	42.27	42.35	1463504.0
2015-02-05 14:00:00	MSFT	Stock	42.35	42.424	42.28	42.338	1267501.0
2015-02-05 14:30:00	MSFT	Stock	42.34	42.36	42.25	42.328	1729545.0

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

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