PREVIEW / stock_30min / 2017-10-13

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-13.parquet
  size:    1.6 MB
  rows:    80,809
  symbols: 2,947

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
2017-10-13 04:00:00	AAPL	Stock	39.05	39.05	39.05	39.05	400.0
2017-10-13 05:00:00	AAPL	Stock	39.035	39.035	39.0	39.0	3100.0
2017-10-13 05:30:00	AAPL	Stock	39.035	39.035	39.035	39.035	1012.0
2017-10-13 06:00:00	AAPL	Stock	39.05	39.05	39.05	39.05	1600.0
2017-10-13 06:30:00	AAPL	Stock	39.05	39.05	39.05	39.05	3500.0
2017-10-13 07:00:00	AAPL	Stock	39.0625	39.0925	39.0325	39.0925	9380.0
2017-10-13 07:30:00	AAPL	Stock	39.11	39.125	39.075	39.075	101444.0
2017-10-13 08:00:00	AAPL	Stock	39.1	39.125	39.0675	39.1	76068.0
2017-10-13 08:30:00	AAPL	Stock	39.11	39.1875	39.11	39.1575	168988.0
2017-10-13 09:00:00	AAPL	Stock	39.16	39.1875	39.125	39.1875	144992.0
2017-10-13 09:30:00	AAPL	Stock	39.185	39.2392	39.1025	39.175	9377632.0
2017-10-13 10:00:00	AAPL	Stock	39.1775	39.28	39.1775	39.2425	6216120.0
2017-10-13 10:30:00	AAPL	Stock	39.2425	39.285	39.21	39.2738	5029204.0
2017-10-13 11:00:00	AAPL	Stock	39.2725	39.2875	39.2463	39.2675	3168084.0
2017-10-13 11:30:00	AAPL	Stock	39.2688	39.2875	39.2275	39.2605	2328516.0
2017-10-13 12:00:00	AAPL	Stock	39.2625	39.2762	39.23	39.2725	1902368.0
2017-10-13 12:30:00	AAPL	Stock	39.2732	39.2748	39.1375	39.18	6950844.0
2017-10-13 13:00:00	AAPL	Stock	39.18	39.2312	39.17	39.2225	1699312.0
2017-10-13 13:30:00	AAPL	Stock	39.2225	39.2552	39.2175	39.25	2307588.0
2017-10-13 14:00:00	AAPL	Stock	39.2475	39.32	39.2475	39.295	3399176.0
2017-10-13 14:30:00	AAPL	Stock	39.2975	39.3175	39.2675	39.2938	2183772.0
2017-10-13 15:00:00	AAPL	Stock	39.295	39.295	39.2075	39.2312	2318644.0
2017-10-13 15:30:00	AAPL	Stock	39.2325	39.2575	39.2025	39.2525	6140544.0
2017-10-13 16:00:00	AAPL	Stock	39.2475	39.25	39.235	39.2475	4822908.0
2017-10-13 16:30:00	AAPL	Stock	39.235	39.245	39.23	39.2375	30804.0
2017-10-13 17:00:00	AAPL	Stock	39.245	39.245	39.2175	39.23	12244.0
2017-10-13 17:30:00	AAPL	Stock	39.2325	39.2475	39.2325	39.245	24800.0
2017-10-13 18:00:00	AAPL	Stock	39.2325	39.25	39.2275	39.2425	35020.0
2017-10-13 18:30:00	AAPL	Stock	39.2475	39.25	39.24	39.25	7136.0
2017-10-13 19:00:00	AAPL	Stock	39.2425	39.2425	39.24	39.24	8000.0
2017-10-13 19:30:00	AAPL	Stock	39.24	39.2475	39.2375	39.2375	15528.0
2017-10-13 04:00:00	MSFT	Stock	77.22	77.22	77.22	77.22	100.0
2017-10-13 04:30:00	MSFT	Stock	77.22	77.22	77.22	77.22	110.0
2017-10-13 05:30:00	MSFT	Stock	77.35	77.35	77.35	77.35	5051.0
2017-10-13 06:00:00	MSFT	Stock	77.5	77.5	77.5	77.5	137.0
2017-10-13 06:30:00	MSFT	Stock	77.35	77.35	77.35	77.35	1391.0
2017-10-13 07:00:00	MSFT	Stock	77.35	77.35	77.35	77.35	3300.0
2017-10-13 08:00:00	MSFT	Stock	77.3	77.35	77.3	77.35	2011.0
2017-10-13 08:30:00	MSFT	Stock	77.35	77.41	77.35	77.4	3012.0
2017-10-13 09:00:00	MSFT	Stock	77.41	77.54	77.35	77.54	16879.0
2017-10-13 09:30:00	MSFT	Stock	77.59	77.87	77.52	77.6	2138845.0
2017-10-13 10:00:00	MSFT	Stock	77.605	77.66	77.495	77.64	944272.0
2017-10-13 10:30:00	MSFT	Stock	77.63	77.66	77.352	77.38	685170.0
2017-10-13 11:00:00	MSFT	Stock	77.39	77.53	77.365	77.37	776600.0
2017-10-13 11:30:00	MSFT	Stock	77.38	77.42	77.29	77.39	454829.0
2017-10-13 12:00:00	MSFT	Stock	77.4	77.47	77.33	77.465	422179.0
2017-10-13 12:30:00	MSFT	Stock	77.46	77.51	77.4	77.49	490234.0
2017-10-13 13:00:00	MSFT	Stock	77.48	77.56	77.47	77.52	355594.0
2017-10-13 13:30:00	MSFT	Stock	77.52	77.57	77.38	77.4	563013.0
2017-10-13 14:00:00	MSFT	Stock	77.4	77.53	77.38	77.51	470174.0

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

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