PREVIEW / stock_30min / 2015-09-02

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-09-02.parquet
  size:    1.6 MB
  rows:    83,009
  symbols: 3,479

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-09-02 04:00:00	AAPL	Stock	27.0925	27.4975	27.0925	27.2775	32452.0
2015-09-02 04:30:00	AAPL	Stock	27.305	27.325	27.305	27.325	3172.0
2015-09-02 05:00:00	AAPL	Stock	27.325	27.325	27.2	27.3025	27312.0
2015-09-02 05:30:00	AAPL	Stock	27.3025	27.3225	27.275	27.275	10800.0
2015-09-02 06:00:00	AAPL	Stock	27.3125	27.4	27.3125	27.365	67272.0
2015-09-02 06:30:00	AAPL	Stock	27.345	27.345	27.205	27.235	95092.0
2015-09-02 07:00:00	AAPL	Stock	27.235	27.31	27.2075	27.2575	211736.0
2015-09-02 07:30:00	AAPL	Stock	27.275	27.36	27.225	27.3275	384736.0
2015-09-02 08:00:00	AAPL	Stock	27.25	27.4125	27.225	27.3675	973392.0
2015-09-02 08:30:00	AAPL	Stock	27.3775	27.5	27.3775	27.475	796748.0
2015-09-02 09:00:00	AAPL	Stock	27.4675	27.585	27.4625	27.575	871484.0
2015-09-02 09:30:00	AAPL	Stock	27.5825	27.5825	27.315	27.495	32655764.0
2015-09-02 10:00:00	AAPL	Stock	27.4852	27.66	27.42	27.42	23456720.0
2015-09-02 10:30:00	AAPL	Stock	27.4202	27.4875	27.2828	27.4338	15526044.0
2015-09-02 11:00:00	AAPL	Stock	27.4375	27.575	27.3675	27.5275	13637416.0
2015-09-02 11:30:00	AAPL	Stock	27.5295	27.56	27.4358	27.4982	10453496.0
2015-09-02 12:00:00	AAPL	Stock	27.5	27.5025	27.3625	27.4475	8924444.0
2015-09-02 12:30:00	AAPL	Stock	27.445	27.735	27.4425	27.72	12571768.0
2015-09-02 13:00:00	AAPL	Stock	27.7175	27.815	27.625	27.7875	12064832.0
2015-09-02 13:30:00	AAPL	Stock	27.7875	27.8125	27.6575	27.6865	9075804.0
2015-09-02 14:00:00	AAPL	Stock	27.6842	27.88	27.64	27.7875	13086444.0
2015-09-02 14:30:00	AAPL	Stock	27.7875	27.7938	27.5375	27.7575	15043128.0
2015-09-02 15:00:00	AAPL	Stock	27.755	27.795	27.625	27.77	13818164.0
2015-09-02 15:30:00	AAPL	Stock	27.7725	28.0825	27.7275	28.0825	28248592.0
2015-09-02 16:00:00	AAPL	Stock	28.085	28.095	27.4548	28.0475	20233252.0
2015-09-02 16:30:00	AAPL	Stock	27.5925	28.06	27.5925	28.025	339500.0
2015-09-02 17:00:00	AAPL	Stock	28.035	28.085	28.0125	28.035	164192.0
2015-09-02 17:30:00	AAPL	Stock	28.0325	28.0425	28.0325	28.04	51240.0
2015-09-02 18:00:00	AAPL	Stock	28.0425	28.155	28.0425	28.15	274276.0
2015-09-02 18:30:00	AAPL	Stock	28.15	28.1975	28.125	28.15	205280.0
2015-09-02 19:00:00	AAPL	Stock	28.14	28.15	28.11	28.1225	122964.0
2015-09-02 19:30:00	AAPL	Stock	28.125	28.17	28.115	28.15	90032.0
2015-09-02 04:00:00	MSFT	Stock	42.05	42.49	42.05	42.49	700.0
2015-09-02 05:00:00	MSFT	Stock	42.54	42.54	42.54	42.54	2000.0
2015-09-02 06:00:00	MSFT	Stock	42.3	42.3	42.3	42.3	100.0
2015-09-02 06:30:00	MSFT	Stock	42.3	42.3	42.3	42.3	200.0
2015-09-02 07:30:00	MSFT	Stock	42.28	42.28	42.28	42.28	100.0
2015-09-02 08:00:00	MSFT	Stock	42.28	42.28	42.2	42.21	7680.0
2015-09-02 08:30:00	MSFT	Stock	42.21	42.31	42.21	42.28	2728.0
2015-09-02 09:00:00	MSFT	Stock	42.35	42.38	42.26	42.26	26670.0
2015-09-02 09:30:00	MSFT	Stock	42.26	42.4	42.06	42.23	4277600.0
2015-09-02 10:00:00	MSFT	Stock	42.22	42.24	41.95	41.98	3117239.0
2015-09-02 10:30:00	MSFT	Stock	41.98	42.32	41.88	42.31	2694553.0
2015-09-02 11:00:00	MSFT	Stock	42.305	42.681	42.3	42.64	2943927.0
2015-09-02 11:30:00	MSFT	Stock	42.64	42.73	42.5	42.64	2133365.0
2015-09-02 12:00:00	MSFT	Stock	42.639	42.66	42.5	42.6	1814184.0
2015-09-02 12:30:00	MSFT	Stock	42.6	42.89	42.58	42.87	1514395.0
2015-09-02 13:00:00	MSFT	Stock	42.86	43.12	42.83	43.11	2372794.0
2015-09-02 13:30:00	MSFT	Stock	43.1	43.12	42.97	43.01	1315332.0
2015-09-02 14:00:00	MSFT	Stock	43.014	43.12	42.94	43.033	1498943.0

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

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