PREVIEW / stock_30min / 2018-02-22

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-22.parquet
  size:    1.6 MB
  rows:    82,514
  symbols: 2,872

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-02-22 04:00:00	AAPL	Stock	42.6375	42.6375	42.5	42.5	4008.0
2018-02-22 04:30:00	AAPL	Stock	42.525	42.7125	42.525	42.7	73828.0
2018-02-22 05:00:00	AAPL	Stock	42.7	42.745	42.6925	42.745	2488.0
2018-02-22 05:30:00	AAPL	Stock	42.7925	42.82	42.74	42.74	3096.0
2018-02-22 06:00:00	AAPL	Stock	42.785	42.925	42.7025	42.8775	43604.0
2018-02-22 06:30:00	AAPL	Stock	42.925	42.9925	42.8075	42.8375	23252.0
2018-02-22 07:00:00	AAPL	Stock	42.8625	42.9975	42.8625	42.9775	180084.0
2018-02-22 07:30:00	AAPL	Stock	42.97	43.0	42.915	42.915	114044.0
2018-02-22 08:00:00	AAPL	Stock	42.9263	42.9975	42.845	42.9125	202476.0
2018-02-22 08:30:00	AAPL	Stock	42.925	43.04	42.925	42.995	306612.0
2018-02-22 09:00:00	AAPL	Stock	42.99	43.07	42.9	42.9525	388184.0
2018-02-22 09:30:00	AAPL	Stock	42.9625	43.3425	42.9275	43.1888	17109896.0
2018-02-22 10:00:00	AAPL	Stock	43.195	43.3825	43.105	43.3237	10126392.0
2018-02-22 10:30:00	AAPL	Stock	43.3225	43.475	43.3125	43.37	9166688.0
2018-02-22 11:00:00	AAPL	Stock	43.3665	43.48	43.365	43.3925	6077804.0
2018-02-22 11:30:00	AAPL	Stock	43.39	43.4875	43.2778	43.4538	6525884.0
2018-02-22 12:00:00	AAPL	Stock	43.455	43.4775	43.375	43.397	4168616.0
2018-02-22 12:30:00	AAPL	Stock	43.3975	43.4125	43.1825	43.26	5880624.0
2018-02-22 13:00:00	AAPL	Stock	43.2525	43.345	43.1375	43.2625	6646860.0
2018-02-22 13:30:00	AAPL	Stock	43.264	43.275	43.0775	43.21	5247084.0
2018-02-22 14:00:00	AAPL	Stock	43.21	43.3162	43.175	43.3075	4777744.0
2018-02-22 14:30:00	AAPL	Stock	43.31	43.3375	43.0225	43.06	5724920.0
2018-02-22 15:00:00	AAPL	Stock	43.0625	43.2175	42.9525	43.155	9758932.0
2018-02-22 15:30:00	AAPL	Stock	43.1525	43.25	43.0175	43.1525	13462400.0
2018-02-22 16:00:00	AAPL	Stock	43.125	43.25	43.125	43.1925	6371800.0
2018-02-22 16:30:00	AAPL	Stock	43.2	43.25	43.125	43.2275	444476.0
2018-02-22 17:00:00	AAPL	Stock	43.2475	43.2475	43.21	43.21	11996.0
2018-02-22 17:30:00	AAPL	Stock	43.225	43.225	43.1875	43.2	9964.0
2018-02-22 18:00:00	AAPL	Stock	43.19	43.2175	43.19	43.2075	2800.0
2018-02-22 18:30:00	AAPL	Stock	43.2175	43.22	43.2025	43.22	26872.0
2018-02-22 19:00:00	AAPL	Stock	43.22	43.225	43.215	43.215	26544.0
2018-02-22 19:30:00	AAPL	Stock	43.2075	43.275	43.2075	43.255	48396.0
2018-02-22 04:00:00	MSFT	Stock	91.15	91.17	90.98	91.16	2263.0
2018-02-22 05:00:00	MSFT	Stock	91.24	91.24	91.24	91.24	107.0
2018-02-22 05:30:00	MSFT	Stock	91.49	91.5	91.26	91.26	3723.0
2018-02-22 06:30:00	MSFT	Stock	91.61	91.61	91.6	91.6	3250.0
2018-02-22 07:00:00	MSFT	Stock	91.55	91.79	91.55	91.79	22983.0
2018-02-22 07:30:00	MSFT	Stock	91.85	91.9	91.69	91.69	5299.0
2018-02-22 08:00:00	MSFT	Stock	91.76	91.95	91.62	91.71	9059.0
2018-02-22 08:30:00	MSFT	Stock	91.69	91.95	91.69	91.85	15297.0
2018-02-22 09:00:00	MSFT	Stock	91.94	92.1	91.86	92.05	19702.0
2018-02-22 09:30:00	MSFT	Stock	92.07	92.47	91.78	92.01	2311535.0
2018-02-22 10:00:00	MSFT	Stock	92.01	92.35	91.71	92.31	1323776.0
2018-02-22 10:30:00	MSFT	Stock	92.32	92.6	92.2	92.35	1314468.0
2018-02-22 11:00:00	MSFT	Stock	92.36	92.66	92.34	92.54	925902.0
2018-02-22 11:30:00	MSFT	Stock	92.54	92.69	92.28	92.59	758759.0
2018-02-22 12:00:00	MSFT	Stock	92.59	92.73	92.32	92.37	810520.0
2018-02-22 12:30:00	MSFT	Stock	92.38	92.41	91.6	91.86	1479202.0
2018-02-22 13:00:00	MSFT	Stock	91.86	92.05	91.671	91.79	896567.0
2018-02-22 13:30:00	MSFT	Stock	91.8	91.87	91.36	91.8	1184841.0

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

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