PREVIEW / stock_30min / 2016-05-20

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-05-20.parquet
  size:    1.5 MB
  rows:    80,084
  symbols: 3,293

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-05-20 04:00:00	AAPL	Stock	23.675	23.7225	23.675	23.7	8556.0
2016-05-20 04:30:00	AAPL	Stock	23.7	23.7	23.7	23.7	984.0
2016-05-20 05:00:00	AAPL	Stock	23.655	23.655	23.65	23.65	6960.0
2016-05-20 05:30:00	AAPL	Stock	23.6925	23.6925	23.6775	23.6775	6148.0
2016-05-20 06:00:00	AAPL	Stock	23.6775	23.6775	23.6675	23.675	3568.0
2016-05-20 06:30:00	AAPL	Stock	23.6675	23.67	23.6675	23.67	2000.0
2016-05-20 07:30:00	AAPL	Stock	23.6425	23.66	23.63	23.63	13468.0
2016-05-20 08:00:00	AAPL	Stock	23.65	23.675	23.58	23.6425	171640.0
2016-05-20 08:30:00	AAPL	Stock	23.63	23.6625	23.6175	23.6225	140160.0
2016-05-20 09:00:00	AAPL	Stock	23.6275	23.675	23.6	23.675	563884.0
2016-05-20 09:30:00	AAPL	Stock	23.675	23.775	23.63	23.75	22506416.0
2016-05-20 10:00:00	AAPL	Stock	23.7475	23.7925	23.705	23.7138	11029696.0
2016-05-20 10:30:00	AAPL	Stock	23.7148	23.7825	23.685	23.72	9028832.0
2016-05-20 11:00:00	AAPL	Stock	23.7175	23.775	23.715	23.7535	6334696.0
2016-05-20 11:30:00	AAPL	Stock	23.755	23.8	23.75	23.7902	6687724.0
2016-05-20 12:00:00	AAPL	Stock	23.7918	23.81	23.77	23.8075	5121704.0
2016-05-20 12:30:00	AAPL	Stock	23.81	23.8475	23.785	23.8375	5828008.0
2016-05-20 13:00:00	AAPL	Stock	23.8375	23.8575	23.8125	23.8275	5667036.0
2016-05-20 13:30:00	AAPL	Stock	23.8275	23.828	23.735	23.7725	7927848.0
2016-05-20 14:00:00	AAPL	Stock	23.7725	23.7958	23.7525	23.789	3752644.0
2016-05-20 14:30:00	AAPL	Stock	23.7878	23.7962	23.7602	23.7775	3540996.0
2016-05-20 15:00:00	AAPL	Stock	23.78	23.78	23.7325	23.7495	5756872.0
2016-05-20 15:30:00	AAPL	Stock	23.7488	23.8125	23.745	23.805	12604712.0
2016-05-20 16:00:00	AAPL	Stock	23.805	23.81	23.78	23.785	10244004.0
2016-05-20 16:30:00	AAPL	Stock	23.7875	23.8	23.7775	23.8	63280.0
2016-05-20 17:00:00	AAPL	Stock	23.7975	23.7975	23.775	23.775	53036.0
2016-05-20 17:30:00	AAPL	Stock	23.7725	23.78	23.77	23.78	29152.0
2016-05-20 18:00:00	AAPL	Stock	23.7775	23.78	23.77	23.78	28720.0
2016-05-20 18:30:00	AAPL	Stock	23.775	23.805	23.775	23.78	660892.0
2016-05-20 19:00:00	AAPL	Stock	23.7775	23.7875	23.7775	23.7875	21996.0
2016-05-20 19:30:00	AAPL	Stock	23.785	23.7875	23.7775	23.7825	18928.0
2016-05-20 04:00:00	MSFT	Stock	50.32	50.32	50.32	50.32	100.0
2016-05-20 08:00:00	MSFT	Stock	50.45	50.45	50.4	50.45	1600.0
2016-05-20 08:30:00	MSFT	Stock	50.49	50.51	50.45	50.51	2422.0
2016-05-20 09:00:00	MSFT	Stock	50.52	50.64	50.37	50.49	318094.0
2016-05-20 09:30:00	MSFT	Stock	50.49	50.975	50.4	50.97	4776090.0
2016-05-20 10:00:00	MSFT	Stock	50.97	51.22	50.83	50.98	2810419.0
2016-05-20 10:30:00	MSFT	Stock	50.98	51.2	50.98	51.13	1391917.0
2016-05-20 11:00:00	MSFT	Stock	51.12	51.16	50.96	51.02	918759.0
2016-05-20 11:30:00	MSFT	Stock	51.03	51.18	51.02	51.125	1033888.0
2016-05-20 12:00:00	MSFT	Stock	51.12	51.13	50.955	50.986	968113.0
2016-05-20 12:30:00	MSFT	Stock	50.99	51.03	50.91	50.92	571719.0
2016-05-20 13:00:00	MSFT	Stock	50.92	50.97	50.825	50.853	755895.0
2016-05-20 13:30:00	MSFT	Stock	50.855	50.855	50.74	50.77	717138.0
2016-05-20 14:00:00	MSFT	Stock	50.769	50.79	50.71	50.79	1123311.0
2016-05-20 14:30:00	MSFT	Stock	50.785	50.8	50.64	50.67	789870.0
2016-05-20 15:00:00	MSFT	Stock	50.67	50.68	50.495	50.565	1333877.0
2016-05-20 15:30:00	MSFT	Stock	50.56	50.67	50.55	50.63	2064714.0
2016-05-20 16:00:00	MSFT	Stock	50.63	50.65	50.58	50.62	2572169.0
2016-05-20 16:30:00	MSFT	Stock	50.869	50.869	50.869	50.869	43000.0

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

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