PREVIEW / stock_30min / 2016-06-24

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-24.parquet
  size:    1.8 MB
  rows:    90,592
  symbols: 3,289

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-06-24 04:00:00	AAPL	Stock	23.3925	23.3925	23.075	23.21	154484.0
2016-06-24 04:30:00	AAPL	Stock	23.2175	23.3125	23.2175	23.225	269344.0
2016-06-24 05:00:00	AAPL	Stock	23.225	23.31	23.225	23.3	59528.0
2016-06-24 05:30:00	AAPL	Stock	23.3	23.33	23.25	23.2975	75704.0
2016-06-24 06:00:00	AAPL	Stock	23.275	23.4725	23.1375	23.255	434404.0
2016-06-24 06:30:00	AAPL	Stock	23.2875	23.2875	23.155	23.195	178252.0
2016-06-24 07:00:00	AAPL	Stock	23.2	23.3	23.1825	23.225	243220.0
2016-06-24 07:30:00	AAPL	Stock	23.225	23.3625	23.205	23.3225	173064.0
2016-06-24 08:00:00	AAPL	Stock	23.325	23.445	23.13	23.3925	1054804.0
2016-06-24 08:30:00	AAPL	Stock	23.4	23.4175	23.3375	23.35	528936.0
2016-06-24 09:00:00	AAPL	Stock	23.35	23.3775	23.2225	23.2225	1505240.0
2016-06-24 09:30:00	AAPL	Stock	23.2275	23.6638	23.1625	23.5725	38702452.0
2016-06-24 10:00:00	AAPL	Stock	23.565	23.6225	23.4275	23.48	18525892.0
2016-06-24 10:30:00	AAPL	Stock	23.48	23.5225	23.445	23.4575	13286920.0
2016-06-24 11:00:00	AAPL	Stock	23.4565	23.475	23.3925	23.4575	12114752.0
2016-06-24 11:30:00	AAPL	Stock	23.455	23.5925	23.4513	23.53	11221948.0
2016-06-24 12:00:00	AAPL	Stock	23.5325	23.545	23.445	23.4575	8100492.0
2016-06-24 12:30:00	AAPL	Stock	23.4575	23.48	23.3875	23.4125	9187152.0
2016-06-24 13:00:00	AAPL	Stock	23.415	23.475	23.3925	23.4325	7033620.0
2016-06-24 13:30:00	AAPL	Stock	23.4325	23.4575	23.385	23.41	8837500.0
2016-06-24 14:00:00	AAPL	Stock	23.4125	23.435	23.32	23.3388	9301868.0
2016-06-24 14:30:00	AAPL	Stock	23.339	23.36	23.2562	23.3075	12546340.0
2016-06-24 15:00:00	AAPL	Stock	23.3062	23.3435	23.2025	23.235	15458236.0
2016-06-24 15:30:00	AAPL	Stock	23.2325	23.4638	23.2225	23.3425	32229740.0
2016-06-24 16:00:00	AAPL	Stock	23.3362	23.3875	23.3362	23.3523	51545540.0
2016-06-24 16:30:00	AAPL	Stock	23.3478	23.37	23.3478	23.37	899624.0
2016-06-24 17:00:00	AAPL	Stock	23.375	23.3825	23.35	23.3625	109416.0
2016-06-24 17:30:00	AAPL	Stock	23.3625	23.3675	23.35	23.3675	46884.0
2016-06-24 18:00:00	AAPL	Stock	23.355	23.3725	23.35	23.3525	46192.0
2016-06-24 18:30:00	AAPL	Stock	23.3525	23.355	23.325	23.325	82788.0
2016-06-24 19:00:00	AAPL	Stock	23.325	23.3375	23.3	23.3175	58268.0
2016-06-24 19:30:00	AAPL	Stock	23.3175	23.325	23.3025	23.315	93048.0
2016-06-24 04:00:00	MSFT	Stock	51.51	51.51	49.74	49.74	3500.0
2016-06-24 04:30:00	MSFT	Stock	50.0	50.5	50.0	50.5	5805.0
2016-06-24 06:00:00	MSFT	Stock	50.06	50.06	49.98	50.02	2896.0
2016-06-24 06:30:00	MSFT	Stock	50.02	50.02	49.86	50.0	4519.0
2016-06-24 07:00:00	MSFT	Stock	50.33	50.41	49.95	50.1	8949.0
2016-06-24 07:30:00	MSFT	Stock	50.1	50.38	50.1	50.21	15670.0
2016-06-24 08:00:00	MSFT	Stock	50.25	50.45	49.86	50.44	41625.0
2016-06-24 08:30:00	MSFT	Stock	50.44	50.59	50.3	50.45	27822.0
2016-06-24 09:00:00	MSFT	Stock	50.45	50.45	49.81	49.82	194223.0
2016-06-24 09:30:00	MSFT	Stock	49.81	50.76	49.75	50.68	8907079.0
2016-06-24 10:00:00	MSFT	Stock	50.68	50.94	50.29	50.4	4844089.0
2016-06-24 10:30:00	MSFT	Stock	50.4	50.52	50.25	50.26	3083028.0
2016-06-24 11:00:00	MSFT	Stock	50.265	50.35	49.95	50.09	3438710.0
2016-06-24 11:30:00	MSFT	Stock	50.08	50.24	49.955	50.06	3399833.0
2016-06-24 12:00:00	MSFT	Stock	50.07	50.1	49.89	49.96	2572618.0
2016-06-24 12:30:00	MSFT	Stock	49.955	49.98	49.75	49.845	2371193.0
2016-06-24 13:00:00	MSFT	Stock	49.85	49.98	49.77	49.975	1870581.0
2016-06-24 13:30:00	MSFT	Stock	49.98	50.135	49.88	49.945	2059934.0

> showing 50 of 90,592 rows — these rows as CSV

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