PREVIEW / stock_30min / 2015-01-23

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-01-23.parquet
  size:    1.6 MB
  rows:    82,034
  symbols: 3,520

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
2015-01-23 04:00:00	AAPL	Stock	28.1	28.1375	28.0875	28.1	24104.0
2015-01-23 04:30:00	AAPL	Stock	28.1125	28.1125	28.02	28.075	10000.0
2015-01-23 05:00:00	AAPL	Stock	28.05	28.0775	28.05	28.05	22528.0
2015-01-23 05:30:00	AAPL	Stock	28.065	28.0675	28.065	28.0675	4000.0
2015-01-23 06:00:00	AAPL	Stock	28.0675	28.0675	28.0425	28.05	13288.0
2015-01-23 06:30:00	AAPL	Stock	28.0575	28.105	28.035	28.0575	25360.0
2015-01-23 07:00:00	AAPL	Stock	28.0575	28.1025	28.0075	28.1	52904.0
2015-01-23 07:30:00	AAPL	Stock	28.075	28.15	28.075	28.14	258976.0
2015-01-23 08:00:00	AAPL	Stock	28.1375	28.175	28.1	28.17	362876.0
2015-01-23 08:30:00	AAPL	Stock	28.1675	28.1725	28.015	28.065	494460.0
2015-01-23 09:00:00	AAPL	Stock	28.065	28.095	27.955	28.085	661084.0
2015-01-23 09:30:00	AAPL	Stock	28.07	28.21	27.8825	28.165	26928208.0
2015-01-23 10:00:00	AAPL	Stock	28.165	28.1675	28.0025	28.065	12217024.0
2015-01-23 10:30:00	AAPL	Stock	28.065	28.0822	27.9425	28.03	10337148.0
2015-01-23 11:00:00	AAPL	Stock	28.0275	28.11	28.0025	28.105	6144036.0
2015-01-23 11:30:00	AAPL	Stock	28.105	28.205	28.0925	28.2	10056600.0
2015-01-23 12:00:00	AAPL	Stock	28.2	28.2275	28.1288	28.1375	7690652.0
2015-01-23 12:30:00	AAPL	Stock	28.1375	28.24	28.1375	28.2395	7249700.0
2015-01-23 13:00:00	AAPL	Stock	28.2388	28.3412	28.21	28.3175	10941716.0
2015-01-23 13:30:00	AAPL	Stock	28.315	28.4375	28.3125	28.405	12593192.0
2015-01-23 14:00:00	AAPL	Stock	28.405	28.4275	28.2875	28.3435	9621896.0
2015-01-23 14:30:00	AAPL	Stock	28.3425	28.38	28.23	28.2762	10050004.0
2015-01-23 15:00:00	AAPL	Stock	28.2762	28.2825	28.2025	28.2488	10257080.0
2015-01-23 15:30:00	AAPL	Stock	28.2462	28.2575	28.2	28.2475	19041196.0
2015-01-23 16:00:00	AAPL	Stock	28.245	28.26	28.0745	28.2125	15720768.0
2015-01-23 16:30:00	AAPL	Stock	28.215	28.245	28.1845	28.2175	1418040.0
2015-01-23 17:00:00	AAPL	Stock	28.2175	28.225	28.2	28.2225	53472.0
2015-01-23 17:30:00	AAPL	Stock	28.2175	28.22	28.2125	28.22	36400.0
2015-01-23 18:00:00	AAPL	Stock	28.22	28.245	28.2125	28.215	42300.0
2015-01-23 18:30:00	AAPL	Stock	28.215	28.22	28.205	28.2175	22216.0
2015-01-23 19:00:00	AAPL	Stock	28.2175	28.235	28.2125	28.235	9108.0
2015-01-23 19:30:00	AAPL	Stock	28.22	28.2375	28.22	28.235	51660.0
2015-01-23 04:00:00	MSFT	Stock	47.24	47.24	47.23	47.23	600.0
2015-01-23 04:30:00	MSFT	Stock	47.26	47.26	47.21	47.21	900.0
2015-01-23 05:00:00	MSFT	Stock	47.25	47.26	47.25	47.26	300.0
2015-01-23 05:30:00	MSFT	Stock	47.36	47.41	47.36	47.41	700.0
2015-01-23 06:00:00	MSFT	Stock	47.41	47.41	47.41	47.41	1000.0
2015-01-23 06:30:00	MSFT	Stock	47.44	47.44	47.35	47.35	600.0
2015-01-23 07:00:00	MSFT	Stock	47.31	47.31	47.3	47.3	1000.0
2015-01-23 07:30:00	MSFT	Stock	47.34	47.38	47.3	47.32	1595.0
2015-01-23 08:00:00	MSFT	Stock	47.3	47.43	47.29	47.36	7660.0
2015-01-23 08:30:00	MSFT	Stock	47.39	47.4	47.26	47.34	8550.0
2015-01-23 09:00:00	MSFT	Stock	47.34	47.45	47.24	47.45	194627.0
2015-01-23 09:30:00	MSFT	Stock	47.36	47.39	47.01	47.1	3380657.0
2015-01-23 10:00:00	MSFT	Stock	47.1	47.14	46.8	46.97	1939709.0
2015-01-23 10:30:00	MSFT	Stock	46.97	47.08	46.89	46.96	1233602.0
2015-01-23 11:00:00	MSFT	Stock	46.96	47.24	46.96	47.205	958721.0
2015-01-23 11:30:00	MSFT	Stock	47.205	47.21	46.91	47.02	1214775.0
2015-01-23 12:00:00	MSFT	Stock	47.01	47.134	46.98	47.05	725452.0
2015-01-23 12:30:00	MSFT	Stock	47.05	47.16	47.02	47.15	807593.0

> showing 50 of 82,034 rows — these rows as CSV

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