PREVIEW / stock_30min / 2014-04-07

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-04-07.parquet
  size:    1.6 MB
  rows:    84,549
  symbols: 3,551

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-04-07 04:00:00	AAPL	Stock	18.8532	18.8886	18.8532	18.8886	39480.0
2014-04-07 04:30:00	AAPL	Stock	18.9054	18.9054	18.9054	18.9054	5600.0
2014-04-07 06:00:00	AAPL	Stock	18.9004	18.9004	18.8571	18.8571	9128.0
2014-04-07 07:00:00	AAPL	Stock	18.8671	18.8714	18.8571	18.8571	85960.0
2014-04-07 07:30:00	AAPL	Stock	18.8571	18.8829	18.8568	18.8679	107240.0
2014-04-07 08:00:00	AAPL	Stock	18.8607	18.8929	18.8461	18.8854	265300.0
2014-04-07 08:30:00	AAPL	Stock	18.8925	18.9282	18.8854	18.9179	375872.0
2014-04-07 09:00:00	AAPL	Stock	18.9121	18.9121	18.8507	18.8575	776524.0
2014-04-07 09:30:00	AAPL	Stock	18.8618	18.9607	18.8082	18.9029	31641988.0
2014-04-07 10:00:00	AAPL	Stock	18.9014	18.9114	18.8193	18.8218	20047412.0
2014-04-07 10:30:00	AAPL	Stock	18.8193	18.83	18.7554	18.7818	20039964.0
2014-04-07 11:00:00	AAPL	Stock	18.7836	18.85	18.7596	18.8175	12690356.0
2014-04-07 11:30:00	AAPL	Stock	18.8193	18.8316	18.7382	18.7529	13956824.0
2014-04-07 12:00:00	AAPL	Stock	18.7516	18.7757	18.6978	18.7318	15198148.0
2014-04-07 12:30:00	AAPL	Stock	18.7339	18.7369	18.6943	18.7232	8683136.0
2014-04-07 13:00:00	AAPL	Stock	18.7214	18.7364	18.6693	18.685	9254028.0
2014-04-07 13:30:00	AAPL	Stock	18.6818	18.6964	18.6589	18.6625	8462552.0
2014-04-07 14:00:00	AAPL	Stock	18.6629	18.6868	18.6389	18.6629	8887956.0
2014-04-07 14:30:00	AAPL	Stock	18.665	18.7493	18.6432	18.7271	13739488.0
2014-04-07 15:00:00	AAPL	Stock	18.7232	18.8282	18.71	18.826	14385896.0
2014-04-07 15:30:00	AAPL	Stock	18.8248	18.8286	18.6918	18.6981	23331728.0
2014-04-07 16:00:00	AAPL	Stock	18.6952	18.7279	18.695	18.7071	34892928.0
2014-04-07 16:30:00	AAPL	Stock	18.7897	18.7897	18.6968	18.7025	328608.0
2014-04-07 17:00:00	AAPL	Stock	18.7043	18.7143	18.7025	18.7036	93436.0
2014-04-07 17:30:00	AAPL	Stock	18.7036	18.7143	18.7025	18.7054	34300.0
2014-04-07 18:00:00	AAPL	Stock	18.7054	18.7054	18.6971	18.6971	18200.0
2014-04-07 18:30:00	AAPL	Stock	18.6982	18.7079	18.6975	18.7079	8400.0
2014-04-07 19:00:00	AAPL	Stock	18.7136	18.7143	18.7136	18.7143	14000.0
2014-04-07 19:30:00	AAPL	Stock	18.7214	18.7239	18.7211	18.7239	16800.0
2014-04-07 04:00:00	MSFT	Stock	39.87	39.87	39.87	39.87	500.0
2014-04-07 06:30:00	MSFT	Stock	39.74	39.74	39.74	39.74	490.0
2014-04-07 07:00:00	MSFT	Stock	39.73	39.73	39.73	39.73	915.0
2014-04-07 07:30:00	MSFT	Stock	39.7	39.7	39.7	39.7	100.0
2014-04-07 08:00:00	MSFT	Stock	39.73	39.74	39.67	39.73	6837.0
2014-04-07 08:30:00	MSFT	Stock	39.74	39.87	39.74	39.84	2985.0
2014-04-07 09:00:00	MSFT	Stock	39.81	39.98	39.73	39.97	16215.0
2014-04-07 09:30:00	MSFT	Stock	39.96	40.2	39.74	40.2	5430801.0
2014-04-07 10:00:00	MSFT	Stock	40.21	40.27	39.9	39.91	4058109.0
2014-04-07 10:30:00	MSFT	Stock	39.902	40.089	39.9	39.998	2205989.0
2014-04-07 11:00:00	MSFT	Stock	40.0	40.04	39.93	39.989	1653079.0
2014-04-07 11:30:00	MSFT	Stock	39.986	40.04	39.9	39.98	1401642.0
2014-04-07 12:00:00	MSFT	Stock	39.98	40.11	39.92	39.99	1542365.0
2014-04-07 12:30:00	MSFT	Stock	39.99	40.06	39.94	40.05	1404455.0
2014-04-07 13:00:00	MSFT	Stock	40.05	40.1	39.86	39.904	1447738.0
2014-04-07 13:30:00	MSFT	Stock	39.91	40.0	39.82	39.925	1225086.0
2014-04-07 14:00:00	MSFT	Stock	39.92	39.96	39.78	39.914	1317788.0
2014-04-07 14:30:00	MSFT	Stock	39.91	40.15	39.87	40.085	2096384.0
2014-04-07 15:00:00	MSFT	Stock	40.081	40.2	40.06	40.155	1931778.0
2014-04-07 15:30:00	MSFT	Stock	40.155	40.16	39.79	39.81	6105071.0
2014-04-07 16:00:00	MSFT	Stock	39.82	39.87	39.73	39.82	3328229.0

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

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