PREVIEW / stock_30min / 2016-04-22

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-04-22.parquet
  size:    1.6 MB
  rows:    81,052
  symbols: 3,323

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-04-22 04:30:00	AAPL	Stock	26.32	26.32	26.32	26.32	400.0
2016-04-22 05:00:00	AAPL	Stock	26.3075	26.3075	26.3075	26.3075	416.0
2016-04-22 05:30:00	AAPL	Stock	26.3625	26.3625	26.3625	26.3625	400.0
2016-04-22 06:00:00	AAPL	Stock	26.3	26.325	26.3	26.3	39536.0
2016-04-22 06:30:00	AAPL	Stock	26.3	26.3175	26.3	26.3175	43316.0
2016-04-22 07:00:00	AAPL	Stock	26.3375	26.3725	26.3125	26.355	36952.0
2016-04-22 07:30:00	AAPL	Stock	26.35	26.35	26.3125	26.315	36476.0
2016-04-22 08:00:00	AAPL	Stock	26.3275	26.3725	26.3125	26.33	131920.0
2016-04-22 08:30:00	AAPL	Stock	26.3425	26.3625	26.335	26.34	87780.0
2016-04-22 09:00:00	AAPL	Stock	26.345	26.375	26.255	26.255	333820.0
2016-04-22 09:30:00	AAPL	Stock	26.255	26.6025	26.25	26.6	18328876.0
2016-04-22 10:00:00	AAPL	Stock	26.6025	26.62	26.35	26.3642	11344452.0
2016-04-22 10:30:00	AAPL	Stock	26.3625	26.3875	26.2525	26.2788	11568168.0
2016-04-22 11:00:00	AAPL	Stock	26.2805	26.325	26.2	26.2425	9674260.0
2016-04-22 11:30:00	AAPL	Stock	26.2425	26.3495	26.24	26.3425	5413320.0
2016-04-22 12:00:00	AAPL	Stock	26.3425	26.345	26.245	26.2525	4712508.0
2016-04-22 12:30:00	AAPL	Stock	26.255	26.2575	26.19	26.2045	5126856.0
2016-04-22 13:00:00	AAPL	Stock	26.2057	26.2225	26.155	26.1802	7602324.0
2016-04-22 13:30:00	AAPL	Stock	26.181	26.2925	26.17	26.2685	6596940.0
2016-04-22 14:00:00	AAPL	Stock	26.2675	26.38	26.2525	26.3575	7434240.0
2016-04-22 14:30:00	AAPL	Stock	26.3575	26.3975	26.3225	26.3862	5385264.0
2016-04-22 15:00:00	AAPL	Stock	26.3862	26.4145	26.3352	26.3912	6420816.0
2016-04-22 15:30:00	AAPL	Stock	26.3888	26.425	26.3682	26.42	10640044.0
2016-04-22 16:00:00	AAPL	Stock	26.42	26.42	26.3745	26.405	12719840.0
2016-04-22 16:30:00	AAPL	Stock	26.41	26.4175	26.4	26.4175	34252.0
2016-04-22 17:00:00	AAPL	Stock	26.4175	26.4275	26.405	26.4275	75476.0
2016-04-22 17:30:00	AAPL	Stock	26.4175	26.4325	26.4075	26.4125	22160.0
2016-04-22 18:00:00	AAPL	Stock	26.41	26.435	26.41	26.435	14396.0
2016-04-22 18:30:00	AAPL	Stock	26.415	26.435	26.4125	26.415	8284.0
2016-04-22 19:00:00	AAPL	Stock	26.4125	26.425	26.395	26.395	11204.0
2016-04-22 19:30:00	AAPL	Stock	26.4075	26.42	26.4025	26.4025	39056.0
2016-04-22 04:00:00	MSFT	Stock	53.0	53.16	53.0	53.16	1110.0
2016-04-22 04:30:00	MSFT	Stock	53.15	53.15	53.1	53.1	2800.0
2016-04-22 05:00:00	MSFT	Stock	53.15	53.16	53.15	53.16	450.0
2016-04-22 05:30:00	MSFT	Stock	53.15	53.15	53.08	53.12	8770.0
2016-04-22 06:00:00	MSFT	Stock	53.1	53.19	53.0	53.18	19788.0
2016-04-22 06:30:00	MSFT	Stock	53.16	53.32	53.15	53.3	11646.0
2016-04-22 07:00:00	MSFT	Stock	53.35	53.44	53.2	53.29	38701.0
2016-04-22 07:30:00	MSFT	Stock	53.29	53.3	53.05	53.16	77817.0
2016-04-22 08:00:00	MSFT	Stock	53.14	53.4	52.81	52.87	795810.0
2016-04-22 08:30:00	MSFT	Stock	52.87	52.88	52.62	52.68	388739.0
2016-04-22 09:00:00	MSFT	Stock	52.66	52.75	51.91	51.96	1999170.0
2016-04-22 09:30:00	MSFT	Stock	51.96	52.43	51.6	51.73	22587622.0
2016-04-22 10:00:00	MSFT	Stock	51.725	51.75	50.77	51.2	16840435.0
2016-04-22 10:30:00	MSFT	Stock	51.2	51.67	51.04	51.56	11150578.0
2016-04-22 11:00:00	MSFT	Stock	51.57	52.005	51.42	51.755	10735446.0
2016-04-22 11:30:00	MSFT	Stock	51.755	52.225	51.755	52.1	7255832.0
2016-04-22 12:00:00	MSFT	Stock	52.1	52.15	51.83	51.845	4705627.0
2016-04-22 12:30:00	MSFT	Stock	51.85	52.05	51.56	51.71	4794175.0
2016-04-22 13:00:00	MSFT	Stock	51.7	51.88	51.65	51.686	3708167.0

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

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