PREVIEW / stock_30min / 2019-02-13

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-13.parquet
  size:    1.7 MB
  rows:    83,381
  symbols: 2,659

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
2019-02-13 04:00:00	AAPL	Stock	42.8775	42.9375	42.875	42.875	10372.0
2019-02-13 04:30:00	AAPL	Stock	42.945	42.945	42.945	42.945	1200.0
2019-02-13 05:00:00	AAPL	Stock	42.8775	42.9125	42.8775	42.9125	868.0
2019-02-13 05:30:00	AAPL	Stock	42.895	42.895	42.895	42.895	1212.0
2019-02-13 06:00:00	AAPL	Stock	42.9125	42.9125	42.9125	42.9125	400.0
2019-02-13 06:30:00	AAPL	Stock	42.915	42.915	42.915	42.915	1600.0
2019-02-13 07:00:00	AAPL	Stock	42.9075	42.9375	42.9	42.9325	30384.0
2019-02-13 07:30:00	AAPL	Stock	42.925	42.9275	42.895	42.9025	34012.0
2019-02-13 08:00:00	AAPL	Stock	42.9175	42.935	42.8275	42.8625	119260.0
2019-02-13 08:30:00	AAPL	Stock	42.855	42.9375	42.8125	42.9125	160768.0
2019-02-13 09:00:00	AAPL	Stock	42.895	42.9125	42.8055	42.86	104040.0
2019-02-13 09:30:00	AAPL	Stock	42.8575	43.12	42.77	42.8825	13331236.0
2019-02-13 10:00:00	AAPL	Stock	42.88	42.935	42.7375	42.855	7834600.0
2019-02-13 10:30:00	AAPL	Stock	42.8575	42.9625	42.815	42.8675	5229200.0
2019-02-13 11:00:00	AAPL	Stock	42.87	42.93	42.735	42.7412	5102588.0
2019-02-13 11:30:00	AAPL	Stock	42.7425	42.75	42.6425	42.7375	5856328.0
2019-02-13 12:00:00	AAPL	Stock	42.74	42.78	42.67	42.695	3129652.0
2019-02-13 12:30:00	AAPL	Stock	42.695	42.7375	42.6025	42.655	2805448.0
2019-02-13 13:00:00	AAPL	Stock	42.6575	42.75	42.65	42.71	2716872.0
2019-02-13 13:30:00	AAPL	Stock	42.7125	42.7525	42.67	42.6825	2253932.0
2019-02-13 14:00:00	AAPL	Stock	42.6825	42.7075	42.6475	42.6738	2641896.0
2019-02-13 14:30:00	AAPL	Stock	42.675	42.79	42.64	42.733	4435216.0
2019-02-13 15:00:00	AAPL	Stock	42.7325	42.7325	42.66	42.7175	3627416.0
2019-02-13 15:30:00	AAPL	Stock	42.72	42.735	42.48	42.5425	9768288.0
2019-02-13 16:00:00	AAPL	Stock	42.545	42.57	42.5125	42.5425	7585504.0
2019-02-13 16:30:00	AAPL	Stock	42.5375	42.5475	42.525	42.53	63016.0
2019-02-13 17:00:00	AAPL	Stock	42.54	42.54	42.525	42.525	21788.0
2019-02-13 17:30:00	AAPL	Stock	42.545	42.545	42.5075	42.5075	123948.0
2019-02-13 18:00:00	AAPL	Stock	42.5075	42.535	42.5	42.535	39408.0
2019-02-13 18:30:00	AAPL	Stock	42.53	42.53	42.5075	42.515	13824.0
2019-02-13 19:00:00	AAPL	Stock	42.5225	42.5475	42.4125	42.4125	51184.0
2019-02-13 19:30:00	AAPL	Stock	42.405	42.4725	42.375	42.4125	16772.0
2019-02-13 04:00:00	MSFT	Stock	107.39	107.39	107.23	107.23	569.0
2019-02-13 04:30:00	MSFT	Stock	107.22	107.23	107.15	107.15	500.0
2019-02-13 05:30:00	MSFT	Stock	107.16	107.16	107.16	107.16	365.0
2019-02-13 06:00:00	MSFT	Stock	107.37	107.4	107.37	107.4	4850.0
2019-02-13 07:00:00	MSFT	Stock	107.3	107.44	107.3	107.33	4449.0
2019-02-13 07:30:00	MSFT	Stock	107.35	107.35	107.3	107.3	1620.0
2019-02-13 08:00:00	MSFT	Stock	107.36	107.48	107.25	107.3	3550.0
2019-02-13 08:30:00	MSFT	Stock	107.27	107.49	107.24	107.4	11935.0
2019-02-13 09:00:00	MSFT	Stock	107.34	107.45	107.27	107.4	12148.0
2019-02-13 09:30:00	MSFT	Stock	107.39	107.78	107.12	107.17	2566151.0
2019-02-13 10:00:00	MSFT	Stock	107.17	107.36	106.95	107.215	1285985.0
2019-02-13 10:30:00	MSFT	Stock	107.2	107.434	107.02	107.29	990698.0
2019-02-13 11:00:00	MSFT	Stock	107.29	107.45	107.06	107.07	1032279.0
2019-02-13 11:30:00	MSFT	Stock	107.06	107.16	106.85	107.1	859537.0
2019-02-13 12:00:00	MSFT	Stock	107.1	107.196	107.01	107.05	833808.0
2019-02-13 12:30:00	MSFT	Stock	107.05	107.11	106.88	106.996	747285.0
2019-02-13 13:00:00	MSFT	Stock	106.993	107.04	106.91	106.999	539198.0
2019-02-13 13:30:00	MSFT	Stock	107.0	107.04	106.911	106.92	523119.0

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

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