PREVIEW / stock_30min / 2014-05-23

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-05-23.parquet
  size:    1.5 MB
  rows:    80,310
  symbols: 3,534

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-05-23 04:30:00	AAPL	Stock	21.6804	21.6839	21.6804	21.6839	16800.0
2014-05-23 05:30:00	AAPL	Stock	21.6914	21.6925	21.6914	21.6925	5600.0
2014-05-23 06:00:00	AAPL	Stock	21.6993	21.6993	21.6993	21.6993	2800.0
2014-05-23 07:00:00	AAPL	Stock	21.6907	21.6907	21.6875	21.6875	30800.0
2014-05-23 07:30:00	AAPL	Stock	21.6861	21.6861	21.6761	21.6761	8400.0
2014-05-23 08:00:00	AAPL	Stock	21.6786	21.6964	21.6514	21.6607	134344.0
2014-05-23 08:30:00	AAPL	Stock	21.6714	21.6729	21.6636	21.6657	112140.0
2014-05-23 09:00:00	AAPL	Stock	21.6639	21.6939	21.6571	21.6875	419132.0
2014-05-23 09:30:00	AAPL	Stock	21.6875	21.7475	21.6729	21.7268	30571800.0
2014-05-23 10:00:00	AAPL	Stock	21.7339	21.7439	21.6968	21.7057	13649832.0
2014-05-23 10:30:00	AAPL	Stock	21.7057	21.7071	21.6596	21.7011	14429016.0
2014-05-23 11:00:00	AAPL	Stock	21.7029	21.7246	21.6979	21.7218	9228548.0
2014-05-23 11:30:00	AAPL	Stock	21.7221	21.7404	21.6993	21.725	7900816.0
2014-05-23 12:00:00	AAPL	Stock	21.7243	21.7739	21.7243	21.7609	9857344.0
2014-05-23 12:30:00	AAPL	Stock	21.7646	21.7725	21.7332	21.7589	6380276.0
2014-05-23 13:00:00	AAPL	Stock	21.7589	21.7807	21.7568	21.7766	7382256.0
2014-05-23 13:30:00	AAPL	Stock	21.7779	21.8071	21.7736	21.7964	12149760.0
2014-05-23 14:00:00	AAPL	Stock	21.7964	21.8446	21.7921	21.8279	10883208.0
2014-05-23 14:30:00	AAPL	Stock	21.8293	21.8457	21.8107	21.8454	7874608.0
2014-05-23 15:00:00	AAPL	Stock	21.8445	21.9429	21.8429	21.9386	19754392.0
2014-05-23 15:30:00	AAPL	Stock	21.9386	21.9546	21.8893	21.9336	31740884.0
2014-05-23 16:00:00	AAPL	Stock	21.9332	21.9336	21.6567	21.9107	8233792.0
2014-05-23 16:30:00	AAPL	Stock	21.9175	21.9332	21.9071	21.9332	367864.0
2014-05-23 17:00:00	AAPL	Stock	21.9089	21.9225	21.9089	21.9225	61432.0
2014-05-23 17:30:00	AAPL	Stock	21.925	21.9271	21.9246	21.9271	61712.0
2014-05-23 18:00:00	AAPL	Stock	21.9332	21.9332	21.9196	21.9257	121240.0
2014-05-23 18:30:00	AAPL	Stock	21.9243	21.9261	21.9229	21.9229	31920.0
2014-05-23 19:00:00	AAPL	Stock	21.9221	21.9243	21.9182	21.9214	45360.0
2014-05-23 19:30:00	AAPL	Stock	21.9232	21.9271	21.9214	21.9271	138516.0
2014-05-23 09:00:00	MSFT	Stock	40.14	40.42	40.14	40.35	34943.0
2014-05-23 09:30:00	MSFT	Stock	40.3	40.37	40.02	40.2	2867376.0
2014-05-23 10:00:00	MSFT	Stock	40.2	40.27	40.14	40.265	1247087.0
2014-05-23 10:30:00	MSFT	Stock	40.26	40.265	40.04	40.085	1489415.0
2014-05-23 11:00:00	MSFT	Stock	40.09	40.14	40.05	40.11	1013245.0
2014-05-23 11:30:00	MSFT	Stock	40.107	40.12	40.04	40.085	900276.0
2014-05-23 12:00:00	MSFT	Stock	40.085	40.12	40.04	40.06	637616.0
2014-05-23 12:30:00	MSFT	Stock	40.065	40.07	40.02	40.06	738336.0
2014-05-23 13:00:00	MSFT	Stock	40.06	40.07	40.005	40.01	1051755.0
2014-05-23 13:30:00	MSFT	Stock	40.015	40.08	40.0	40.08	779456.0
2014-05-23 14:00:00	MSFT	Stock	40.07	40.12	40.07	40.1	801414.0
2014-05-23 14:30:00	MSFT	Stock	40.1	40.12	40.09	40.11	536660.0
2014-05-23 15:00:00	MSFT	Stock	40.11	40.12	40.09	40.12	649946.0
2014-05-23 15:30:00	MSFT	Stock	40.115	40.13	40.06	40.12	2323010.0
2014-05-23 16:00:00	MSFT	Stock	40.12	40.166	40.06	40.12	2226851.0
2014-05-23 16:30:00	MSFT	Stock	40.12	40.12	40.12	40.12	88500.0
2014-05-23 17:00:00	MSFT	Stock	40.07	40.07	40.07	40.07	818.0
2014-05-23 17:30:00	MSFT	Stock	40.06	40.06	40.02	40.02	6750.0
2014-05-23 18:30:00	MSFT	Stock	40.06	40.06	40.03	40.03	250.0
2014-05-23 19:00:00	MSFT	Stock	40.05	40.05	40.04	40.04	400.0
2014-05-23 06:30:00	NVDA	Stock	0.462	0.462	0.462	0.462	20000.0

> showing 50 of 80,310 rows — these rows as CSV

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