PREVIEW / stock_30min / 2017-08-11

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-11.parquet
  size:    1.6 MB
  rows:    82,378
  symbols: 2,971

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-11 04:00:00	AAPL	Stock	38.7375	38.75	38.6175	38.6175	13904.0
2017-08-11 04:30:00	AAPL	Stock	38.575	38.62	38.5525	38.5775	21544.0
2017-08-11 05:00:00	AAPL	Stock	38.5875	38.6175	38.5625	38.5625	8980.0
2017-08-11 05:30:00	AAPL	Stock	38.6625	38.7475	38.5875	38.5875	61488.0
2017-08-11 06:00:00	AAPL	Stock	38.6075	38.7325	38.565	38.65	30692.0
2017-08-11 06:30:00	AAPL	Stock	38.65	38.6975	38.625	38.685	12184.0
2017-08-11 07:00:00	AAPL	Stock	38.675	38.71	38.635	38.6875	56368.0
2017-08-11 07:30:00	AAPL	Stock	38.705	38.7225	38.625	38.675	68612.0
2017-08-11 08:00:00	AAPL	Stock	38.6875	38.9	38.6375	38.9	215852.0
2017-08-11 08:30:00	AAPL	Stock	38.87	39.0375	38.8575	39.0225	379676.0
2017-08-11 09:00:00	AAPL	Stock	39.02	39.185	39.02	39.1525	1141480.0
2017-08-11 09:30:00	AAPL	Stock	39.1625	39.495	39.0175	39.4575	22055812.0
2017-08-11 10:00:00	AAPL	Stock	39.4562	39.6432	39.3582	39.3875	12168904.0
2017-08-11 10:30:00	AAPL	Stock	39.3875	39.5075	39.2625	39.365	7005160.0
2017-08-11 11:00:00	AAPL	Stock	39.361	39.44	39.28	39.3115	5514864.0
2017-08-11 11:30:00	AAPL	Stock	39.315	39.4675	39.315	39.4075	3661152.0
2017-08-11 12:00:00	AAPL	Stock	39.405	39.47	39.355	39.4275	3230000.0
2017-08-11 12:30:00	AAPL	Stock	39.43	39.5125	39.4125	39.4525	3016860.0
2017-08-11 13:00:00	AAPL	Stock	39.455	39.5075	39.3985	39.3985	2865048.0
2017-08-11 13:30:00	AAPL	Stock	39.4	39.5	39.38	39.4775	3557664.0
2017-08-11 14:00:00	AAPL	Stock	39.4775	39.5675	39.45	39.565	3878604.0
2017-08-11 14:30:00	AAPL	Stock	39.5662	39.5775	39.29	39.3125	6096216.0
2017-08-11 15:00:00	AAPL	Stock	39.3125	39.395	39.2175	39.305	5837940.0
2017-08-11 15:30:00	AAPL	Stock	39.3052	39.4	39.255	39.3725	9954680.0
2017-08-11 16:00:00	AAPL	Stock	39.37	39.38	39.315	39.325	3857712.0
2017-08-11 16:30:00	AAPL	Stock	39.3175	39.3525	39.3	39.3225	70900.0
2017-08-11 17:00:00	AAPL	Stock	39.325	39.3575	39.3175	39.325	33916.0
2017-08-11 17:30:00	AAPL	Stock	39.3175	39.355	39.3175	39.3525	22744.0
2017-08-11 18:00:00	AAPL	Stock	39.345	39.35	39.345	39.345	12640.0
2017-08-11 18:30:00	AAPL	Stock	39.345	39.355	39.34	39.35	7660.0
2017-08-11 19:00:00	AAPL	Stock	39.3525	39.355	39.3275	39.3525	22436.0
2017-08-11 19:30:00	AAPL	Stock	39.3525	39.355	39.3375	39.355	24400.0
2017-08-11 04:30:00	MSFT	Stock	71.3	71.3	71.26	71.26	725.0
2017-08-11 05:00:00	MSFT	Stock	71.0	71.19	71.0	71.05	10003.0
2017-08-11 05:30:00	MSFT	Stock	71.18	71.28	71.18	71.28	6080.0
2017-08-11 06:00:00	MSFT	Stock	71.28	71.28	71.25	71.28	782.0
2017-08-11 06:30:00	MSFT	Stock	71.29	71.3	71.2	71.2	2204.0
2017-08-11 07:00:00	MSFT	Stock	71.25	71.25	71.25	71.25	296.0
2017-08-11 07:30:00	MSFT	Stock	71.12	71.25	71.11	71.23	3950.0
2017-08-11 08:00:00	MSFT	Stock	71.18	71.39	71.18	71.35	16511.0
2017-08-11 08:30:00	MSFT	Stock	71.35	72.0	71.35	71.53	19940.0
2017-08-11 09:00:00	MSFT	Stock	71.55	71.67	71.4	71.55	66816.0
2017-08-11 09:30:00	MSFT	Stock	71.57	71.84	71.28	71.714	2699023.0
2017-08-11 10:00:00	MSFT	Stock	71.71	71.9	71.61	71.75	1207634.0
2017-08-11 10:30:00	MSFT	Stock	71.75	72.0	71.725	71.92	887033.0
2017-08-11 11:00:00	MSFT	Stock	71.92	72.03	71.8	71.84	1046402.0
2017-08-11 11:30:00	MSFT	Stock	71.845	72.145	71.835	72.04	1039413.0
2017-08-11 12:00:00	MSFT	Stock	72.04	72.36	72.0	72.205	1043549.0
2017-08-11 12:30:00	MSFT	Stock	72.205	72.44	72.19	72.4	1091465.0
2017-08-11 13:00:00	MSFT	Stock	72.4	72.52	72.37	72.42	973213.0

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

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