PREVIEW / stock_30min / 2014-01-02

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-02.parquet
  size:    1.6 MB
  rows:    81,905
  symbols: 3,515

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-01-02 04:00:00	AAPL	Stock	19.7679	19.8679	19.7679	19.8586	135072.0
2014-01-02 04:30:00	AAPL	Stock	19.8571	19.8575	19.8521	19.8521	16800.0
2014-01-02 05:00:00	AAPL	Stock	19.8318	19.8318	19.8039	19.8039	8400.0
2014-01-02 05:30:00	AAPL	Stock	19.8018	19.8118	19.8018	19.8118	14000.0
2014-01-02 06:00:00	AAPL	Stock	19.8607	19.8643	19.8214	19.8214	59584.0
2014-01-02 06:30:00	AAPL	Stock	19.8396	19.845	19.8396	19.845	8400.0
2014-01-02 07:00:00	AAPL	Stock	19.8214	19.9286	19.8214	19.8536	252056.0
2014-01-02 07:30:00	AAPL	Stock	19.8496	19.8886	19.8471	19.865	391636.0
2014-01-02 08:00:00	AAPL	Stock	19.8661	19.8925	19.8214	19.8339	2106468.0
2014-01-02 08:30:00	AAPL	Stock	19.8314	19.8357	19.8036	19.8268	1237964.0
2014-01-02 09:00:00	AAPL	Stock	19.8304	19.8611	19.8218	19.8557	1157828.0
2014-01-02 09:30:00	AAPL	Stock	19.8457	19.8939	19.7571	19.7857	44246944.0
2014-01-02 10:00:00	AAPL	Stock	19.7857	19.8011	19.7371	19.7671	21955892.0
2014-01-02 10:30:00	AAPL	Stock	19.7639	19.8032	19.7371	19.7679	13918268.0
2014-01-02 11:00:00	AAPL	Stock	19.7712	19.7971	19.7536	19.7812	10011064.0
2014-01-02 11:30:00	AAPL	Stock	19.7825	19.7875	19.7421	19.7496	11004392.0
2014-01-02 12:00:00	AAPL	Stock	19.7511	19.77	19.7382	19.7561	9047920.0
2014-01-02 12:30:00	AAPL	Stock	19.7564	19.7857	19.7395	19.7761	6732572.0
2014-01-02 13:00:00	AAPL	Stock	19.7786	19.7821	19.7429	19.7429	5564636.0
2014-01-02 13:30:00	AAPL	Stock	19.7446	19.7611	19.7268	19.7536	10257800.0
2014-01-02 14:00:00	AAPL	Stock	19.7579	19.7639	19.715	19.725	7962248.0
2014-01-02 14:30:00	AAPL	Stock	19.7261	19.7446	19.7171	19.7389	6410040.0
2014-01-02 15:00:00	AAPL	Stock	19.7407	19.7746	19.7325	19.7439	9610244.0
2014-01-02 15:30:00	AAPL	Stock	19.745	19.7593	19.7368	19.7582	20767208.0
2014-01-02 16:00:00	AAPL	Stock	19.7546	19.7703	19.7453	19.7543	8549716.0
2014-01-02 16:30:00	AAPL	Stock	19.7554	19.7554	19.743	19.7464	894040.0
2014-01-02 17:00:00	AAPL	Stock	19.75	19.7586	19.75	19.7561	189784.0
2014-01-02 17:30:00	AAPL	Stock	19.7521	19.7554	19.75	19.7554	188972.0
2014-01-02 18:00:00	AAPL	Stock	19.7554	19.7554	19.7511	19.7511	39620.0
2014-01-02 18:30:00	AAPL	Stock	19.7511	19.7514	19.75	19.75	109844.0
2014-01-02 19:00:00	AAPL	Stock	19.7504	19.7504	19.7482	19.7482	32564.0
2014-01-02 19:30:00	AAPL	Stock	19.75	19.7521	19.75	19.75	30800.0
2014-01-02 05:30:00	MSFT	Stock	37.39	37.39	37.39	37.39	1200.0
2014-01-02 06:00:00	MSFT	Stock	37.39	37.39	37.39	37.39	800.0
2014-01-02 07:00:00	MSFT	Stock	37.28	37.28	37.28	37.28	100.0
2014-01-02 07:30:00	MSFT	Stock	37.4	37.4	37.35	37.35	500.0
2014-01-02 08:00:00	MSFT	Stock	37.43	37.43	37.3	37.3	8214.0
2014-01-02 08:30:00	MSFT	Stock	37.33	37.34	37.28	37.28	571.0
2014-01-02 09:00:00	MSFT	Stock	37.43	37.43	37.31	37.35	64967.0
2014-01-02 09:30:00	MSFT	Stock	37.35	37.4	37.14	37.26	3979247.0
2014-01-02 10:00:00	MSFT	Stock	37.25	37.31	37.19	37.205	2645289.0
2014-01-02 10:30:00	MSFT	Stock	37.2	37.25	37.15	37.185	1649222.0
2014-01-02 11:00:00	MSFT	Stock	37.185	37.28	37.13	37.24	1970428.0
2014-01-02 11:30:00	MSFT	Stock	37.235	37.26	37.18	37.255	1353034.0
2014-01-02 12:00:00	MSFT	Stock	37.255	37.27	37.18	37.22	1008683.0
2014-01-02 12:30:00	MSFT	Stock	37.215	37.31	37.2	37.285	1303549.0
2014-01-02 13:00:00	MSFT	Stock	37.287	37.3	37.18	37.228	1587169.0
2014-01-02 13:30:00	MSFT	Stock	37.23	37.28	37.17	37.255	1127139.0
2014-01-02 14:00:00	MSFT	Stock	37.26	37.35	37.18	37.202	1437538.0
2014-01-02 14:30:00	MSFT	Stock	37.21	37.28	37.12	37.15	1079472.0

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

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