PREVIEW / stock_30min / 2019-08-16

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-16.parquet
  size:    1.7 MB
  rows:    84,042
  symbols: 2,567

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-08-16 04:00:00	AAPL	Stock	50.825	51.15	50.825	51.1225	6016.0
2019-08-16 04:30:00	AAPL	Stock	51.1125	51.1825	51.025	51.175	7108.0
2019-08-16 05:00:00	AAPL	Stock	51.1475	51.165	51.1475	51.15	2836.0
2019-08-16 05:30:00	AAPL	Stock	51.125	51.155	51.0925	51.155	26064.0
2019-08-16 06:00:00	AAPL	Stock	51.155	51.155	51.15	51.15	1884.0
2019-08-16 06:30:00	AAPL	Stock	51.1475	51.155	51.0875	51.0875	3808.0
2019-08-16 07:00:00	AAPL	Stock	51.125	51.175	51.0725	51.125	64852.0
2019-08-16 07:30:00	AAPL	Stock	51.1025	51.1625	51.065	51.0725	56380.0
2019-08-16 08:00:00	AAPL	Stock	51.125	51.175	51.035	51.0625	221692.0
2019-08-16 08:30:00	AAPL	Stock	51.1	51.1	50.975	51.0125	199804.0
2019-08-16 09:00:00	AAPL	Stock	51.0125	51.1	50.8325	50.94	505336.0
2019-08-16 09:30:00	AAPL	Stock	51.07	51.25	50.96	51.18	15381324.0
2019-08-16 10:00:00	AAPL	Stock	51.1725	51.42	51.1025	51.3125	11057932.0
2019-08-16 10:30:00	AAPL	Stock	51.3125	51.69	51.2725	51.68	8681212.0
2019-08-16 11:00:00	AAPL	Stock	51.675	51.79	51.55	51.5522	8412760.0
2019-08-16 11:30:00	AAPL	Stock	51.55	51.6125	51.455	51.5155	5311408.0
2019-08-16 12:00:00	AAPL	Stock	51.5175	51.5275	51.3725	51.4335	3701588.0
2019-08-16 12:30:00	AAPL	Stock	51.434	51.5875	51.4062	51.5472	3404300.0
2019-08-16 13:00:00	AAPL	Stock	51.5475	51.7375	51.545	51.7175	3721472.0
2019-08-16 13:30:00	AAPL	Stock	51.7162	51.785	51.6675	51.711	3350412.0
2019-08-16 14:00:00	AAPL	Stock	51.7125	51.7162	51.5575	51.6	2969264.0
2019-08-16 14:30:00	AAPL	Stock	51.5975	51.6763	51.525	51.5382	3494872.0
2019-08-16 15:00:00	AAPL	Stock	51.535	51.6675	51.5188	51.6025	3903800.0
2019-08-16 15:30:00	AAPL	Stock	51.6	51.7375	51.5375	51.61	10260140.0
2019-08-16 16:00:00	AAPL	Stock	51.61	51.6575	50.435	51.625	8876632.0
2019-08-16 16:30:00	AAPL	Stock	51.65	51.7	51.65	51.7	124620.0
2019-08-16 17:00:00	AAPL	Stock	51.7125	51.7125	51.67	51.67	42124.0
2019-08-16 17:30:00	AAPL	Stock	51.675	51.675	51.625	51.655	17336.0
2019-08-16 18:00:00	AAPL	Stock	51.625	51.675	51.625	51.625	14980.0
2019-08-16 18:30:00	AAPL	Stock	51.675	51.675	51.6275	51.67	3824.0
2019-08-16 19:00:00	AAPL	Stock	51.6375	51.67	51.6375	51.665	13724.0
2019-08-16 19:30:00	AAPL	Stock	51.675	51.675	51.6125	51.6125	12932.0
2019-08-16 04:00:00	MSFT	Stock	135.23	135.23	134.76	134.76	574.0
2019-08-16 04:30:00	MSFT	Stock	135.29	135.29	135.29	135.29	100.0
2019-08-16 05:30:00	MSFT	Stock	135.45	135.48	135.38	135.38	1237.0
2019-08-16 07:00:00	MSFT	Stock	135.51	135.51	135.16	135.16	7654.0
2019-08-16 07:30:00	MSFT	Stock	135.17	135.32	134.98	134.98	7876.0
2019-08-16 08:00:00	MSFT	Stock	135.21	135.515	134.92	135.08	43907.0
2019-08-16 08:30:00	MSFT	Stock	135.07	135.19	134.95	135.061	27346.0
2019-08-16 09:00:00	MSFT	Stock	135.1	135.34	134.56	134.96	122591.0
2019-08-16 09:30:00	MSFT	Stock	134.96	135.45	134.75	134.91	3789707.0
2019-08-16 10:00:00	MSFT	Stock	134.92	135.68	134.72	135.1	1775155.0
2019-08-16 10:30:00	MSFT	Stock	135.08	136.045	135.06	136.03	1449866.0
2019-08-16 11:00:00	MSFT	Stock	136.025	136.2	135.65	135.845	1170168.0
2019-08-16 11:30:00	MSFT	Stock	135.84	135.98	135.52	135.85	1063120.0
2019-08-16 12:00:00	MSFT	Stock	135.85	135.93	135.51	135.81	615508.0
2019-08-16 12:30:00	MSFT	Stock	135.807	136.24	135.75	135.99	1181801.0
2019-08-16 13:00:00	MSFT	Stock	135.99	136.33	135.9	136.29	670131.0
2019-08-16 13:30:00	MSFT	Stock	136.3	136.32	135.93	136.166	927500.0
2019-08-16 14:00:00	MSFT	Stock	136.17	136.19	135.81	135.93	580495.0

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

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