PREVIEW / stock_30min / 2017-08-04

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-04.parquet
  size:    1.6 MB
  rows:    79,755
  symbols: 2,987

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-08-04 04:00:00	AAPL	Stock	38.925	38.9725	38.925	38.9725	2272.0
2017-08-04 06:00:00	AAPL	Stock	38.9725	38.975	38.945	38.945	6844.0
2017-08-04 06:30:00	AAPL	Stock	38.945	38.96	38.945	38.955	4800.0
2017-08-04 07:00:00	AAPL	Stock	38.9375	38.955	38.93	38.955	12032.0
2017-08-04 07:30:00	AAPL	Stock	38.9625	38.9675	38.945	38.955	13852.0
2017-08-04 08:00:00	AAPL	Stock	38.95	38.975	38.945	38.96	29832.0
2017-08-04 08:30:00	AAPL	Stock	38.9675	39.0625	38.9475	38.9525	267396.0
2017-08-04 09:00:00	AAPL	Stock	38.955	39.05	38.8925	39.0175	218764.0
2017-08-04 09:30:00	AAPL	Stock	39.0175	39.35	38.9225	39.1775	15824392.0
2017-08-04 10:00:00	AAPL	Stock	39.1825	39.295	39.04	39.2775	8856056.0
2017-08-04 10:30:00	AAPL	Stock	39.275	39.3125	39.0125	39.1095	8837964.0
2017-08-04 11:00:00	AAPL	Stock	39.1125	39.2325	39.0525	39.21	5432860.0
2017-08-04 11:30:00	AAPL	Stock	39.2075	39.225	39.0825	39.1115	2945548.0
2017-08-04 12:00:00	AAPL	Stock	39.115	39.1375	39.05	39.05	2795532.0
2017-08-04 12:30:00	AAPL	Stock	39.0475	39.0508	38.9525	39.025	3241928.0
2017-08-04 13:00:00	AAPL	Stock	39.0272	39.045	38.945	38.975	2759768.0
2017-08-04 13:30:00	AAPL	Stock	38.9775	39.0625	38.9688	39.0425	2750864.0
2017-08-04 14:00:00	AAPL	Stock	39.0438	39.065	38.9925	39.0	2474628.0
2017-08-04 14:30:00	AAPL	Stock	39.0	39.0365	38.9838	39.0025	1891212.0
2017-08-04 15:00:00	AAPL	Stock	39.005	39.08	39.005	39.0525	2619920.0
2017-08-04 15:30:00	AAPL	Stock	39.0525	39.105	38.9875	39.085	8912852.0
2017-08-04 16:00:00	AAPL	Stock	39.0975	39.115	39.075	39.115	5206784.0
2017-08-04 16:30:00	AAPL	Stock	39.1225	39.2	39.1225	39.1875	132016.0
2017-08-04 17:00:00	AAPL	Stock	39.18	39.1875	39.1525	39.1625	44744.0
2017-08-04 17:30:00	AAPL	Stock	39.14	39.1725	39.1375	39.14	26924.0
2017-08-04 18:00:00	AAPL	Stock	39.145	39.1575	39.1425	39.1475	28872.0
2017-08-04 18:30:00	AAPL	Stock	39.145	39.1575	39.145	39.1475	14572.0
2017-08-04 19:00:00	AAPL	Stock	39.1475	39.1625	39.1475	39.15	36616.0
2017-08-04 19:30:00	AAPL	Stock	39.15	39.1725	39.15	39.1625	40056.0
2017-08-04 04:00:00	MSFT	Stock	72.18	72.18	72.0	72.0	2244.0
2017-08-04 08:00:00	MSFT	Stock	72.37	72.37	72.21	72.21	1000.0
2017-08-04 08:30:00	MSFT	Stock	72.38	72.38	72.25	72.28	1472.0
2017-08-04 09:00:00	MSFT	Stock	72.26	72.42	72.15	72.41	52559.0
2017-08-04 09:30:00	MSFT	Stock	72.4	72.77	72.34	72.44	3124720.0
2017-08-04 10:00:00	MSFT	Stock	72.445	72.66	72.24	72.61	1576066.0
2017-08-04 10:30:00	MSFT	Stock	72.617	72.7	72.539	72.66	857083.0
2017-08-04 11:00:00	MSFT	Stock	72.656	72.79	72.59	72.77	891328.0
2017-08-04 11:30:00	MSFT	Stock	72.76	73.04	72.74	72.975	1405955.0
2017-08-04 12:00:00	MSFT	Stock	72.97	72.975	72.7	72.78	1059775.0
2017-08-04 12:30:00	MSFT	Stock	72.79	72.81	72.54	72.62	1265915.0
2017-08-04 13:00:00	MSFT	Stock	72.62	72.67	72.49	72.595	1055331.0
2017-08-04 13:30:00	MSFT	Stock	72.59	72.69	72.54	72.677	1002853.0
2017-08-04 14:00:00	MSFT	Stock	72.67	72.69	72.5	72.515	1102907.0
2017-08-04 14:30:00	MSFT	Stock	72.51	72.64	72.51	72.53	971625.0
2017-08-04 15:00:00	MSFT	Stock	72.53	72.615	72.45	72.54	1387644.0
2017-08-04 15:30:00	MSFT	Stock	72.54	72.7	72.52	72.66	3897465.0
2017-08-04 16:00:00	MSFT	Stock	72.68	72.74	72.6	72.68	1786568.0
2017-08-04 16:30:00	MSFT	Stock	72.6	72.68	72.59	72.68	400.0
2017-08-04 17:30:00	MSFT	Stock	72.65	72.65	72.6	72.6	292.0
2017-08-04 19:30:00	MSFT	Stock	72.65	72.65	72.65	72.65	150.0

> showing 50 of 79,755 rows — these rows as CSV

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