PREVIEW / stock_30min / 2015-03-27

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-03-27.parquet
  size:    1.6 MB
  rows:    81,879
  symbols: 3,476

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-27 04:00:00	AAPL	Stock	31.0875	31.2	31.0875	31.1475	11600.0
2015-03-27 04:30:00	AAPL	Stock	31.175	31.1975	31.1025	31.1025	4400.0
2015-03-27 05:00:00	AAPL	Stock	31.15	31.15	31.0875	31.0875	13716.0
2015-03-27 05:30:00	AAPL	Stock	31.1	31.165	31.1	31.1	35700.0
2015-03-27 06:00:00	AAPL	Stock	31.1	31.14	31.1	31.1125	34124.0
2015-03-27 06:30:00	AAPL	Stock	31.145	31.145	31.1	31.125	8516.0
2015-03-27 07:00:00	AAPL	Stock	31.125	31.165	31.1175	31.1175	34708.0
2015-03-27 07:30:00	AAPL	Stock	31.1225	31.1575	31.1225	31.145	17600.0
2015-03-27 08:00:00	AAPL	Stock	31.145	31.165	31.105	31.1525	264116.0
2015-03-27 08:30:00	AAPL	Stock	31.1575	31.16	31.1025	31.13	168552.0
2015-03-27 09:00:00	AAPL	Stock	31.1275	31.1875	31.0625	31.1375	874364.0
2015-03-27 09:30:00	AAPL	Stock	31.14	31.175	30.9775	31.005	19845556.0
2015-03-27 10:00:00	AAPL	Stock	31.0025	31.06	30.85	30.94	14565120.0
2015-03-27 10:30:00	AAPL	Stock	30.9375	31.0675	30.895	31.0535	11646164.0
2015-03-27 11:00:00	AAPL	Stock	31.0525	31.0875	30.9388	30.95	8732508.0
2015-03-27 11:30:00	AAPL	Stock	30.9475	30.995	30.8875	30.9325	6433296.0
2015-03-27 12:00:00	AAPL	Stock	30.9275	30.93	30.835	30.86	8864128.0
2015-03-27 12:30:00	AAPL	Stock	30.86	30.895	30.8	30.87	7235884.0
2015-03-27 13:00:00	AAPL	Stock	30.8725	30.925	30.8375	30.9025	4995652.0
2015-03-27 13:30:00	AAPL	Stock	30.9025	30.9188	30.8425	30.865	4009456.0
2015-03-27 14:00:00	AAPL	Stock	30.865	30.8975	30.8025	30.83	5792732.0
2015-03-27 14:30:00	AAPL	Stock	30.8275	30.835	30.7275	30.7625	10172940.0
2015-03-27 15:00:00	AAPL	Stock	30.7625	30.8425	30.755	30.759	8816812.0
2015-03-27 15:30:00	AAPL	Stock	30.76	30.8875	30.7525	30.81	24361728.0
2015-03-27 16:00:00	AAPL	Stock	30.8125	31.11	30.765	30.8	10267184.0
2015-03-27 16:30:00	AAPL	Stock	30.8	30.8325	30.7875	30.8125	138732.0
2015-03-27 17:00:00	AAPL	Stock	30.805	30.8225	30.8	30.8125	167224.0
2015-03-27 17:30:00	AAPL	Stock	30.8125	30.835	30.7925	30.7925	65328.0
2015-03-27 18:00:00	AAPL	Stock	30.79	30.79	30.775	30.785	48760.0
2015-03-27 18:30:00	AAPL	Stock	30.7875	30.7925	30.775	30.775	64868.0
2015-03-27 19:00:00	AAPL	Stock	30.785	30.7875	30.775	30.78	18060.0
2015-03-27 19:30:00	AAPL	Stock	30.78	30.785	30.7625	30.775	50988.0
2015-03-27 05:30:00	MSFT	Stock	41.22	41.22	41.22	41.22	200.0
2015-03-27 06:00:00	MSFT	Stock	41.16	41.16	41.1	41.1	500.0
2015-03-27 07:00:00	MSFT	Stock	41.21	41.22	41.21	41.22	200.0
2015-03-27 08:00:00	MSFT	Stock	41.23	41.24	41.23	41.24	220.0
2015-03-27 08:30:00	MSFT	Stock	41.24	41.25	41.12	41.18	2670.0
2015-03-27 09:00:00	MSFT	Stock	41.18	41.2	41.06	41.06	16423.0
2015-03-27 09:30:00	MSFT	Stock	41.12	41.43	41.06	41.33	3073046.0
2015-03-27 10:00:00	MSFT	Stock	41.33	41.35	40.98	40.99	3400564.0
2015-03-27 10:30:00	MSFT	Stock	40.99	41.07	40.925	41.027	2114967.0
2015-03-27 11:00:00	MSFT	Stock	41.025	41.12	40.98	41.0	1747002.0
2015-03-27 11:30:00	MSFT	Stock	41.0	41.04	40.925	40.94	1395771.0
2015-03-27 12:00:00	MSFT	Stock	40.935	41.0	40.91	40.97	1470061.0
2015-03-27 12:30:00	MSFT	Stock	40.97	41.01	40.93	40.946	1187736.0
2015-03-27 13:00:00	MSFT	Stock	40.945	40.95	40.88	40.905	907587.0
2015-03-27 13:30:00	MSFT	Stock	40.9	40.97	40.895	40.95	934297.0
2015-03-27 14:00:00	MSFT	Stock	40.96	40.97	40.885	40.946	1258831.0
2015-03-27 14:30:00	MSFT	Stock	40.946	40.96	40.88	40.895	1388671.0
2015-03-27 15:00:00	MSFT	Stock	40.895	40.91	40.83	40.895	1925069.0

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

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