PREVIEW / stock_30min / 2016-02-19

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-19.parquet
  size:    1.5 MB
  rows:    80,759
  symbols: 3,351

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
2016-02-19 04:00:00	AAPL	Stock	24.02	24.02	24.02	24.02	720.0
2016-02-19 06:30:00	AAPL	Stock	24.065	24.07	23.9525	23.9575	26392.0
2016-02-19 07:00:00	AAPL	Stock	23.96	24.0225	23.96	24.0	12116.0
2016-02-19 07:30:00	AAPL	Stock	24.0	24.025	23.9875	24.025	14208.0
2016-02-19 08:00:00	AAPL	Stock	24.0275	24.0625	23.9775	24.0425	54348.0
2016-02-19 08:30:00	AAPL	Stock	24.0425	24.075	24.0125	24.015	216240.0
2016-02-19 09:00:00	AAPL	Stock	24.0025	24.0475	23.9775	23.9925	347664.0
2016-02-19 09:30:00	AAPL	Stock	24.0	24.145	23.95	24.0238	23580044.0
2016-02-19 10:00:00	AAPL	Stock	24.0225	24.1275	23.9625	24.1162	11393316.0
2016-02-19 10:30:00	AAPL	Stock	24.116	24.1725	24.0525	24.0912	8915112.0
2016-02-19 11:00:00	AAPL	Stock	24.09	24.1525	24.03	24.15	7209232.0
2016-02-19 11:30:00	AAPL	Stock	24.1475	24.19	24.0625	24.065	8771312.0
2016-02-19 12:00:00	AAPL	Stock	24.065	24.12	24.0625	24.0688	3645820.0
2016-02-19 12:30:00	AAPL	Stock	24.07	24.1	24.0275	24.055	4297632.0
2016-02-19 13:00:00	AAPL	Stock	24.0525	24.0738	24.02	24.0662	4169384.0
2016-02-19 13:30:00	AAPL	Stock	24.0675	24.1012	24.0225	24.065	5277528.0
2016-02-19 14:00:00	AAPL	Stock	24.0655	24.0975	24.0325	24.0475	5561480.0
2016-02-19 14:30:00	AAPL	Stock	24.0475	24.0688	23.9925	24.0	5992388.0
2016-02-19 15:00:00	AAPL	Stock	24.0	24.0908	23.995	24.0675	8648400.0
2016-02-19 15:30:00	AAPL	Stock	24.07	24.0978	23.9875	24.0075	14774152.0
2016-02-19 16:00:00	AAPL	Stock	24.01	24.025	23.995	24.0	10017096.0
2016-02-19 16:30:00	AAPL	Stock	23.9925	24.005	23.99	24.0	168708.0
2016-02-19 17:00:00	AAPL	Stock	24.0	24.01	23.96	23.96	2920552.0
2016-02-19 17:30:00	AAPL	Stock	23.9625	23.965	23.9525	23.9525	56748.0
2016-02-19 18:00:00	AAPL	Stock	23.955	23.965	23.95	23.9625	93284.0
2016-02-19 18:30:00	AAPL	Stock	23.965	23.9675	23.96	23.96	31556.0
2016-02-19 19:00:00	AAPL	Stock	23.96	23.9725	23.96	23.9725	27260.0
2016-02-19 19:30:00	AAPL	Stock	23.9725	23.975	23.965	23.975	48264.0
2016-02-19 08:00:00	MSFT	Stock	51.97	51.97	51.97	51.97	1896.0
2016-02-19 08:30:00	MSFT	Stock	52.01	52.04	51.87	51.88	19450.0
2016-02-19 09:00:00	MSFT	Stock	51.85	52.09	51.81	51.95	196801.0
2016-02-19 09:30:00	MSFT	Stock	51.95	52.28	51.63	52.13	5441139.0
2016-02-19 10:00:00	MSFT	Stock	52.12	52.27	52.0	52.15	2285071.0
2016-02-19 10:30:00	MSFT	Stock	52.15	52.26	52.04	52.04	1159084.0
2016-02-19 11:00:00	MSFT	Stock	52.04	52.16	51.92	52.1	1542725.0
2016-02-19 11:30:00	MSFT	Stock	52.1	52.27	51.95	52.01	1575408.0
2016-02-19 12:00:00	MSFT	Stock	52.01	52.06	51.87	51.915	956231.0
2016-02-19 12:30:00	MSFT	Stock	51.91	52.07	51.88	51.92	928327.0
2016-02-19 13:00:00	MSFT	Stock	51.92	51.99	51.85	51.885	1160550.0
2016-02-19 13:30:00	MSFT	Stock	51.88	51.95	51.82	51.95	1043844.0
2016-02-19 14:00:00	MSFT	Stock	51.95	51.995	51.8	51.825	1501397.0
2016-02-19 14:30:00	MSFT	Stock	51.825	51.83	51.53	51.59	1446554.0
2016-02-19 15:00:00	MSFT	Stock	51.59	51.86	51.56	51.845	1481480.0
2016-02-19 15:30:00	MSFT	Stock	51.845	51.95	51.74	51.81	3965192.0
2016-02-19 16:00:00	MSFT	Stock	51.82	51.96	51.71	51.96	2475929.0
2016-02-19 16:30:00	MSFT	Stock	51.85	51.924	51.81	51.924	91200.0
2016-02-19 17:30:00	MSFT	Stock	51.83	51.83	51.83	51.83	100.0
2016-02-19 18:00:00	MSFT	Stock	51.87	51.87	51.84	51.84	400.0
2016-02-19 19:30:00	MSFT	Stock	51.83	51.87	51.83	51.87	270.0
2016-02-19 08:00:00	NVDA	Stock	0.7438	0.75	0.7438	0.75	68000.0

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

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