PREVIEW / stock_30min / 2017-12-13

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-13.parquet
  size:    1.7 MB
  rows:    84,388
  symbols: 2,938

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-12-13 04:30:00	AAPL	Stock	42.935	42.935	42.935	42.935	400.0
2017-12-13 05:30:00	AAPL	Stock	42.975	42.975	42.975	42.975	6000.0
2017-12-13 06:00:00	AAPL	Stock	42.975	42.975	42.925	42.925	25456.0
2017-12-13 06:30:00	AAPL	Stock	42.925	42.9625	42.925	42.9625	18712.0
2017-12-13 07:00:00	AAPL	Stock	42.895	42.9375	42.88	42.9275	12636.0
2017-12-13 07:30:00	AAPL	Stock	42.93	42.96	42.895	42.895	22144.0
2017-12-13 08:00:00	AAPL	Stock	42.9625	42.9625	42.8775	42.9475	35000.0
2017-12-13 08:30:00	AAPL	Stock	42.965	43.12	42.9475	43.0775	232592.0
2017-12-13 09:00:00	AAPL	Stock	43.08	43.1725	43.075	43.15	350612.0
2017-12-13 09:30:00	AAPL	Stock	43.1575	43.385	43.125	43.235	15089848.0
2017-12-13 10:00:00	AAPL	Stock	43.235	43.2775	43.15	43.1925	6385464.0
2017-12-13 10:30:00	AAPL	Stock	43.1918	43.2975	43.14	43.245	5255016.0
2017-12-13 11:00:00	AAPL	Stock	43.2475	43.285	43.1975	43.24	4989840.0
2017-12-13 11:30:00	AAPL	Stock	43.24	43.2625	43.1675	43.225	3395240.0
2017-12-13 12:00:00	AAPL	Stock	43.2225	43.2225	43.0	43.155	5760596.0
2017-12-13 12:30:00	AAPL	Stock	43.1525	43.1675	43.05	43.165	3761356.0
2017-12-13 13:00:00	AAPL	Stock	43.1625	43.1875	43.125	43.1275	2514736.0
2017-12-13 13:30:00	AAPL	Stock	43.1275	43.1522	43.0775	43.0925	2953388.0
2017-12-13 14:00:00	AAPL	Stock	43.0925	43.2575	43.09	43.2498	4822904.0
2017-12-13 14:30:00	AAPL	Stock	43.245	43.295	43.2075	43.2625	4522512.0
2017-12-13 15:00:00	AAPL	Stock	43.264	43.2825	43.16	43.1875	3608292.0
2017-12-13 15:30:00	AAPL	Stock	43.185	43.245	43.035	43.0775	10189120.0
2017-12-13 16:00:00	AAPL	Stock	43.0675	43.1125	43.0675	43.09	9178132.0
2017-12-13 16:30:00	AAPL	Stock	43.095	43.0975	43.0675	43.0875	23612.0
2017-12-13 17:00:00	AAPL	Stock	43.0775	43.0875	43.075	43.075	7840.0
2017-12-13 17:30:00	AAPL	Stock	43.0875	43.095	43.085	43.0925	10740.0
2017-12-13 18:00:00	AAPL	Stock	43.1	43.1	43.0875	43.0925	13600.0
2017-12-13 18:30:00	AAPL	Stock	43.1	43.1	43.1	43.1	10480.0
2017-12-13 19:00:00	AAPL	Stock	43.1	43.1075	43.0875	43.1075	11920.0
2017-12-13 19:30:00	AAPL	Stock	43.1075	43.1425	43.1025	43.1425	39540.0
2017-12-13 07:00:00	MSFT	Stock	85.99	85.99	85.75	85.75	1070.0
2017-12-13 07:30:00	MSFT	Stock	85.75	85.75	85.6	85.6	900.0
2017-12-13 08:00:00	MSFT	Stock	85.8	85.8	85.65	85.65	672.0
2017-12-13 08:30:00	MSFT	Stock	85.65	85.97	85.65	85.97	800.0
2017-12-13 09:00:00	MSFT	Stock	85.66	85.89	85.66	85.77	3835.0
2017-12-13 09:30:00	MSFT	Stock	85.74	86.0	85.33	85.49	2368552.0
2017-12-13 10:00:00	MSFT	Stock	85.495	85.73	85.42	85.7	1405121.0
2017-12-13 10:30:00	MSFT	Stock	85.7	85.92	85.62	85.915	1357285.0
2017-12-13 11:00:00	MSFT	Stock	85.915	85.96	85.79	85.86	1005806.0
2017-12-13 11:30:00	MSFT	Stock	85.87	85.93	85.543	85.56	914667.0
2017-12-13 12:00:00	MSFT	Stock	85.565	85.565	85.26	85.5	1337151.0
2017-12-13 12:30:00	MSFT	Stock	85.5	85.5	85.25	85.426	745119.0
2017-12-13 13:00:00	MSFT	Stock	85.43	85.49	85.27	85.275	712626.0
2017-12-13 13:30:00	MSFT	Stock	85.28	85.41	85.17	85.33	766650.0
2017-12-13 14:00:00	MSFT	Stock	85.35	85.68	85.35	85.54	1165236.0
2017-12-13 14:30:00	MSFT	Stock	85.53	85.66	85.47	85.56	1013700.0
2017-12-13 15:00:00	MSFT	Stock	85.555	85.64	85.38	85.42	1043450.0
2017-12-13 15:30:00	MSFT	Stock	85.415	85.56	85.28	85.35	2947239.0
2017-12-13 16:00:00	MSFT	Stock	85.35	85.41	85.35	85.36	3286104.0
2017-12-13 16:30:00	MSFT	Stock	85.35	85.35	85.3	85.31	2689.0

> showing 50 of 84,388 rows — these rows as CSV

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