PREVIEW / stock_30min / 2015-03-11

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-11.parquet
  size:    1.6 MB
  rows:    82,741
  symbols: 3,500

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
2015-03-11 04:00:00	AAPL	Stock	30.875	31.25	30.875	31.25	23080.0
2015-03-11 04:30:00	AAPL	Stock	31.255	31.255	31.1625	31.2	7200.0
2015-03-11 05:00:00	AAPL	Stock	31.225	31.25	31.2025	31.2025	26504.0
2015-03-11 05:30:00	AAPL	Stock	31.225	31.24	31.215	31.225	8180.0
2015-03-11 06:00:00	AAPL	Stock	31.245	31.28	31.2375	31.2625	38396.0
2015-03-11 06:30:00	AAPL	Stock	31.2625	31.2625	31.2025	31.2525	31976.0
2015-03-11 07:00:00	AAPL	Stock	31.25	31.275	31.225	31.225	75700.0
2015-03-11 07:30:00	AAPL	Stock	31.2275	31.2275	31.175	31.21	43928.0
2015-03-11 08:00:00	AAPL	Stock	31.2175	31.2975	31.195	31.2775	332676.0
2015-03-11 08:30:00	AAPL	Stock	31.265	31.3	31.265	31.285	272300.0
2015-03-11 09:00:00	AAPL	Stock	31.285	31.2975	31.155	31.1775	558264.0
2015-03-11 09:30:00	AAPL	Stock	31.1875	31.1925	30.605	30.745	55254276.0
2015-03-11 10:00:00	AAPL	Stock	30.7475	30.84	30.5375	30.705	32653616.0
2015-03-11 10:30:00	AAPL	Stock	30.7025	30.7425	30.5275	30.6525	24960996.0
2015-03-11 11:00:00	AAPL	Stock	30.65	30.8125	30.6375	30.8	17964168.0
2015-03-11 11:30:00	AAPL	Stock	30.805	30.9275	30.77	30.9275	15621436.0
2015-03-11 12:00:00	AAPL	Stock	30.9275	30.975	30.805	30.85	12002860.0
2015-03-11 12:30:00	AAPL	Stock	30.85	30.9775	30.8075	30.9	8833052.0
2015-03-11 13:00:00	AAPL	Stock	30.9	30.965	30.8675	30.925	7758600.0
2015-03-11 13:30:00	AAPL	Stock	30.9262	30.93	30.72	30.7875	13410660.0
2015-03-11 14:00:00	AAPL	Stock	30.79	30.89	30.76	30.81	8789144.0
2015-03-11 14:30:00	AAPL	Stock	30.8092	30.8425	30.73	30.8138	8733720.0
2015-03-11 15:00:00	AAPL	Stock	30.8125	30.8275	30.59	30.605	14936596.0
2015-03-11 15:30:00	AAPL	Stock	30.6075	30.69	30.5575	30.5625	23801576.0
2015-03-11 16:00:00	AAPL	Stock	30.56	30.7742	30.56	30.6075	10403952.0
2015-03-11 16:30:00	AAPL	Stock	30.61	30.6682	30.5575	30.625	794392.0
2015-03-11 17:00:00	AAPL	Stock	30.625	30.7922	30.56	30.7608	197080.0
2015-03-11 17:30:00	AAPL	Stock	30.6	30.61	30.5925	30.5975	28456.0
2015-03-11 18:00:00	AAPL	Stock	30.5975	30.61	30.56	30.5798	157184.0
2015-03-11 18:30:00	AAPL	Stock	30.575	30.585	30.56	30.5825	103644.0
2015-03-11 19:00:00	AAPL	Stock	30.5825	30.5825	30.565	30.565	25128.0
2015-03-11 19:30:00	AAPL	Stock	30.5725	30.5825	30.5625	30.5775	76860.0
2015-03-11 04:00:00	MSFT	Stock	42.1	42.1	42.1	42.1	200.0
2015-03-11 05:00:00	MSFT	Stock	42.16	42.16	42.13	42.13	700.0
2015-03-11 05:30:00	MSFT	Stock	42.13	42.13	42.13	42.13	100.0
2015-03-11 06:30:00	MSFT	Stock	42.18	42.24	42.18	42.24	850.0
2015-03-11 07:00:00	MSFT	Stock	42.25	42.28	42.25	42.28	1000.0
2015-03-11 07:30:00	MSFT	Stock	42.21	42.28	42.18	42.18	4800.0
2015-03-11 08:30:00	MSFT	Stock	42.28	42.28	42.18	42.19	5000.0
2015-03-11 09:00:00	MSFT	Stock	42.18	42.31	42.11	42.22	38969.0
2015-03-11 09:30:00	MSFT	Stock	42.31	42.37	42.09	42.22	3338051.0
2015-03-11 10:00:00	MSFT	Stock	42.22	42.34	42.114	42.14	2294694.0
2015-03-11 10:30:00	MSFT	Stock	42.14	42.16	41.955	42.002	2538165.0
2015-03-11 11:00:00	MSFT	Stock	42.005	42.1	41.93	42.08	1915308.0
2015-03-11 11:30:00	MSFT	Stock	42.08	42.12	42.02	42.065	1160656.0
2015-03-11 12:00:00	MSFT	Stock	42.07	42.15	42.0	42.01	1167219.0
2015-03-11 12:30:00	MSFT	Stock	42.015	42.12	42.0	42.05	1051436.0
2015-03-11 13:00:00	MSFT	Stock	42.05	42.05	41.98	41.99	1492194.0
2015-03-11 13:30:00	MSFT	Stock	42.0	42.0	41.84	41.882	1459486.0
2015-03-11 14:00:00	MSFT	Stock	41.88	42.05	41.863	42.02	1106884.0

> showing 50 of 82,741 rows — these rows as CSV

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