PREVIEW / stock_30min / 2019-12-16

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-16.parquet
  size:    1.8 MB
  rows:    88,133
  symbols: 2,521

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-12-16 04:00:00	AAPL	Stock	68.94	69.1475	68.94	69.1475	24916.0
2019-12-16 04:30:00	AAPL	Stock	69.125	69.205	69.125	69.205	8360.0
2019-12-16 05:00:00	AAPL	Stock	69.1775	69.1775	69.115	69.115	9000.0
2019-12-16 05:30:00	AAPL	Stock	69.115	69.125	69.05	69.1125	28564.0
2019-12-16 06:00:00	AAPL	Stock	69.1325	69.2	69.1125	69.2	7688.0
2019-12-16 06:30:00	AAPL	Stock	69.1625	69.1625	69.1625	69.1625	1200.0
2019-12-16 07:00:00	AAPL	Stock	69.125	69.2	69.085	69.1875	149104.0
2019-12-16 07:30:00	AAPL	Stock	69.175	69.2375	69.17	69.235	60996.0
2019-12-16 08:00:00	AAPL	Stock	69.1125	69.3575	69.085	69.29	597244.0
2019-12-16 08:30:00	AAPL	Stock	69.2875	69.325	69.25	69.2875	227564.0
2019-12-16 09:00:00	AAPL	Stock	69.3	69.365	69.1875	69.245	390840.0
2019-12-16 09:30:00	AAPL	Stock	69.25	69.8725	69.245	69.75	20585980.0
2019-12-16 10:00:00	AAPL	Stock	69.7488	70.02	69.7175	70.0025	12610068.0
2019-12-16 10:30:00	AAPL	Stock	70.004	70.0412	69.855	69.8675	6044980.0
2019-12-16 11:00:00	AAPL	Stock	69.8688	70.1175	69.8662	70.0597	6848604.0
2019-12-16 11:30:00	AAPL	Stock	70.055	70.1125	70.039	70.09	3172720.0
2019-12-16 12:00:00	AAPL	Stock	70.09	70.1975	70.0875	70.145	4750064.0
2019-12-16 12:30:00	AAPL	Stock	70.1475	70.1475	70.0375	70.0468	3527908.0
2019-12-16 13:00:00	AAPL	Stock	70.0462	70.065	69.9583	70.0082	3149940.0
2019-12-16 13:30:00	AAPL	Stock	70.0075	70.125	69.9988	70.1088	2882720.0
2019-12-16 14:00:00	AAPL	Stock	70.1075	70.15	70.0052	70.0225	3593136.0
2019-12-16 14:30:00	AAPL	Stock	70.0225	70.0775	69.9475	70.0375	4336000.0
2019-12-16 15:00:00	AAPL	Stock	70.04	70.125	70.0125	70.0925	4077904.0
2019-12-16 15:30:00	AAPL	Stock	70.09	70.1225	69.9	69.965	9243148.0
2019-12-16 16:00:00	AAPL	Stock	69.965	70.095	69.9425	70.095	14077456.0
2019-12-16 16:30:00	AAPL	Stock	70.0875	70.09	69.965	70.0625	2308216.0
2019-12-16 17:00:00	AAPL	Stock	70.0625	70.0625	70.0275	70.04	29952.0
2019-12-16 17:30:00	AAPL	Stock	70.0275	70.0475	70.0275	70.03	5000.0
2019-12-16 18:00:00	AAPL	Stock	70.0475	70.0625	70.0475	70.05	10392.0
2019-12-16 18:30:00	AAPL	Stock	70.0425	70.0425	70.005	70.015	37436.0
2019-12-16 19:00:00	AAPL	Stock	70.02	70.02	69.965	70.0	27416.0
2019-12-16 19:30:00	AAPL	Stock	69.975	70.0625	69.975	70.0625	48280.0
2019-12-16 04:00:00	MSFT	Stock	155.2	155.4	155.2	155.3	5240.0
2019-12-16 04:30:00	MSFT	Stock	155.25	155.25	155.25	155.25	100.0
2019-12-16 05:00:00	MSFT	Stock	155.39	155.43	155.31	155.31	1700.0
2019-12-16 05:30:00	MSFT	Stock	155.25	155.26	155.1	155.1	600.0
2019-12-16 06:00:00	MSFT	Stock	155.17	155.34	155.17	155.34	772.0
2019-12-16 06:30:00	MSFT	Stock	155.24	155.24	155.24	155.24	100.0
2019-12-16 07:00:00	MSFT	Stock	155.17	155.34	155.15	155.21	7185.0
2019-12-16 07:30:00	MSFT	Stock	155.3	155.35	155.24	155.29	6137.0
2019-12-16 08:00:00	MSFT	Stock	155.15	155.43	155.15	155.3	30476.0
2019-12-16 08:30:00	MSFT	Stock	155.26	155.35	155.21	155.3	19852.0
2019-12-16 09:00:00	MSFT	Stock	155.2	155.4	154.53	155.06	216296.0
2019-12-16 09:30:00	MSFT	Stock	155.13	155.9	154.82	155.57	2776488.0
2019-12-16 10:00:00	MSFT	Stock	155.57	155.61	155.16	155.44	1365414.0
2019-12-16 10:30:00	MSFT	Stock	155.44	155.51	155.265	155.318	931878.0
2019-12-16 11:00:00	MSFT	Stock	155.32	155.35	155.133	155.247	827073.0
2019-12-16 11:30:00	MSFT	Stock	155.248	155.3	155.13	155.25	590166.0
2019-12-16 12:00:00	MSFT	Stock	155.244	155.36	155.18	155.315	843147.0
2019-12-16 12:30:00	MSFT	Stock	155.312	155.36	155.21	155.265	513610.0

> showing 50 of 88,133 rows — these rows as CSV

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