PREVIEW / stock_30min / 2017-07-05

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-07-05.parquet
  size:    1.6 MB
  rows:    81,123
  symbols: 3,006

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-07-05 04:00:00	AAPL	Stock	35.895	35.895	35.775	35.775	5880.0
2017-07-05 04:30:00	AAPL	Stock	35.775	35.775	35.77	35.77	3200.0
2017-07-05 05:00:00	AAPL	Stock	35.7875	35.7875	35.7875	35.7875	400.0
2017-07-05 05:30:00	AAPL	Stock	35.755	35.755	35.755	35.755	976.0
2017-07-05 06:00:00	AAPL	Stock	35.7525	35.84	35.7525	35.84	2720.0
2017-07-05 06:30:00	AAPL	Stock	35.8375	35.84	35.8	35.825	5608.0
2017-07-05 07:00:00	AAPL	Stock	35.8325	35.835	35.7875	35.7925	19888.0
2017-07-05 07:30:00	AAPL	Stock	35.815	35.885	35.815	35.885	13208.0
2017-07-05 08:00:00	AAPL	Stock	35.815	36.02	35.7875	36.0	139336.0
2017-07-05 08:30:00	AAPL	Stock	36.0225	36.0375	35.995	36.0	105304.0
2017-07-05 09:00:00	AAPL	Stock	35.99	36.0375	35.915	35.9225	115912.0
2017-07-05 09:30:00	AAPL	Stock	35.9225	36.0995	35.89	35.915	11414988.0
2017-07-05 10:00:00	AAPL	Stock	35.9125	35.9162	35.681	35.78	8319688.0
2017-07-05 10:30:00	AAPL	Stock	35.7775	35.955	35.77	35.8725	6225636.0
2017-07-05 11:00:00	AAPL	Stock	35.8725	35.9575	35.865	35.9575	3567356.0
2017-07-05 11:30:00	AAPL	Stock	35.955	36.0375	35.895	36.0375	4025304.0
2017-07-05 12:00:00	AAPL	Stock	36.0375	36.1975	36.02	36.1575	5820528.0
2017-07-05 12:30:00	AAPL	Stock	36.155	36.17	36.0925	36.1475	2722116.0
2017-07-05 13:00:00	AAPL	Stock	36.1488	36.1775	36.055	36.065	2986876.0
2017-07-05 13:30:00	AAPL	Stock	36.0662	36.085	36.04	36.0475	2602968.0
2017-07-05 14:00:00	AAPL	Stock	36.0452	36.105	35.9725	36.055	3926108.0
2017-07-05 14:30:00	AAPL	Stock	36.0538	36.1525	36.0375	36.0495	3248140.0
2017-07-05 15:00:00	AAPL	Stock	36.0475	36.0612	35.9715	36.02	4277700.0
2017-07-05 15:30:00	AAPL	Stock	36.02	36.0925	36.005	36.0225	5877068.0
2017-07-05 16:00:00	AAPL	Stock	36.0225	36.0425	36.005	36.0225	12516028.0
2017-07-05 16:30:00	AAPL	Stock	36.0225	36.03	36.0	36.03	604156.0
2017-07-05 17:00:00	AAPL	Stock	36.005	36.025	36.0025	36.0225	14024.0
2017-07-05 17:30:00	AAPL	Stock	36.0225	36.0225	36.005	36.005	2004.0
2017-07-05 18:00:00	AAPL	Stock	36.005	36.0225	36.005	36.005	7352.0
2017-07-05 18:30:00	AAPL	Stock	36.005	36.0225	36.005	36.0225	7932.0
2017-07-05 19:00:00	AAPL	Stock	36.03	36.03	36.0025	36.0025	6384.0
2017-07-05 19:30:00	AAPL	Stock	36.0025	36.0275	36.0	36.0	13864.0
2017-07-05 04:30:00	MSFT	Stock	68.0	68.0	68.0	68.0	100.0
2017-07-05 06:00:00	MSFT	Stock	68.13	68.13	68.13	68.13	1600.0
2017-07-05 07:00:00	MSFT	Stock	67.9	67.9	67.89	67.89	5625.0
2017-07-05 07:30:00	MSFT	Stock	67.8	68.0	67.8	68.0	6135.0
2017-07-05 08:00:00	MSFT	Stock	68.0	68.3	68.0	68.25	13157.0
2017-07-05 08:30:00	MSFT	Stock	68.24	68.35	68.2	68.2	4723.0
2017-07-05 09:00:00	MSFT	Stock	68.25	68.4	68.19	68.25	5889.0
2017-07-05 09:30:00	MSFT	Stock	68.255	68.725	68.22	68.48	3783245.0
2017-07-05 10:00:00	MSFT	Stock	68.47	68.68	68.42	68.48	1477156.0
2017-07-05 10:30:00	MSFT	Stock	68.485	68.89	68.475	68.87	1561210.0
2017-07-05 11:00:00	MSFT	Stock	68.87	69.215	68.82	69.175	992072.0
2017-07-05 11:30:00	MSFT	Stock	69.17	69.23	69.02	69.185	784583.0
2017-07-05 12:00:00	MSFT	Stock	69.19	69.28	69.115	69.265	708011.0
2017-07-05 12:30:00	MSFT	Stock	69.265	69.31	69.16	69.305	820592.0
2017-07-05 13:00:00	MSFT	Stock	69.31	69.44	69.28	69.34	713769.0
2017-07-05 13:30:00	MSFT	Stock	69.34	69.36	69.1	69.12	485795.0
2017-07-05 14:00:00	MSFT	Stock	69.13	69.28	69.02	69.225	846885.0
2017-07-05 14:30:00	MSFT	Stock	69.22	69.34	69.1	69.11	845931.0

> showing 50 of 81,123 rows — these rows as CSV

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