PREVIEW / stock_30min / 2017-02-24

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-02-24.parquet
  size:    1.6 MB
  rows:    82,470
  symbols: 3,099

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-02-24 04:00:00	AAPL	Stock	34.0375	34.0375	33.99	33.99	9336.0
2017-02-24 04:30:00	AAPL	Stock	33.975	33.975	33.8775	33.88	12388.0
2017-02-24 05:00:00	AAPL	Stock	33.87	33.87	33.7525	33.7975	11992.0
2017-02-24 05:30:00	AAPL	Stock	33.8	33.8	33.655	33.715	27284.0
2017-02-24 06:00:00	AAPL	Stock	33.7175	33.7275	33.7175	33.7175	38684.0
2017-02-24 06:30:00	AAPL	Stock	33.7225	33.825	33.665	33.665	64332.0
2017-02-24 07:00:00	AAPL	Stock	33.665	33.775	33.655	33.775	72396.0
2017-02-24 07:30:00	AAPL	Stock	33.7525	33.825	33.7525	33.78	90352.0
2017-02-24 08:00:00	AAPL	Stock	33.8225	33.8725	33.655	33.85	266388.0
2017-02-24 08:30:00	AAPL	Stock	33.8525	33.875	33.8075	33.83	214412.0
2017-02-24 09:00:00	AAPL	Stock	33.825	33.975	33.7925	33.9725	595788.0
2017-02-24 09:30:00	AAPL	Stock	33.9775	34.025	33.825	33.9575	17038012.0
2017-02-24 10:00:00	AAPL	Stock	33.9562	33.9825	33.82	33.8675	8851988.0
2017-02-24 10:30:00	AAPL	Stock	33.87	33.965	33.855	33.95	4963136.0
2017-02-24 11:00:00	AAPL	Stock	33.95	33.995	33.9338	33.9925	4096444.0
2017-02-24 11:30:00	AAPL	Stock	33.9925	33.9975	33.9475	33.9625	2796412.0
2017-02-24 12:00:00	AAPL	Stock	33.9612	33.9975	33.9452	33.9935	3266976.0
2017-02-24 12:30:00	AAPL	Stock	33.9938	34.0625	33.9925	34.0375	4198520.0
2017-02-24 13:00:00	AAPL	Stock	34.0375	34.045	34.0075	34.0225	1689844.0
2017-02-24 13:30:00	AAPL	Stock	34.025	34.05	34.0125	34.0362	1956224.0
2017-02-24 14:00:00	AAPL	Stock	34.035	34.0388	34.0025	34.01	2362372.0
2017-02-24 14:30:00	AAPL	Stock	34.0112	34.03	33.99	33.9988	2609004.0
2017-02-24 15:00:00	AAPL	Stock	34.0	34.0325	33.98	34.025	4355184.0
2017-02-24 15:30:00	AAPL	Stock	34.024	34.1625	34.021	34.16	12233132.0
2017-02-24 16:00:00	AAPL	Stock	34.165	34.1725	34.1425	34.1625	7156696.0
2017-02-24 16:30:00	AAPL	Stock	34.1525	34.1625	34.1525	34.1625	40872.0
2017-02-24 17:00:00	AAPL	Stock	34.1625	34.165	34.15	34.1525	209640.0
2017-02-24 17:30:00	AAPL	Stock	34.155	34.16	34.1525	34.16	5480.0
2017-02-24 18:00:00	AAPL	Stock	34.15	34.15	34.15	34.15	8000.0
2017-02-24 18:30:00	AAPL	Stock	34.15	34.15	34.1475	34.1475	3800.0
2017-02-24 19:00:00	AAPL	Stock	34.15	34.16	34.15	34.16	15592.0
2017-02-24 19:30:00	AAPL	Stock	34.1575	34.165	34.1525	34.1575	6608.0
2017-02-24 05:00:00	MSFT	Stock	64.16	64.16	64.16	64.16	100.0
2017-02-24 06:00:00	MSFT	Stock	64.15	64.15	64.15	64.15	500.0
2017-02-24 06:30:00	MSFT	Stock	64.16	64.16	64.16	64.16	983.0
2017-02-24 07:00:00	MSFT	Stock	64.21	64.21	64.21	64.21	200.0
2017-02-24 07:30:00	MSFT	Stock	64.24	64.34	64.23	64.24	3800.0
2017-02-24 08:00:00	MSFT	Stock	64.28	64.29	64.17	64.25	33762.0
2017-02-24 08:30:00	MSFT	Stock	64.25	64.3	64.24	64.25	14111.0
2017-02-24 09:00:00	MSFT	Stock	64.25	64.66	64.16	64.49	216932.0
2017-02-24 09:30:00	MSFT	Stock	64.49	64.77	64.44	64.74	3321586.0
2017-02-24 10:00:00	MSFT	Stock	64.745	64.8	64.46	64.51	1764433.0
2017-02-24 10:30:00	MSFT	Stock	64.51	64.57	64.41	64.465	1587562.0
2017-02-24 11:00:00	MSFT	Stock	64.47	64.525	64.42	64.525	718035.0
2017-02-24 11:30:00	MSFT	Stock	64.526	64.56	64.4	64.41	636861.0
2017-02-24 12:00:00	MSFT	Stock	64.414	64.48	64.37	64.436	755690.0
2017-02-24 12:30:00	MSFT	Stock	64.44	64.46	64.305	64.31	695203.0
2017-02-24 13:00:00	MSFT	Stock	64.31	64.33	64.135	64.15	1363254.0
2017-02-24 13:30:00	MSFT	Stock	64.15	64.23	64.14	64.22	564393.0
2017-02-24 14:00:00	MSFT	Stock	64.215	64.26	64.195	64.225	513812.0

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

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