PREVIEW / stock_30min / 2019-02-14

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-14.parquet
  size:    1.7 MB
  rows:    84,108
  symbols: 2,647

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-14 04:00:00	AAPL	Stock	42.6525	42.7225	42.6475	42.695	15688.0
2019-02-14 04:30:00	AAPL	Stock	42.6775	42.6775	42.675	42.675	800.0
2019-02-14 05:30:00	AAPL	Stock	42.6425	42.6425	42.64	42.64	2396.0
2019-02-14 06:00:00	AAPL	Stock	42.6575	42.675	42.625	42.675	14400.0
2019-02-14 07:00:00	AAPL	Stock	42.6275	42.67	42.625	42.66	24684.0
2019-02-14 07:30:00	AAPL	Stock	42.655	42.66	42.605	42.605	34440.0
2019-02-14 08:00:00	AAPL	Stock	42.6375	42.6575	42.6	42.635	48732.0
2019-02-14 08:30:00	AAPL	Stock	42.6375	42.6375	42.3925	42.4	170424.0
2019-02-14 09:00:00	AAPL	Stock	42.4	42.4725	42.2875	42.4725	296316.0
2019-02-14 09:30:00	AAPL	Stock	42.4275	42.7	42.345	42.6638	12003492.0
2019-02-14 10:00:00	AAPL	Stock	42.6638	42.8155	42.61	42.77	7822048.0
2019-02-14 10:30:00	AAPL	Stock	42.7725	42.78	42.4775	42.6412	8063788.0
2019-02-14 11:00:00	AAPL	Stock	42.645	42.665	42.525	42.5675	3726496.0
2019-02-14 11:30:00	AAPL	Stock	42.57	42.675	42.475	42.67	3906968.0
2019-02-14 12:00:00	AAPL	Stock	42.67	42.8075	42.625	42.7225	4561976.0
2019-02-14 12:30:00	AAPL	Stock	42.7225	42.8075	42.7075	42.7525	2764756.0
2019-02-14 13:00:00	AAPL	Stock	42.7525	42.8	42.74	42.7575	2576516.0
2019-02-14 13:30:00	AAPL	Stock	42.7602	42.7925	42.715	42.7188	2196128.0
2019-02-14 14:00:00	AAPL	Stock	42.718	42.795	42.6775	42.775	2941848.0
2019-02-14 14:30:00	AAPL	Stock	42.7775	42.78	42.685	42.7	2676692.0
2019-02-14 15:00:00	AAPL	Stock	42.7025	42.78	42.6025	42.6725	4373788.0
2019-02-14 15:30:00	AAPL	Stock	42.67	42.79	42.6428	42.6975	6936968.0
2019-02-14 16:00:00	AAPL	Stock	42.7	42.7	42.1775	42.57	10245416.0
2019-02-14 16:30:00	AAPL	Stock	42.57	42.5975	42.385	42.4	264184.0
2019-02-14 17:00:00	AAPL	Stock	42.405	42.7	42.375	42.4275	275268.0
2019-02-14 17:30:00	AAPL	Stock	42.4275	42.5	42.4275	42.5	38396.0
2019-02-14 18:00:00	AAPL	Stock	42.5	42.5025	42.4525	42.4575	21296.0
2019-02-14 18:30:00	AAPL	Stock	42.475	42.475	42.4625	42.475	13700.0
2019-02-14 19:00:00	AAPL	Stock	42.4625	42.465	42.4125	42.4625	54944.0
2019-02-14 19:30:00	AAPL	Stock	42.45	42.48	42.3925	42.4	42664.0
2019-02-14 04:00:00	MSFT	Stock	107.07	107.07	107.07	107.07	100.0
2019-02-14 05:30:00	MSFT	Stock	107.09	107.09	107.09	107.09	200.0
2019-02-14 06:00:00	MSFT	Stock	107.09	107.25	107.09	107.2	700.0
2019-02-14 07:00:00	MSFT	Stock	107.12	107.16	107.09	107.16	1800.0
2019-02-14 07:30:00	MSFT	Stock	107.09	107.13	107.06	107.06	1497.0
2019-02-14 08:00:00	MSFT	Stock	107.1	107.169	107.03	107.09	17415.0
2019-02-14 08:30:00	MSFT	Stock	107.04	107.04	106.46	106.49	20902.0
2019-02-14 09:00:00	MSFT	Stock	106.37	106.4	106.17	106.276	14701.0
2019-02-14 09:30:00	MSFT	Stock	106.31	106.5	105.66	106.29	2397007.0
2019-02-14 10:00:00	MSFT	Stock	106.27	106.615	106.13	106.49	1754790.0
2019-02-14 10:30:00	MSFT	Stock	106.49	106.77	105.9	106.25	1777196.0
2019-02-14 11:00:00	MSFT	Stock	106.25	106.357	106.02	106.09	1121918.0
2019-02-14 11:30:00	MSFT	Stock	106.1	106.63	105.98	106.505	784164.0
2019-02-14 12:00:00	MSFT	Stock	106.51	107.22	106.41	107.195	1097965.0
2019-02-14 12:30:00	MSFT	Stock	107.2	107.215	106.95	106.995	675122.0
2019-02-14 13:00:00	MSFT	Stock	107.0	107.06	106.79	106.853	627058.0
2019-02-14 13:30:00	MSFT	Stock	106.86	106.975	106.81	106.89	450569.0
2019-02-14 14:00:00	MSFT	Stock	106.89	107.148	106.785	107.02	710316.0
2019-02-14 14:30:00	MSFT	Stock	107.024	107.1	106.825	106.92	704159.0
2019-02-14 15:00:00	MSFT	Stock	106.92	107.29	106.9	107.06	1414592.0

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

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