PREVIEW / stock_30min / 2015-03-12

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-12.parquet
  size:    1.6 MB
  rows:    83,098
  symbols: 3,521

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-12 04:00:00	AAPL	Stock	30.7475	30.8575	30.7125	30.715	11600.0
2015-03-12 04:30:00	AAPL	Stock	30.69	30.6975	30.69	30.6975	800.0
2015-03-12 05:00:00	AAPL	Stock	30.69	30.6925	30.665	30.665	21196.0
2015-03-12 05:30:00	AAPL	Stock	30.665	30.6675	30.64	30.65	25964.0
2015-03-12 06:00:00	AAPL	Stock	30.675	30.6875	30.63	30.675	23804.0
2015-03-12 06:30:00	AAPL	Stock	30.6875	30.72	30.675	30.72	23100.0
2015-03-12 07:00:00	AAPL	Stock	30.7175	30.7175	30.6525	30.6775	49412.0
2015-03-12 07:30:00	AAPL	Stock	30.6875	30.715	30.6575	30.71	40368.0
2015-03-12 08:00:00	AAPL	Stock	30.7125	30.7175	30.64	30.6575	541392.0
2015-03-12 08:30:00	AAPL	Stock	30.6575	30.67	30.58	30.6375	578628.0
2015-03-12 09:00:00	AAPL	Stock	30.6375	30.645	30.4525	30.58	1233136.0
2015-03-12 09:30:00	AAPL	Stock	30.5775	30.9275	30.4075	30.905	37076652.0
2015-03-12 10:00:00	AAPL	Stock	30.905	31.0875	30.8325	31.0488	21594064.0
2015-03-12 10:30:00	AAPL	Stock	31.0425	31.11	30.9475	31.0125	14332972.0
2015-03-12 11:00:00	AAPL	Stock	31.01	31.0925	30.9248	31.046	10699104.0
2015-03-12 11:30:00	AAPL	Stock	31.0475	31.06	30.9175	30.955	7433184.0
2015-03-12 12:00:00	AAPL	Stock	30.955	31.1025	30.9475	31.0625	8363116.0
2015-03-12 12:30:00	AAPL	Stock	31.0602	31.0675	30.965	31.015	5647556.0
2015-03-12 13:00:00	AAPL	Stock	31.0125	31.08	30.98	31.05	5295044.0
2015-03-12 13:30:00	AAPL	Stock	31.0475	31.175	31.0125	31.1425	8529020.0
2015-03-12 14:00:00	AAPL	Stock	31.1425	31.225	31.08	31.1925	10137556.0
2015-03-12 14:30:00	AAPL	Stock	31.19	31.2025	31.04	31.1502	11821796.0
2015-03-12 15:00:00	AAPL	Stock	31.15	31.1862	31.045	31.115	10016960.0
2015-03-12 15:30:00	AAPL	Stock	31.1125	31.1525	31.05	31.11	14944972.0
2015-03-12 16:00:00	AAPL	Stock	31.1125	31.1865	30.56	31.11	12340008.0
2015-03-12 16:30:00	AAPL	Stock	31.11	31.1425	31.0238	31.1375	197776.0
2015-03-12 17:00:00	AAPL	Stock	31.1325	31.135	31.1125	31.1275	148152.0
2015-03-12 17:30:00	AAPL	Stock	31.125	31.13	31.1125	31.125	52192.0
2015-03-12 18:00:00	AAPL	Stock	31.125	31.195	31.1225	31.18	220496.0
2015-03-12 18:30:00	AAPL	Stock	31.18	31.195	31.155	31.19	53336.0
2015-03-12 19:00:00	AAPL	Stock	31.1925	31.2125	31.1725	31.175	83804.0
2015-03-12 19:30:00	AAPL	Stock	31.165	31.2125	31.165	31.2075	77848.0
2015-03-12 05:00:00	MSFT	Stock	42.22	42.22	42.22	42.22	100.0
2015-03-12 08:30:00	MSFT	Stock	42.11	42.15	42.05	42.15	8400.0
2015-03-12 09:00:00	MSFT	Stock	42.1	42.1	40.67	41.08	1596381.0
2015-03-12 09:30:00	MSFT	Stock	41.33	41.65	41.0	41.38	11619253.0
2015-03-12 10:00:00	MSFT	Stock	41.39	41.6	41.37	41.43	4309050.0
2015-03-12 10:30:00	MSFT	Stock	41.43	41.57	41.35	41.384	4085718.0
2015-03-12 11:00:00	MSFT	Stock	41.38	41.42	41.3	41.33	3624229.0
2015-03-12 11:30:00	MSFT	Stock	41.33	41.33	41.16	41.24	3353365.0
2015-03-12 12:00:00	MSFT	Stock	41.24	41.24	41.1	41.15	2210493.0
2015-03-12 12:30:00	MSFT	Stock	41.143	41.24	41.14	41.2	1962450.0
2015-03-12 13:00:00	MSFT	Stock	41.2	41.27	41.19	41.24	1903021.0
2015-03-12 13:30:00	MSFT	Stock	41.24	41.26	41.125	41.149	2249502.0
2015-03-12 14:00:00	MSFT	Stock	41.14	41.15	41.05	41.1	2045845.0
2015-03-12 14:30:00	MSFT	Stock	41.1	41.1	40.86	41.0	5329275.0
2015-03-12 15:00:00	MSFT	Stock	40.995	41.09	40.99	40.995	4363217.0
2015-03-12 15:30:00	MSFT	Stock	41.0	41.04	40.98	41.01	6537971.0
2015-03-12 16:00:00	MSFT	Stock	41.02	41.345	40.95	41.02	2578272.0
2015-03-12 16:30:00	MSFT	Stock	41.318	41.318	40.99	41.01	168656.0

> showing 50 of 83,098 rows — these rows as CSV

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