PREVIEW / stock_30min / 2018-05-14

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-05-14.parquet
  size:    1.7 MB
  rows:    83,723
  symbols: 2,858

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
2018-05-14 04:00:00	AAPL	Stock	47.255	47.335	47.215	47.3	6008.0
2018-05-14 04:30:00	AAPL	Stock	47.28	47.3375	47.28	47.3375	12556.0
2018-05-14 05:00:00	AAPL	Stock	47.3325	47.3325	47.28	47.2825	3184.0
2018-05-14 05:30:00	AAPL	Stock	47.33	47.33	47.2875	47.2875	1400.0
2018-05-14 06:00:00	AAPL	Stock	47.325	47.3325	47.3	47.3	13064.0
2018-05-14 06:30:00	AAPL	Stock	47.3175	47.3175	47.275	47.275	16764.0
2018-05-14 07:00:00	AAPL	Stock	47.28	47.3225	47.2275	47.25	39000.0
2018-05-14 07:30:00	AAPL	Stock	47.255	47.29	47.2275	47.2625	134260.0
2018-05-14 08:00:00	AAPL	Stock	47.295	47.31	47.225	47.2575	114036.0
2018-05-14 08:30:00	AAPL	Stock	47.255	47.275	47.2125	47.225	113152.0
2018-05-14 09:00:00	AAPL	Stock	47.2075	47.2725	47.2075	47.2325	140812.0
2018-05-14 09:30:00	AAPL	Stock	47.2525	47.3825	47.0875	47.105	11225988.0
2018-05-14 10:00:00	AAPL	Stock	47.111	47.32	47.065	47.315	7300060.0
2018-05-14 10:30:00	AAPL	Stock	47.3162	47.3575	47.22	47.225	5199348.0
2018-05-14 11:00:00	AAPL	Stock	47.2275	47.3625	47.2075	47.295	3822356.0
2018-05-14 11:30:00	AAPL	Stock	47.2975	47.3425	47.215	47.2475	2939440.0
2018-05-14 12:00:00	AAPL	Stock	47.2475	47.2835	47.1902	47.235	3291332.0
2018-05-14 12:30:00	AAPL	Stock	47.2325	47.32	47.2	47.2	2519148.0
2018-05-14 13:00:00	AAPL	Stock	47.2025	47.2075	47.0875	47.1462	3506500.0
2018-05-14 13:30:00	AAPL	Stock	47.1475	47.1625	47.0875	47.12	2633760.0
2018-05-14 14:00:00	AAPL	Stock	47.1185	47.125	46.9825	47.073	3472912.0
2018-05-14 14:30:00	AAPL	Stock	47.0712	47.115	47.0275	47.0912	2599484.0
2018-05-14 15:00:00	AAPL	Stock	47.0925	47.142	47.055	47.1	3075928.0
2018-05-14 15:30:00	AAPL	Stock	47.1	47.12	46.965	47.0425	7540580.0
2018-05-14 16:00:00	AAPL	Stock	47.0375	47.06	47.01	47.0325	12906196.0
2018-05-14 16:30:00	AAPL	Stock	47.0375	47.0375	47.0025	47.0125	51856.0
2018-05-14 17:00:00	AAPL	Stock	47.015	47.0375	47.0025	47.0225	96412.0
2018-05-14 17:30:00	AAPL	Stock	47.0075	47.0075	46.98	46.98	30168.0
2018-05-14 18:00:00	AAPL	Stock	47.0	47.0175	47.0	47.0	28224.0
2018-05-14 18:30:00	AAPL	Stock	47.0125	47.0125	46.9775	46.98	9048.0
2018-05-14 19:00:00	AAPL	Stock	46.9875	47.0	46.975	46.975	8540.0
2018-05-14 19:30:00	AAPL	Stock	46.975	46.975	46.955	46.955	27200.0
2018-05-14 05:00:00	MSFT	Stock	98.0	98.2	98.0	98.2	500.0
2018-05-14 05:30:00	MSFT	Stock	98.19	98.24	98.19	98.24	983.0
2018-05-14 06:00:00	MSFT	Stock	98.19	98.19	98.05	98.05	700.0
2018-05-14 06:30:00	MSFT	Stock	98.08	98.1	98.03	98.03	1000.0
2018-05-14 07:00:00	MSFT	Stock	98.0	98.09	98.0	98.08	3595.0
2018-05-14 07:30:00	MSFT	Stock	98.08	98.08	97.97	97.98	1234.0
2018-05-14 08:00:00	MSFT	Stock	97.96	98.02	97.96	98.02	8862.0
2018-05-14 08:30:00	MSFT	Stock	97.96	97.98	97.91	97.91	3252.0
2018-05-14 09:00:00	MSFT	Stock	97.95	97.97	97.75	97.82	14542.0
2018-05-14 09:30:00	MSFT	Stock	97.79	98.43	97.31	98.23	2962829.0
2018-05-14 10:00:00	MSFT	Stock	98.23	98.32	98.04	98.27	1023140.0
2018-05-14 10:30:00	MSFT	Stock	98.278	98.58	98.27	98.38	1203796.0
2018-05-14 11:00:00	MSFT	Stock	98.37	98.69	98.34	98.45	951656.0
2018-05-14 11:30:00	MSFT	Stock	98.45	98.5	98.29	98.36	779261.0
2018-05-14 12:00:00	MSFT	Stock	98.35	98.49	98.21	98.32	713565.0
2018-05-14 12:30:00	MSFT	Stock	98.32	98.35	98.01	98.065	683967.0
2018-05-14 13:00:00	MSFT	Stock	98.065	98.1	97.77	97.969	957484.0
2018-05-14 13:30:00	MSFT	Stock	97.97	98.16	97.81	98.12	532833.0

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

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