PREVIEW / stock_30min / 2017-05-16

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-16.parquet
  size:    1.6 MB
  rows:    81,623
  symbols: 3,030

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-05-16 04:00:00	AAPL	Stock	38.975	38.9875	38.975	38.975	6936.0
2017-05-16 04:30:00	AAPL	Stock	38.9725	38.9725	38.9725	38.9725	400.0
2017-05-16 05:00:00	AAPL	Stock	38.97	38.97	38.97	38.97	800.0
2017-05-16 05:30:00	AAPL	Stock	38.96	38.96	38.95	38.95	1248.0
2017-05-16 06:30:00	AAPL	Stock	38.975	38.9875	38.975	38.9875	4400.0
2017-05-16 07:00:00	AAPL	Stock	38.9875	39.025	38.9875	39.025	14552.0
2017-05-16 07:30:00	AAPL	Stock	39.0425	39.0475	39.0375	39.0425	12200.0
2017-05-16 08:00:00	AAPL	Stock	39.0375	39.065	39.0	39.0	122964.0
2017-05-16 08:30:00	AAPL	Stock	38.9875	39.05	38.9875	39.0425	124912.0
2017-05-16 09:00:00	AAPL	Stock	39.025	39.0375	38.975	38.9925	183392.0
2017-05-16 09:30:00	AAPL	Stock	38.985	39.015	38.8	38.8675	12297464.0
2017-05-16 10:00:00	AAPL	Stock	38.8675	38.9275	38.7	38.7012	7704740.0
2017-05-16 10:30:00	AAPL	Stock	38.7025	38.7812	38.68	38.7375	6983220.0
2017-05-16 11:00:00	AAPL	Stock	38.74	38.845	38.6975	38.7792	4895164.0
2017-05-16 11:30:00	AAPL	Stock	38.7788	38.865	38.75	38.825	3684424.0
2017-05-16 12:00:00	AAPL	Stock	38.8275	38.8623	38.805	38.8338	2403760.0
2017-05-16 12:30:00	AAPL	Stock	38.8325	38.8625	38.8182	38.8225	2381992.0
2017-05-16 13:00:00	AAPL	Stock	38.825	38.83	38.7775	38.7875	3059272.0
2017-05-16 13:30:00	AAPL	Stock	38.7875	38.8275	38.7425	38.7862	3860964.0
2017-05-16 14:00:00	AAPL	Stock	38.785	38.8352	38.7725	38.8312	2689768.0
2017-05-16 14:30:00	AAPL	Stock	38.8342	38.8425	38.8125	38.8362	3320676.0
2017-05-16 15:00:00	AAPL	Stock	38.8362	38.84	38.8002	38.825	3208736.0
2017-05-16 15:30:00	AAPL	Stock	38.8265	38.87	38.82	38.8675	7152824.0
2017-05-16 16:00:00	AAPL	Stock	38.85	38.875	38.84	38.865	4819496.0
2017-05-16 16:30:00	AAPL	Stock	38.8625	38.8725	38.8625	38.8675	46972.0
2017-05-16 17:00:00	AAPL	Stock	38.8625	38.8625	38.85	38.855	38200.0
2017-05-16 17:30:00	AAPL	Stock	38.8525	38.8525	38.835	38.8375	11320.0
2017-05-16 18:00:00	AAPL	Stock	38.8275	38.8275	38.75	38.75	48768.0
2017-05-16 18:30:00	AAPL	Stock	38.755	38.775	38.7325	38.7325	59824.0
2017-05-16 19:00:00	AAPL	Stock	38.7275	38.7275	38.7025	38.7125	24808.0
2017-05-16 19:30:00	AAPL	Stock	38.7125	38.7125	38.64	38.665	50788.0
2017-05-16 04:00:00	MSFT	Stock	68.2	68.2	68.15	68.15	448.0
2017-05-16 05:00:00	MSFT	Stock	68.2	68.2	68.2	68.2	2252.0
2017-05-16 06:00:00	MSFT	Stock	68.2	68.2	68.2	68.2	118.0
2017-05-16 07:30:00	MSFT	Stock	68.15	68.15	68.15	68.15	2379.0
2017-05-16 08:00:00	MSFT	Stock	68.15	68.2	68.1	68.1	7369.0
2017-05-16 08:30:00	MSFT	Stock	68.11	68.2	68.1	68.1	2099.0
2017-05-16 09:00:00	MSFT	Stock	68.1	68.3	68.1	68.25	21605.0
2017-05-16 09:30:00	MSFT	Stock	68.23	68.5	68.16	68.47	2682510.0
2017-05-16 10:00:00	MSFT	Stock	68.475	68.55	68.32	68.4	1908720.0
2017-05-16 10:30:00	MSFT	Stock	68.395	68.55	68.35	68.5	2537352.0
2017-05-16 11:00:00	MSFT	Stock	68.51	68.86	68.49	68.83	1807411.0
2017-05-16 11:30:00	MSFT	Stock	68.83	68.87	68.65	68.83	1306376.0
2017-05-16 12:00:00	MSFT	Stock	68.83	69.14	68.81	69.095	1710199.0
2017-05-16 12:30:00	MSFT	Stock	69.096	69.205	69.02	69.17	1150421.0
2017-05-16 13:00:00	MSFT	Stock	69.17	69.27	69.08	69.17	1212965.0
2017-05-16 13:30:00	MSFT	Stock	69.17	69.32	69.16	69.215	1002952.0
2017-05-16 14:00:00	MSFT	Stock	69.21	69.22	69.12	69.18	1601449.0
2017-05-16 14:30:00	MSFT	Stock	69.18	69.21	69.07	69.135	1418646.0
2017-05-16 15:00:00	MSFT	Stock	69.135	69.21	69.09	69.175	2212594.0

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

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