PREVIEW / stock_30min / 2017-03-15

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-03-15.parquet
  size:    1.6 MB
  rows:    82,643
  symbols: 3,082

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
2017-03-15 04:00:00	AAPL	Stock	34.7925	34.7925	34.7925	34.7925	3120.0
2017-03-15 05:30:00	AAPL	Stock	34.83	34.83	34.7825	34.7825	3080.0
2017-03-15 06:00:00	AAPL	Stock	34.8125	34.8425	34.8125	34.8125	10432.0
2017-03-15 06:30:00	AAPL	Stock	34.84	34.8425	34.8175	34.8225	8564.0
2017-03-15 07:00:00	AAPL	Stock	34.8125	34.82	34.8125	34.82	11800.0
2017-03-15 07:30:00	AAPL	Stock	34.8175	34.825	34.8125	34.8225	33296.0
2017-03-15 08:00:00	AAPL	Stock	34.8125	34.8275	34.8	34.81	49584.0
2017-03-15 08:30:00	AAPL	Stock	34.8175	34.825	34.805	34.805	34872.0
2017-03-15 09:00:00	AAPL	Stock	34.81	34.8875	34.795	34.865	195528.0
2017-03-15 09:30:00	AAPL	Stock	34.865	34.88	34.7562	34.815	9652108.0
2017-03-15 10:00:00	AAPL	Stock	34.8125	34.8375	34.795	34.83	3711520.0
2017-03-15 10:30:00	AAPL	Stock	34.8312	34.8375	34.78	34.8038	2913248.0
2017-03-15 11:00:00	AAPL	Stock	34.8025	34.8675	34.7925	34.855	2687960.0
2017-03-15 11:30:00	AAPL	Stock	34.8562	34.885	34.8475	34.88	2686476.0
2017-03-15 12:00:00	AAPL	Stock	34.88	34.9825	34.855	34.965	4676076.0
2017-03-15 12:30:00	AAPL	Stock	34.9625	35.035	34.9625	34.986	10717404.0
2017-03-15 13:00:00	AAPL	Stock	34.9875	35.0125	34.945	34.97	3392132.0
2017-03-15 13:30:00	AAPL	Stock	34.97	34.9875	34.955	34.9775	2769776.0
2017-03-15 14:00:00	AAPL	Stock	34.9775	35.1	34.9325	35.0375	10900284.0
2017-03-15 14:30:00	AAPL	Stock	35.0375	35.0888	34.9828	35.08	5687688.0
2017-03-15 15:00:00	AAPL	Stock	35.08	35.1588	35.06	35.1575	6575972.0
2017-03-15 15:30:00	AAPL	Stock	35.1575	35.1875	35.1	35.1125	12002876.0
2017-03-15 16:00:00	AAPL	Stock	35.1075	35.14	35.0625	35.1325	8416716.0
2017-03-15 16:30:00	AAPL	Stock	35.1275	35.1275	35.105	35.105	55876.0
2017-03-15 17:00:00	AAPL	Stock	35.1175	35.1225	35.1125	35.1225	128772.0
2017-03-15 17:30:00	AAPL	Stock	35.1275	35.1275	35.1125	35.1125	4600.0
2017-03-15 18:00:00	AAPL	Stock	35.1125	35.1275	35.105	35.1275	8744.0
2017-03-15 18:30:00	AAPL	Stock	35.1275	35.1275	35.1175	35.1275	17032.0
2017-03-15 19:00:00	AAPL	Stock	35.14	35.1425	35.1375	35.1425	8344.0
2017-03-15 19:30:00	AAPL	Stock	35.1375	35.1425	35.125	35.13	13292.0
2017-03-15 07:00:00	MSFT	Stock	64.45	64.45	64.45	64.45	100.0
2017-03-15 08:00:00	MSFT	Stock	64.54	64.54	64.54	64.54	270.0
2017-03-15 08:30:00	MSFT	Stock	64.57	64.6	64.48	64.48	1618.0
2017-03-15 09:00:00	MSFT	Stock	64.6	64.6	64.45	64.5	9716.0
2017-03-15 09:30:00	MSFT	Stock	64.5	64.58	64.355	64.46	1459652.0
2017-03-15 10:00:00	MSFT	Stock	64.45	64.46	64.25	64.405	926841.0
2017-03-15 10:30:00	MSFT	Stock	64.41	64.425	64.34	64.4	779894.0
2017-03-15 11:00:00	MSFT	Stock	64.4	64.543	64.39	64.535	721409.0
2017-03-15 11:30:00	MSFT	Stock	64.535	64.58	64.48	64.565	719037.0
2017-03-15 12:00:00	MSFT	Stock	64.565	64.63	64.55	64.585	553009.0
2017-03-15 12:30:00	MSFT	Stock	64.58	64.71	64.57	64.65	542125.0
2017-03-15 13:00:00	MSFT	Stock	64.645	64.67	64.49	64.54	796020.0
2017-03-15 13:30:00	MSFT	Stock	64.545	64.56	64.475	64.52	623194.0
2017-03-15 14:00:00	MSFT	Stock	64.515	64.92	64.515	64.63	2534929.0
2017-03-15 14:30:00	MSFT	Stock	64.63	64.8	64.6	64.76	1209427.0
2017-03-15 15:00:00	MSFT	Stock	64.76	64.86	64.72	64.825	1088610.0
2017-03-15 15:30:00	MSFT	Stock	64.82	64.9	64.71	64.73	2135957.0
2017-03-15 16:00:00	MSFT	Stock	64.71	64.75	64.7	64.75	4855826.0
2017-03-15 16:30:00	MSFT	Stock	64.75	64.77	64.75	64.77	17538.0
2017-03-15 17:00:00	MSFT	Stock	64.69	64.75	64.675	64.7	4212382.0

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

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