PREVIEW / stock_30min / 2014-07-15

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-07-15.parquet
  size:    1.6 MB
  rows:    83,146
  symbols: 3,586

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
2014-07-15 04:00:00	AAPL	Stock	24.1875	24.2025	24.1875	24.195	13216.0
2014-07-15 04:30:00	AAPL	Stock	24.18	24.18	24.1675	24.1675	12336.0
2014-07-15 05:00:00	AAPL	Stock	24.1675	24.1675	24.1675	24.1675	400.0
2014-07-15 05:30:00	AAPL	Stock	24.1675	24.1675	24.1675	24.1675	2180.0
2014-07-15 06:00:00	AAPL	Stock	24.1775	24.1775	24.17	24.17	6440.0
2014-07-15 06:30:00	AAPL	Stock	24.175	24.175	24.15	24.155	21656.0
2014-07-15 07:00:00	AAPL	Stock	24.1625	24.2375	24.16	24.2275	74996.0
2014-07-15 07:30:00	AAPL	Stock	24.2275	24.23	24.2025	24.2125	57688.0
2014-07-15 08:00:00	AAPL	Stock	24.2075	24.2375	24.075	24.1875	416776.0
2014-07-15 08:30:00	AAPL	Stock	24.1875	24.2025	24.18	24.2	161424.0
2014-07-15 09:00:00	AAPL	Stock	24.2	24.225	24.19	24.195	322376.0
2014-07-15 09:30:00	AAPL	Stock	24.2	24.2125	24.0625	24.1075	24404100.0
2014-07-15 10:00:00	AAPL	Stock	24.1075	24.125	23.9775	24.0	17427360.0
2014-07-15 10:30:00	AAPL	Stock	24.0025	24.01	23.875	23.9	15787316.0
2014-07-15 11:00:00	AAPL	Stock	23.9	23.9925	23.86	23.9348	11065900.0
2014-07-15 11:30:00	AAPL	Stock	23.935	23.94	23.81	23.81	9922120.0
2014-07-15 12:00:00	AAPL	Stock	23.81	23.8725	23.7575	23.865	12272024.0
2014-07-15 12:30:00	AAPL	Stock	23.865	23.95	23.85	23.8925	7759852.0
2014-07-15 13:00:00	AAPL	Stock	23.8938	23.945	23.8675	23.9025	8267976.0
2014-07-15 13:30:00	AAPL	Stock	23.905	23.9225	23.875	23.875	5810040.0
2014-07-15 14:00:00	AAPL	Stock	23.8762	23.9075	23.855	23.8925	5345444.0
2014-07-15 14:30:00	AAPL	Stock	23.8925	23.8962	23.855	23.88	5140080.0
2014-07-15 15:00:00	AAPL	Stock	23.88	23.88	23.8325	23.865	6930380.0
2014-07-15 15:30:00	AAPL	Stock	23.8638	23.8675	23.8275	23.8275	15937276.0
2014-07-15 16:00:00	AAPL	Stock	23.83	23.9388	23.8292	23.8675	11604120.0
2014-07-15 16:30:00	AAPL	Stock	23.8675	24.29	23.8252	24.2175	3895156.0
2014-07-15 17:00:00	AAPL	Stock	24.215	24.24	24.1775	24.235	1404500.0
2014-07-15 17:30:00	AAPL	Stock	24.235	24.235	24.1475	24.19	549332.0
2014-07-15 18:00:00	AAPL	Stock	24.1925	24.2225	24.1825	24.2225	511060.0
2014-07-15 18:30:00	AAPL	Stock	24.2225	24.2225	24.1875	24.1925	203424.0
2014-07-15 19:00:00	AAPL	Stock	24.1925	24.2125	23.83	24.19	306012.0
2014-07-15 19:30:00	AAPL	Stock	24.19	24.2125	24.1775	24.2	170760.0
2014-07-15 06:00:00	MSFT	Stock	42.19	42.4	42.19	42.19	540.0
2014-07-15 06:30:00	MSFT	Stock	42.19	42.19	42.19	42.19	700.0
2014-07-15 07:00:00	MSFT	Stock	42.25	42.27	42.25	42.27	200.0
2014-07-15 07:30:00	MSFT	Stock	42.3	42.35	42.3	42.33	2650.0
2014-07-15 08:00:00	MSFT	Stock	42.31	42.37	42.31	42.32	2300.0
2014-07-15 08:30:00	MSFT	Stock	42.32	42.37	42.32	42.37	9930.0
2014-07-15 09:00:00	MSFT	Stock	42.35	42.37	42.28	42.3	13751.0
2014-07-15 09:30:00	MSFT	Stock	42.32	42.47	42.26	42.33	3744740.0
2014-07-15 10:00:00	MSFT	Stock	42.33	42.4	42.29	42.343	2414669.0
2014-07-15 10:30:00	MSFT	Stock	42.34	42.377	42.17	42.25	2093150.0
2014-07-15 11:00:00	MSFT	Stock	42.251	42.26	42.15	42.22	1979428.0
2014-07-15 11:30:00	MSFT	Stock	42.22	42.285	42.08	42.1	1976834.0
2014-07-15 12:00:00	MSFT	Stock	42.1	42.15	42.03	42.06	1470790.0
2014-07-15 12:30:00	MSFT	Stock	42.07	42.23	42.03	42.151	1010882.0
2014-07-15 13:00:00	MSFT	Stock	42.15	42.2	42.11	42.17	995213.0
2014-07-15 13:30:00	MSFT	Stock	42.165	42.3	42.165	42.258	921317.0
2014-07-15 14:00:00	MSFT	Stock	42.26	42.4	42.24	42.33	1331721.0
2014-07-15 14:30:00	MSFT	Stock	42.324	42.35	42.28	42.315	794781.0

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

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