PREVIEW / stock_30min / 2019-08-14

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-14.parquet
  size:    1.8 MB
  rows:    87,070
  symbols: 2,570

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-14 04:00:00	AAPL	Stock	52.2375	52.2375	52.05	52.1275	4884.0
2019-08-14 04:30:00	AAPL	Stock	52.205	52.2075	52.0875	52.0875	1920.0
2019-08-14 05:00:00	AAPL	Stock	52.045	52.045	51.9	51.975	8988.0
2019-08-14 05:30:00	AAPL	Stock	51.9325	51.975	51.835	51.8525	6056.0
2019-08-14 06:00:00	AAPL	Stock	51.8075	51.8075	51.465	51.475	30764.0
2019-08-14 06:30:00	AAPL	Stock	51.575	51.6375	51.5025	51.5625	20000.0
2019-08-14 07:00:00	AAPL	Stock	51.54	51.7525	51.54	51.6025	208656.0
2019-08-14 07:30:00	AAPL	Stock	51.6	51.6325	51.25	51.3325	265552.0
2019-08-14 08:00:00	AAPL	Stock	51.7028	52.1125	50.96	51.0475	872220.0
2019-08-14 08:30:00	AAPL	Stock	51.075	51.08	50.93	51.05	561740.0
2019-08-14 09:00:00	AAPL	Stock	51.06	51.07	50.72	50.81	758824.0
2019-08-14 09:30:00	AAPL	Stock	50.8125	51.61	50.675	51.5175	22032640.0
2019-08-14 10:00:00	AAPL	Stock	51.505	51.515	51.15	51.4025	9901380.0
2019-08-14 10:30:00	AAPL	Stock	51.4025	51.4475	51.075	51.0775	8544176.0
2019-08-14 11:00:00	AAPL	Stock	51.0788	51.2375	50.9875	51.14	7450272.0
2019-08-14 11:30:00	AAPL	Stock	51.13	51.2025	50.8175	50.8868	6225508.0
2019-08-14 12:00:00	AAPL	Stock	50.885	50.905	50.6775	50.7975	7281984.0
2019-08-14 12:30:00	AAPL	Stock	50.7975	50.9762	50.7625	50.815	4979108.0
2019-08-14 13:00:00	AAPL	Stock	50.81	51.0575	50.7025	50.9475	5776016.0
2019-08-14 13:30:00	AAPL	Stock	50.9478	51.115	50.9075	50.9725	4801392.0
2019-08-14 14:00:00	AAPL	Stock	50.9725	50.9975	50.7775	50.7858	4130052.0
2019-08-14 14:30:00	AAPL	Stock	50.7875	50.835	50.6468	50.7525	5118952.0
2019-08-14 15:00:00	AAPL	Stock	50.7475	50.99	50.66	50.8325	7603752.0
2019-08-14 15:30:00	AAPL	Stock	50.83	50.8948	50.65	50.6875	11288044.0
2019-08-14 16:00:00	AAPL	Stock	50.685	50.981	50.5875	50.68	12739128.0
2019-08-14 16:30:00	AAPL	Stock	50.6425	50.6775	50.5875	50.6225	45980.0
2019-08-14 17:00:00	AAPL	Stock	50.5875	50.62	50.5125	50.5125	41752.0
2019-08-14 17:30:00	AAPL	Stock	50.5125	50.6875	50.5125	50.55	78068.0
2019-08-14 18:00:00	AAPL	Stock	50.55	50.555	50.3875	50.4875	123148.0
2019-08-14 18:30:00	AAPL	Stock	50.5	50.5425	50.4375	50.4375	103384.0
2019-08-14 19:00:00	AAPL	Stock	50.415	50.5225	50.4075	50.5	38232.0
2019-08-14 19:30:00	AAPL	Stock	50.4625	50.625	50.4625	50.6	130920.0
2019-08-14 04:30:00	MSFT	Stock	138.21	138.21	137.94	138.02	2500.0
2019-08-14 05:00:00	MSFT	Stock	137.36	137.45	137.04	137.45	1174.0
2019-08-14 05:30:00	MSFT	Stock	137.76	137.76	137.76	137.76	100.0
2019-08-14 06:00:00	MSFT	Stock	137.5	137.5	137.0	137.0	699.0
2019-08-14 06:30:00	MSFT	Stock	137.25	137.35	137.17	137.17	612.0
2019-08-14 07:00:00	MSFT	Stock	137.29	137.33	137.0	137.1	40874.0
2019-08-14 07:30:00	MSFT	Stock	137.15	137.15	136.4	136.45	37300.0
2019-08-14 08:00:00	MSFT	Stock	137.25	137.3	136.3	136.55	54925.0
2019-08-14 08:30:00	MSFT	Stock	136.452	136.65	136.26	136.57	17267.0
2019-08-14 09:00:00	MSFT	Stock	136.416	136.56	135.81	136.25	25633.0
2019-08-14 09:30:00	MSFT	Stock	136.36	136.92	135.69	136.38	2460929.0
2019-08-14 10:00:00	MSFT	Stock	136.385	136.4	135.59	135.93	1415176.0
2019-08-14 10:30:00	MSFT	Stock	135.92	135.96	135.02	135.146	1200914.0
2019-08-14 11:00:00	MSFT	Stock	135.145	135.34	134.58	134.95	1833180.0
2019-08-14 11:30:00	MSFT	Stock	134.94	135.26	134.25	134.37	1334623.0
2019-08-14 12:00:00	MSFT	Stock	134.36	134.36	133.985	134.244	1487288.0
2019-08-14 12:30:00	MSFT	Stock	134.24	134.575	133.84	133.91	1164481.0
2019-08-14 13:00:00	MSFT	Stock	133.91	134.95	133.67	134.64	1347640.0

> showing 50 of 87,070 rows — these rows as CSV

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