PREVIEW / stock_30min / 2017-12-12

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-12.parquet
  size:    1.7 MB
  rows:    83,981
  symbols: 2,944

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-12 04:30:00	AAPL	Stock	43.065	43.1125	43.065	43.1125	996.0
2017-12-12 05:00:00	AAPL	Stock	43.075	43.075	43.065	43.065	1896.0
2017-12-12 05:30:00	AAPL	Stock	43.0075	43.075	43.0075	43.065	3368.0
2017-12-12 06:30:00	AAPL	Stock	43.08	43.0875	43.08	43.08	4880.0
2017-12-12 07:00:00	AAPL	Stock	43.0975	43.1225	43.0975	43.1225	8160.0
2017-12-12 07:30:00	AAPL	Stock	43.1225	43.15	43.1225	43.1375	28516.0
2017-12-12 08:00:00	AAPL	Stock	43.1425	43.17	43.0975	43.125	73244.0
2017-12-12 08:30:00	AAPL	Stock	43.1	43.125	43.075	43.11	80184.0
2017-12-12 09:00:00	AAPL	Stock	43.0875	43.1	43.005	43.025	145788.0
2017-12-12 09:30:00	AAPL	Stock	43.0375	43.0975	42.8653	42.9875	13882448.0
2017-12-12 10:00:00	AAPL	Stock	42.99	43.01	42.9075	42.9475	5745092.0
2017-12-12 10:30:00	AAPL	Stock	42.95	43.0425	42.9	42.985	4751964.0
2017-12-12 11:00:00	AAPL	Stock	42.985	43.025	42.9575	43.01	3648144.0
2017-12-12 11:30:00	AAPL	Stock	43.01	43.0588	42.97	42.9975	3260208.0
2017-12-12 12:00:00	AAPL	Stock	42.995	43.0475	42.915	42.945	2911112.0
2017-12-12 12:30:00	AAPL	Stock	42.945	43.01	42.935	43.005	2963164.0
2017-12-12 13:00:00	AAPL	Stock	43.0075	43.0375	42.9675	42.9925	2428068.0
2017-12-12 13:30:00	AAPL	Stock	42.995	43.005	42.91	42.9588	2827812.0
2017-12-12 14:00:00	AAPL	Stock	42.9575	43.0175	42.915	42.9988	2789536.0
2017-12-12 14:30:00	AAPL	Stock	43.0	43.0125	42.9625	42.9775	2619384.0
2017-12-12 15:00:00	AAPL	Stock	42.98	43.01	42.95	42.992	3063500.0
2017-12-12 15:30:00	AAPL	Stock	42.9903	43.005	42.9	42.9325	8282156.0
2017-12-12 16:00:00	AAPL	Stock	42.925	42.9375	42.8975	42.925	8255820.0
2017-12-12 16:30:00	AAPL	Stock	42.9175	42.925	42.9125	42.9125	294080.0
2017-12-12 17:00:00	AAPL	Stock	42.9325	42.9325	42.9125	42.9125	4292.0
2017-12-12 17:30:00	AAPL	Stock	42.9475	42.95	42.9375	42.945	15396.0
2017-12-12 18:00:00	AAPL	Stock	42.9375	42.9375	42.895	42.9025	15620.0
2017-12-12 18:30:00	AAPL	Stock	42.91	42.925	42.89	42.8925	19068.0
2017-12-12 19:00:00	AAPL	Stock	42.89	42.9175	42.89	42.9175	1396.0
2017-12-12 19:30:00	AAPL	Stock	42.9025	42.9025	42.8875	42.8875	13420.0
2017-12-12 04:30:00	MSFT	Stock	85.59	85.62	85.59	85.62	824.0
2017-12-12 07:00:00	MSFT	Stock	85.4	85.6	85.4	85.55	2674.0
2017-12-12 07:30:00	MSFT	Stock	85.64	85.7	85.59	85.59	3344.0
2017-12-12 08:00:00	MSFT	Stock	85.55	85.65	85.45	85.45	9823.0
2017-12-12 08:30:00	MSFT	Stock	85.49	85.52	85.45	85.5	7954.0
2017-12-12 09:00:00	MSFT	Stock	85.49	85.51	85.28	85.28	30088.0
2017-12-12 09:30:00	MSFT	Stock	85.31	85.91	85.08	85.91	2972686.0
2017-12-12 10:00:00	MSFT	Stock	85.91	86.05	85.67	85.71	2001653.0
2017-12-12 10:30:00	MSFT	Stock	85.72	85.72	85.37	85.401	1426278.0
2017-12-12 11:00:00	MSFT	Stock	85.405	85.71	85.395	85.65	1025785.0
2017-12-12 11:30:00	MSFT	Stock	85.66	85.74	85.55	85.67	947763.0
2017-12-12 12:00:00	MSFT	Stock	85.665	85.69	85.415	85.46	845383.0
2017-12-12 12:30:00	MSFT	Stock	85.455	85.62	85.43	85.535	802330.0
2017-12-12 13:00:00	MSFT	Stock	85.535	85.58	85.43	85.48	781348.0
2017-12-12 13:30:00	MSFT	Stock	85.485	85.49	85.24	85.315	1102404.0
2017-12-12 14:00:00	MSFT	Stock	85.31	85.49	85.23	85.49	959812.0
2017-12-12 14:30:00	MSFT	Stock	85.485	85.67	85.42	85.615	953304.0
2017-12-12 15:00:00	MSFT	Stock	85.61	85.67	85.56	85.625	1038416.0
2017-12-12 15:30:00	MSFT	Stock	85.62	85.769	85.44	85.62	2941461.0
2017-12-12 16:00:00	MSFT	Stock	85.62	85.68	85.565	85.58	4385255.0

> showing 50 of 83,981 rows — these rows as CSV

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