PREVIEW / stock_30min / 2014-08-08

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-08-08.parquet
  size:    1.6 MB
  rows:    81,835
  symbols: 3,579

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-08 04:00:00	AAPL	Stock	23.3125	23.5	23.3125	23.4125	26712.0
2014-08-08 04:30:00	AAPL	Stock	23.4125	23.425	23.4075	23.4225	19320.0
2014-08-08 05:00:00	AAPL	Stock	23.4225	23.4225	23.3825	23.4	13600.0
2014-08-08 05:30:00	AAPL	Stock	23.3925	23.4175	23.3925	23.4175	35028.0
2014-08-08 06:00:00	AAPL	Stock	23.4125	23.4625	23.4025	23.44	45848.0
2014-08-08 06:30:00	AAPL	Stock	23.4625	23.48	23.44	23.4675	55740.0
2014-08-08 07:00:00	AAPL	Stock	23.4675	23.6025	23.46	23.6	204360.0
2014-08-08 07:30:00	AAPL	Stock	23.5775	23.605	23.5575	23.5625	87100.0
2014-08-08 08:00:00	AAPL	Stock	23.565	23.6125	23.4125	23.6075	384420.0
2014-08-08 08:30:00	AAPL	Stock	23.6075	23.635	23.585	23.5975	302508.0
2014-08-08 09:00:00	AAPL	Stock	23.59	23.615	23.54	23.5625	421932.0
2014-08-08 09:30:00	AAPL	Stock	23.5625	23.6125	23.4	23.4875	25139128.0
2014-08-08 10:00:00	AAPL	Stock	23.4875	23.55	23.32	23.365	16872908.0
2014-08-08 10:30:00	AAPL	Stock	23.365	23.4875	23.3475	23.455	11898740.0
2014-08-08 11:00:00	AAPL	Stock	23.4525	23.495	23.4212	23.4425	7677196.0
2014-08-08 11:30:00	AAPL	Stock	23.4425	23.4675	23.4	23.4475	7361916.0
2014-08-08 12:00:00	AAPL	Stock	23.4488	23.4725	23.4325	23.445	5507936.0
2014-08-08 12:30:00	AAPL	Stock	23.4432	23.475	23.41	23.4725	4512360.0
2014-08-08 13:00:00	AAPL	Stock	23.47	23.6125	23.4575	23.5925	10530040.0
2014-08-08 13:30:00	AAPL	Stock	23.5965	23.6525	23.58	23.6175	12141520.0
2014-08-08 14:00:00	AAPL	Stock	23.62	23.685	23.6075	23.665	10283468.0
2014-08-08 14:30:00	AAPL	Stock	23.665	23.7025	23.6425	23.685	6797456.0
2014-08-08 15:00:00	AAPL	Stock	23.6872	23.6872	23.615	23.659	9818772.0
2014-08-08 15:30:00	AAPL	Stock	23.6588	23.705	23.6412	23.6825	18753564.0
2014-08-08 16:00:00	AAPL	Stock	23.6825	23.6925	23.49	23.66	7772496.0
2014-08-08 16:30:00	AAPL	Stock	23.66	23.6898	23.6275	23.65	173488.0
2014-08-08 17:00:00	AAPL	Stock	23.6475	23.65	23.64	23.64	17568.0
2014-08-08 17:30:00	AAPL	Stock	23.6425	23.65	23.625	23.64	168664.0
2014-08-08 18:00:00	AAPL	Stock	23.6375	23.645	23.635	23.635	20404.0
2014-08-08 18:30:00	AAPL	Stock	23.64	23.685	23.6375	23.6425	34032.0
2014-08-08 19:00:00	AAPL	Stock	23.64	23.64	23.63	23.635	52684.0
2014-08-08 19:30:00	AAPL	Stock	23.635	23.64	23.6325	23.6325	42432.0
2014-08-08 04:00:00	MSFT	Stock	42.98	42.98	42.98	42.98	100.0
2014-08-08 07:00:00	MSFT	Stock	42.97	42.97	42.97	42.97	350.0
2014-08-08 08:00:00	MSFT	Stock	43.05	43.3	43.05	43.3	2274.0
2014-08-08 08:30:00	MSFT	Stock	43.31	43.43	43.25	43.3	5342.0
2014-08-08 09:00:00	MSFT	Stock	43.26	43.32	43.21	43.24	28227.0
2014-08-08 09:30:00	MSFT	Stock	43.23	43.315	42.95	43.08	4604976.0
2014-08-08 10:00:00	MSFT	Stock	43.08	43.18	42.99	43.035	2499017.0
2014-08-08 10:30:00	MSFT	Stock	43.03	43.16	43.0	43.026	2754681.0
2014-08-08 11:00:00	MSFT	Stock	43.02	43.18	42.952	43.06	1340607.0
2014-08-08 11:30:00	MSFT	Stock	43.057	43.095	42.95	42.99	763285.0
2014-08-08 12:00:00	MSFT	Stock	42.99	43.02	42.92	42.946	703414.0
2014-08-08 12:30:00	MSFT	Stock	42.946	42.99	42.91	42.964	488500.0
2014-08-08 13:00:00	MSFT	Stock	42.97	43.14	42.94	43.1	1676865.0
2014-08-08 13:30:00	MSFT	Stock	43.11	43.22	43.1	43.15	1606283.0
2014-08-08 14:00:00	MSFT	Stock	43.155	43.23	43.115	43.2	1323368.0
2014-08-08 14:30:00	MSFT	Stock	43.205	43.23	43.16	43.19	1951455.0
2014-08-08 15:00:00	MSFT	Stock	43.195	43.2	43.08	43.185	1066955.0
2014-08-08 15:30:00	MSFT	Stock	43.19	43.22	43.13	43.19	4590375.0

> showing 50 of 81,835 rows — these rows as CSV

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