PREVIEW / stock_30min / 2017-06-21

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-06-21.parquet
  size:    1.6 MB
  rows:    80,881
  symbols: 3,021

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-06-21 04:00:00	AAPL	Stock	36.17	36.17	36.0875	36.0875	1200.0
2017-06-21 04:30:00	AAPL	Stock	36.1475	36.175	36.1475	36.175	5620.0
2017-06-21 05:00:00	AAPL	Stock	36.1475	36.1475	36.135	36.135	12260.0
2017-06-21 05:30:00	AAPL	Stock	36.1475	36.1475	36.135	36.135	10764.0
2017-06-21 06:00:00	AAPL	Stock	36.1275	36.1275	36.1	36.1	3156.0
2017-06-21 06:30:00	AAPL	Stock	36.1275	36.1825	36.125	36.1825	6080.0
2017-06-21 07:00:00	AAPL	Stock	36.1875	36.1875	36.165	36.165	7088.0
2017-06-21 07:30:00	AAPL	Stock	36.1525	36.1875	36.15	36.1875	11032.0
2017-06-21 08:00:00	AAPL	Stock	36.2075	36.3325	36.125	36.3275	69556.0
2017-06-21 08:30:00	AAPL	Stock	36.3275	36.3575	36.325	36.345	93028.0
2017-06-21 09:00:00	AAPL	Stock	36.3375	36.4	36.3375	36.385	143492.0
2017-06-21 09:30:00	AAPL	Stock	36.38	36.4325	36.1525	36.1925	9482080.0
2017-06-21 10:00:00	AAPL	Stock	36.1925	36.325	36.1875	36.2825	6056856.0
2017-06-21 10:30:00	AAPL	Stock	36.2825	36.4438	36.2812	36.395	5817792.0
2017-06-21 11:00:00	AAPL	Stock	36.395	36.3975	36.2725	36.3588	4598420.0
2017-06-21 11:30:00	AAPL	Stock	36.36	36.4375	36.355	36.43	3266884.0
2017-06-21 12:00:00	AAPL	Stock	36.43	36.435	36.3125	36.37	2825332.0
2017-06-21 12:30:00	AAPL	Stock	36.37	36.4225	36.3275	36.3545	3443216.0
2017-06-21 13:00:00	AAPL	Stock	36.355	36.4275	36.3475	36.3725	2911620.0
2017-06-21 13:30:00	AAPL	Stock	36.3725	36.405	36.315	36.37	3079632.0
2017-06-21 14:00:00	AAPL	Stock	36.365	36.4175	36.325	36.38	2870300.0
2017-06-21 14:30:00	AAPL	Stock	36.38	36.5	36.3725	36.4475	4437420.0
2017-06-21 15:00:00	AAPL	Stock	36.4487	36.5172	36.44	36.5025	4046736.0
2017-06-21 15:30:00	AAPL	Stock	36.5025	36.513	36.425	36.4675	8329472.0
2017-06-21 16:00:00	AAPL	Stock	36.4675	36.4975	36.3625	36.4875	15986692.0
2017-06-21 16:30:00	AAPL	Stock	36.4875	36.4875	36.3928	36.465	139004.0
2017-06-21 17:00:00	AAPL	Stock	36.465	36.4675	36.4625	36.4625	16120.0
2017-06-21 17:30:00	AAPL	Stock	36.47	36.47	36.46	36.47	6960.0
2017-06-21 18:00:00	AAPL	Stock	36.47	36.475	36.46	36.46	8684.0
2017-06-21 19:00:00	AAPL	Stock	36.47	36.475	36.455	36.455	24652.0
2017-06-21 19:30:00	AAPL	Stock	36.4725	36.475	36.4575	36.4725	9448.0
2017-06-21 05:00:00	MSFT	Stock	69.76	69.76	69.76	69.76	400.0
2017-06-21 06:00:00	MSFT	Stock	69.75	69.75	69.75	69.75	400.0
2017-06-21 06:30:00	MSFT	Stock	69.8	69.8	69.8	69.8	300.0
2017-06-21 07:00:00	MSFT	Stock	70.09	70.09	69.84	69.91	501.0
2017-06-21 07:30:00	MSFT	Stock	69.82	69.82	69.82	69.82	146.0
2017-06-21 08:00:00	MSFT	Stock	69.97	70.0	69.97	70.0	2422.0
2017-06-21 08:30:00	MSFT	Stock	70.05	70.18	70.05	70.1	3173.0
2017-06-21 09:00:00	MSFT	Stock	70.1	70.48	70.04	70.21	26080.0
2017-06-21 09:30:00	MSFT	Stock	70.26	70.43	69.94	69.955	2485860.0
2017-06-21 10:00:00	MSFT	Stock	69.97	70.33	69.965	70.162	1310624.0
2017-06-21 10:30:00	MSFT	Stock	70.17	70.4	70.1	70.34	1126074.0
2017-06-21 11:00:00	MSFT	Stock	70.33	70.35	70.22	70.33	1025216.0
2017-06-21 11:30:00	MSFT	Stock	70.34	70.62	70.325	70.62	960429.0
2017-06-21 12:00:00	MSFT	Stock	70.62	70.62	70.43	70.55	662249.0
2017-06-21 12:30:00	MSFT	Stock	70.545	70.6	70.31	70.35	640741.0
2017-06-21 13:00:00	MSFT	Stock	70.345	70.59	70.34	70.47	637336.0
2017-06-21 13:30:00	MSFT	Stock	70.47	70.56	70.21	70.27	924997.0
2017-06-21 14:00:00	MSFT	Stock	70.27	70.4	70.2	70.225	788042.0
2017-06-21 14:30:00	MSFT	Stock	70.225	70.45	70.21	70.36	1329093.0

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

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