PREVIEW / stock_30min / 2019-08-08

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-08.parquet
  size:    1.7 MB
  rows:    85,796
  symbols: 2,578

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-08 04:00:00	AAPL	Stock	49.9	50.075	49.8375	50.0125	14456.0
2019-08-08 04:30:00	AAPL	Stock	50.0125	50.0675	49.9775	50.06	8324.0
2019-08-08 05:00:00	AAPL	Stock	50.0	50.06	50.0	50.0325	12244.0
2019-08-08 05:30:00	AAPL	Stock	50.035	50.035	50.0	50.0275	18716.0
2019-08-08 06:00:00	AAPL	Stock	50.0375	50.16	50.0375	50.12	7140.0
2019-08-08 06:30:00	AAPL	Stock	50.0825	50.0825	49.915	49.9625	33896.0
2019-08-08 07:00:00	AAPL	Stock	49.98	50.075	49.9175	50.075	124232.0
2019-08-08 07:30:00	AAPL	Stock	50.0725	50.0875	49.975	50.035	187728.0
2019-08-08 08:00:00	AAPL	Stock	49.95	50.0975	49.915	50.05	245848.0
2019-08-08 08:30:00	AAPL	Stock	50.0425	50.1125	50.03	50.0625	178588.0
2019-08-08 09:00:00	AAPL	Stock	50.075	50.375	50.0	50.085	551672.0
2019-08-08 09:30:00	AAPL	Stock	50.0775	50.25	49.8475	50.1112	14272692.0
2019-08-08 10:00:00	AAPL	Stock	50.11	50.235	50.0778	50.21	6723996.0
2019-08-08 10:30:00	AAPL	Stock	50.21	50.534	50.21	50.485	7073828.0
2019-08-08 11:00:00	AAPL	Stock	50.4875	50.534	50.39	50.3918	5746300.0
2019-08-08 11:30:00	AAPL	Stock	50.3925	50.5925	50.3775	50.5425	5214212.0
2019-08-08 12:00:00	AAPL	Stock	50.5425	50.5925	50.51	50.54	3425932.0
2019-08-08 12:30:00	AAPL	Stock	50.5375	50.615	50.5175	50.54	3807744.0
2019-08-08 13:00:00	AAPL	Stock	50.5425	50.6025	50.42	50.4325	3139844.0
2019-08-08 13:30:00	AAPL	Stock	50.4338	50.6125	50.4338	50.5525	2465088.0
2019-08-08 14:00:00	AAPL	Stock	50.555	50.5725	50.4375	50.525	3687792.0
2019-08-08 14:30:00	AAPL	Stock	50.5275	50.6425	50.4775	50.54	4121612.0
2019-08-08 15:00:00	AAPL	Stock	50.5388	50.615	50.5175	50.595	4103584.0
2019-08-08 15:30:00	AAPL	Stock	50.5975	50.8825	50.5825	50.8625	11875752.0
2019-08-08 16:00:00	AAPL	Stock	50.8575	50.882	50.805	50.85	10769120.0
2019-08-08 16:30:00	AAPL	Stock	50.845	50.935	50.815	50.8625	156404.0
2019-08-08 17:00:00	AAPL	Stock	50.8625	50.8625	50.4825	50.61	200892.0
2019-08-08 17:30:00	AAPL	Stock	50.6075	50.705	50.5375	50.64	76024.0
2019-08-08 18:00:00	AAPL	Stock	50.6375	50.69	50.425	50.45	168976.0
2019-08-08 18:30:00	AAPL	Stock	50.5	50.65	50.425	50.5625	65720.0
2019-08-08 19:00:00	AAPL	Stock	50.5875	50.675	50.575	50.5875	54304.0
2019-08-08 19:30:00	AAPL	Stock	50.61	50.7925	50.61	50.7875	45292.0
2019-08-08 04:00:00	MSFT	Stock	135.8	135.9	135.47	135.7	2481.0
2019-08-08 05:30:00	MSFT	Stock	135.9	135.9	135.9	135.9	900.0
2019-08-08 06:00:00	MSFT	Stock	136.45	136.55	136.35	136.36	400.0
2019-08-08 06:30:00	MSFT	Stock	136.0	136.1	136.0	136.1	600.0
2019-08-08 07:00:00	MSFT	Stock	135.96	135.98	135.67	135.98	8768.0
2019-08-08 07:30:00	MSFT	Stock	135.97	136.0	135.74	135.84	16918.0
2019-08-08 08:00:00	MSFT	Stock	135.75	136.2	135.507	136.07	20342.0
2019-08-08 08:30:00	MSFT	Stock	136.12	136.25	136.0	136.25	33196.0
2019-08-08 09:00:00	MSFT	Stock	136.25	136.65	136.25	136.61	44757.0
2019-08-08 09:30:00	MSFT	Stock	136.6	136.92	135.93	136.85	2897290.0
2019-08-08 10:00:00	MSFT	Stock	136.84	137.28	136.626	137.23	1688227.0
2019-08-08 10:30:00	MSFT	Stock	137.22	137.9	137.19	137.805	1585069.0
2019-08-08 11:00:00	MSFT	Stock	137.805	137.97	137.3	137.875	1253858.0
2019-08-08 11:30:00	MSFT	Stock	137.875	138.28	137.82	138.249	1282269.0
2019-08-08 12:00:00	MSFT	Stock	138.247	138.385	137.96	138.15	985472.0
2019-08-08 12:30:00	MSFT	Stock	138.155	138.37	138.095	138.33	1019287.0
2019-08-08 13:00:00	MSFT	Stock	138.33	138.395	137.846	137.859	961024.0
2019-08-08 13:30:00	MSFT	Stock	137.85	138.3	137.841	138.16	713535.0

> showing 50 of 85,796 rows — these rows as CSV

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