PREVIEW / stock_30min / 2019-04-17

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-04-17.parquet
  size:    1.7 MB
  rows:    84,342
  symbols: 2,634

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-04-17 04:00:00	AAPL	Stock	49.725	49.725	49.6725	49.725	26600.0
2019-04-17 04:30:00	AAPL	Stock	49.745	49.745	49.745	49.745	400.0
2019-04-17 05:00:00	AAPL	Stock	49.75	49.75	49.75	49.75	3836.0
2019-04-17 05:30:00	AAPL	Stock	49.775	49.825	49.775	49.825	13348.0
2019-04-17 06:00:00	AAPL	Stock	49.85	49.8775	49.85	49.8575	16856.0
2019-04-17 06:30:00	AAPL	Stock	49.85	49.8725	49.8125	49.8725	6148.0
2019-04-17 07:00:00	AAPL	Stock	49.8175	50.0	49.8125	49.9475	92692.0
2019-04-17 07:30:00	AAPL	Stock	49.975	50.01	49.8925	49.8925	57728.0
2019-04-17 08:00:00	AAPL	Stock	49.86	50.04	49.8175	49.9525	165988.0
2019-04-17 08:30:00	AAPL	Stock	49.9525	50.0475	49.9	50.025	160296.0
2019-04-17 09:00:00	AAPL	Stock	50.0025	50.2125	49.815	49.895	562728.0
2019-04-17 09:30:00	AAPL	Stock	49.895	50.325	49.6525	49.99	21621732.0
2019-04-17 10:00:00	AAPL	Stock	50.0025	50.3925	49.9075	50.365	9203292.0
2019-04-17 10:30:00	AAPL	Stock	50.3725	50.395	50.2275	50.3425	6090376.0
2019-04-17 11:00:00	AAPL	Stock	50.345	50.48	50.3375	50.39	5152748.0
2019-04-17 11:30:00	AAPL	Stock	50.3875	50.5	50.3	50.4708	4584500.0
2019-04-17 12:00:00	AAPL	Stock	50.4705	50.5	50.38	50.4905	3934076.0
2019-04-17 12:30:00	AAPL	Stock	50.495	50.6175	50.4825	50.615	5514396.0
2019-04-17 13:00:00	AAPL	Stock	50.6175	50.775	50.6075	50.6875	5955912.0
2019-04-17 13:30:00	AAPL	Stock	50.69	50.82	50.685	50.7525	4749516.0
2019-04-17 14:00:00	AAPL	Stock	50.7548	50.77	50.565	50.575	6447908.0
2019-04-17 14:30:00	AAPL	Stock	50.575	50.7625	50.5675	50.71	4745780.0
2019-04-17 15:00:00	AAPL	Stock	50.715	50.8	50.6925	50.695	4549496.0
2019-04-17 15:30:00	AAPL	Stock	50.6975	50.845	50.6875	50.78	10413056.0
2019-04-17 16:00:00	AAPL	Stock	50.78	50.8375	50.75	50.7525	6076104.0
2019-04-17 16:30:00	AAPL	Stock	50.75	50.76	50.74	50.75	29076.0
2019-04-17 17:00:00	AAPL	Stock	50.74	50.75	50.74	50.7425	30332.0
2019-04-17 17:30:00	AAPL	Stock	50.74	50.7625	50.74	50.7625	12596.0
2019-04-17 18:00:00	AAPL	Stock	50.75	50.7525	50.745	50.75	31736.0
2019-04-17 18:30:00	AAPL	Stock	50.745	50.77	50.7375	50.77	50416.0
2019-04-17 19:00:00	AAPL	Stock	50.77	50.77	50.745	50.745	10204.0
2019-04-17 19:30:00	AAPL	Stock	50.745	50.775	50.745	50.775	40440.0
2019-04-17 04:00:00	MSFT	Stock	121.19	121.19	121.15	121.15	300.0
2019-04-17 04:30:00	MSFT	Stock	121.25	121.25	121.21	121.21	600.0
2019-04-17 07:00:00	MSFT	Stock	121.15	121.16	120.85	120.85	17039.0
2019-04-17 07:30:00	MSFT	Stock	120.85	121.0	120.76	120.76	6302.0
2019-04-17 08:00:00	MSFT	Stock	121.15	121.15	120.72	120.73	36952.0
2019-04-17 08:30:00	MSFT	Stock	120.77	120.9	120.7	120.72	17588.0
2019-04-17 09:00:00	MSFT	Stock	120.75	121.21	120.7	121.21	17634.0
2019-04-17 09:30:00	MSFT	Stock	121.19	121.44	120.795	120.84	2276594.0
2019-04-17 10:00:00	MSFT	Stock	120.84	121.189	120.54	121.12	1500576.0
2019-04-17 10:30:00	MSFT	Stock	121.125	121.316	121.01	121.06	1091001.0
2019-04-17 11:00:00	MSFT	Stock	121.057	121.18	120.91	121.01	819481.0
2019-04-17 11:30:00	MSFT	Stock	121.01	121.34	120.89	121.165	1054540.0
2019-04-17 12:00:00	MSFT	Stock	121.165	121.24	120.91	121.23	970007.0
2019-04-17 12:30:00	MSFT	Stock	121.23	121.47	121.2	121.41	777570.0
2019-04-17 13:00:00	MSFT	Stock	121.41	121.49	121.21	121.24	682315.0
2019-04-17 13:30:00	MSFT	Stock	121.25	121.58	121.2	121.35	888020.0
2019-04-17 14:00:00	MSFT	Stock	121.35	121.446	121.17	121.205	638180.0
2019-04-17 14:30:00	MSFT	Stock	121.21	121.42	121.185	121.36	662607.0

> showing 50 of 84,342 rows — these rows as CSV

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