PREVIEW / stock_30min / 2014-07-31

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-31.parquet
  size:    1.6 MB
  rows:    85,585
  symbols: 3,587

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-07-31 04:00:00	AAPL	Stock	24.4875	24.4875	24.3775	24.3775	13200.0
2014-07-31 04:30:00	AAPL	Stock	24.355	24.3625	24.225	24.25	35132.0
2014-07-31 05:00:00	AAPL	Stock	24.225	24.25	24.175	24.225	32992.0
2014-07-31 05:30:00	AAPL	Stock	24.25	24.25	24.2125	24.2275	24568.0
2014-07-31 06:00:00	AAPL	Stock	24.25	24.2675	24.2125	24.2375	19260.0
2014-07-31 06:30:00	AAPL	Stock	24.2475	24.2525	24.2125	24.2175	70528.0
2014-07-31 07:00:00	AAPL	Stock	24.2225	24.305	24.1875	24.2975	135936.0
2014-07-31 07:30:00	AAPL	Stock	24.3	24.3225	24.275	24.2875	154300.0
2014-07-31 08:00:00	AAPL	Stock	24.3	24.55	24.215	24.335	470608.0
2014-07-31 08:30:00	AAPL	Stock	24.3325	24.335	24.3	24.305	402056.0
2014-07-31 09:00:00	AAPL	Stock	24.3025	24.3175	24.2875	24.295	395100.0
2014-07-31 09:30:00	AAPL	Stock	24.29	24.3625	24.1375	24.1425	30928100.0
2014-07-31 10:00:00	AAPL	Stock	24.14	24.215	24.0625	24.1225	21756844.0
2014-07-31 10:30:00	AAPL	Stock	24.1225	24.1225	23.95	23.9925	18112900.0
2014-07-31 11:00:00	AAPL	Stock	23.9925	24.05	23.9875	24.01	13980740.0
2014-07-31 11:30:00	AAPL	Stock	24.0125	24.03	23.84	23.8612	17790576.0
2014-07-31 12:00:00	AAPL	Stock	23.8625	23.895	23.8325	23.865	11877528.0
2014-07-31 12:30:00	AAPL	Stock	23.8638	24.0075	23.8525	23.9738	12533192.0
2014-07-31 13:00:00	AAPL	Stock	23.975	24.0025	23.9225	23.9522	6510172.0
2014-07-31 13:30:00	AAPL	Stock	23.95	24.0688	23.9475	24.0625	8464208.0
2014-07-31 14:00:00	AAPL	Stock	24.065	24.095	24.035	24.0942	7726664.0
2014-07-31 14:30:00	AAPL	Stock	24.0948	24.1	23.9625	23.965	9033520.0
2014-07-31 15:00:00	AAPL	Stock	23.9668	24.0275	23.865	23.885	11525552.0
2014-07-31 15:30:00	AAPL	Stock	23.8848	23.99	23.8775	23.895	23914812.0
2014-07-31 16:00:00	AAPL	Stock	23.8925	24.035	23.8875	23.91	11720180.0
2014-07-31 16:30:00	AAPL	Stock	23.91	24.0502	23.875	23.8925	738052.0
2014-07-31 17:00:00	AAPL	Stock	23.8925	23.9842	23.8125	23.85	479920.0
2014-07-31 17:30:00	AAPL	Stock	23.8375	23.8925	23.8125	23.86	233112.0
2014-07-31 18:00:00	AAPL	Stock	23.865	23.9	23.865	23.885	238656.0
2014-07-31 18:30:00	AAPL	Stock	23.8825	23.895	23.85	23.85	133548.0
2014-07-31 19:00:00	AAPL	Stock	23.87	23.885	23.8575	23.885	77212.0
2014-07-31 19:30:00	AAPL	Stock	23.875	23.875	23.85	23.86	132180.0
2014-07-31 05:30:00	MSFT	Stock	43.2	43.2	43.2	43.2	100.0
2014-07-31 07:00:00	MSFT	Stock	43.12	43.21	43.12	43.21	1400.0
2014-07-31 07:30:00	MSFT	Stock	43.13	43.21	43.13	43.21	8400.0
2014-07-31 08:00:00	MSFT	Stock	43.21	43.28	43.09	43.25	3226.0
2014-07-31 08:30:00	MSFT	Stock	43.23	43.23	43.15	43.15	2300.0
2014-07-31 09:00:00	MSFT	Stock	43.27	43.29	43.25	43.25	7400.0
2014-07-31 09:30:00	MSFT	Stock	43.35	43.61	43.3	43.33	2803387.0
2014-07-31 10:00:00	MSFT	Stock	43.32	43.43	43.21	43.24	1582442.0
2014-07-31 10:30:00	MSFT	Stock	43.24	43.25	43.08	43.17	2060233.0
2014-07-31 11:00:00	MSFT	Stock	43.17	43.37	43.16	43.275	2456318.0
2014-07-31 11:30:00	MSFT	Stock	43.275	43.42	43.21	43.38	2569733.0
2014-07-31 12:00:00	MSFT	Stock	43.39	43.39	43.21	43.23	734717.0
2014-07-31 12:30:00	MSFT	Stock	43.24	43.42	43.23	43.415	1034598.0
2014-07-31 13:00:00	MSFT	Stock	43.42	43.535	43.38	43.42	1213569.0
2014-07-31 13:30:00	MSFT	Stock	43.43	43.58	43.42	43.54	1117492.0
2014-07-31 14:00:00	MSFT	Stock	43.535	43.66	43.52	43.65	1941994.0
2014-07-31 14:30:00	MSFT	Stock	43.65	43.69	43.37	43.38	1756349.0
2014-07-31 15:00:00	MSFT	Stock	43.38	43.46	43.31	43.34	1509329.0

> showing 50 of 85,585 rows — these rows as CSV

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