PREVIEW / stock_30min / 2019-07-29

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-29.parquet
  size:    1.7 MB
  rows:    85,445
  symbols: 2,596

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-07-29 04:00:00	AAPL	Stock	51.9625	51.975	51.9625	51.975	2840.0
2019-07-29 04:30:00	AAPL	Stock	51.885	51.9075	51.8825	51.8825	2000.0
2019-07-29 05:00:00	AAPL	Stock	51.875	51.95	51.86	51.86	7600.0
2019-07-29 05:30:00	AAPL	Stock	51.9075	51.9075	51.875	51.875	2000.0
2019-07-29 06:00:00	AAPL	Stock	51.88	51.88	51.88	51.88	400.0
2019-07-29 06:30:00	AAPL	Stock	51.95	51.95	51.8475	51.8875	3200.0
2019-07-29 07:00:00	AAPL	Stock	51.8975	51.995	51.8975	51.995	19956.0
2019-07-29 07:30:00	AAPL	Stock	51.9925	52.095	51.9925	52.08	14588.0
2019-07-29 08:00:00	AAPL	Stock	51.925	52.0875	51.881	52.0375	123388.0
2019-07-29 08:30:00	AAPL	Stock	52.003	52.1	52.003	52.075	106036.0
2019-07-29 09:00:00	AAPL	Stock	52.0975	52.1725	52.075	52.1	274712.0
2019-07-29 09:30:00	AAPL	Stock	52.1175	52.425	52.11	52.2425	12161696.0
2019-07-29 10:00:00	AAPL	Stock	52.24	52.385	52.2017	52.35	5786832.0
2019-07-29 10:30:00	AAPL	Stock	52.3485	52.5	52.315	52.4235	5692488.0
2019-07-29 11:00:00	AAPL	Stock	52.4312	52.5775	52.4025	52.565	7037552.0
2019-07-29 11:30:00	AAPL	Stock	52.5675	52.66	52.5475	52.645	4468300.0
2019-07-29 12:00:00	AAPL	Stock	52.645	52.65	52.5375	52.635	4165560.0
2019-07-29 12:30:00	AAPL	Stock	52.635	52.65	52.4635	52.5425	3761296.0
2019-07-29 13:00:00	AAPL	Stock	52.5418	52.6	52.4875	52.5975	2553324.0
2019-07-29 13:30:00	AAPL	Stock	52.595	52.615	52.5175	52.5275	2462664.0
2019-07-29 14:00:00	AAPL	Stock	52.5275	52.615	52.5025	52.605	2972436.0
2019-07-29 14:30:00	AAPL	Stock	52.605	52.6275	52.5525	52.6135	3060416.0
2019-07-29 15:00:00	AAPL	Stock	52.6125	52.625	52.555	52.5825	2973552.0
2019-07-29 15:30:00	AAPL	Stock	52.5825	52.59	52.4175	52.4175	7782308.0
2019-07-29 16:00:00	AAPL	Stock	52.42	52.4695	52.375	52.4625	6893848.0
2019-07-29 16:30:00	AAPL	Stock	52.4375	52.4775	52.42	52.4625	134560.0
2019-07-29 17:00:00	AAPL	Stock	52.4725	52.475	52.4625	52.4625	18928.0
2019-07-29 17:30:00	AAPL	Stock	52.4625	52.4625	52.3875	52.4075	69412.0
2019-07-29 18:00:00	AAPL	Stock	52.405	52.4075	52.3775	52.3925	68344.0
2019-07-29 18:30:00	AAPL	Stock	52.395	52.4125	52.3875	52.4075	23684.0
2019-07-29 19:00:00	AAPL	Stock	52.3875	52.4	52.3875	52.39	8204.0
2019-07-29 19:30:00	AAPL	Stock	52.3925	52.42	52.3875	52.42	62264.0
2019-07-29 04:00:00	MSFT	Stock	141.85	141.85	141.34	141.47	1712.0
2019-07-29 04:30:00	MSFT	Stock	141.45	141.45	141.45	141.45	200.0
2019-07-29 05:30:00	MSFT	Stock	141.3	141.3	141.3	141.3	200.0
2019-07-29 06:00:00	MSFT	Stock	141.45	141.45	141.45	141.45	200.0
2019-07-29 06:30:00	MSFT	Stock	141.4	141.4	141.34	141.34	311.0
2019-07-29 07:00:00	MSFT	Stock	141.25	141.54	141.25	141.54	2539.0
2019-07-29 07:30:00	MSFT	Stock	141.4	141.77	141.34	141.61	14664.0
2019-07-29 08:00:00	MSFT	Stock	141.25	141.7	141.25	141.6	8135.0
2019-07-29 08:30:00	MSFT	Stock	141.64	141.76	141.5	141.6	9686.0
2019-07-29 09:00:00	MSFT	Stock	141.77	141.88	141.41	141.5	24514.0
2019-07-29 09:30:00	MSFT	Stock	141.49	141.51	139.66	139.834	2468873.0
2019-07-29 10:00:00	MSFT	Stock	139.83	140.1	139.366	140.042	1760896.0
2019-07-29 10:30:00	MSFT	Stock	140.04	140.43	139.93	140.035	896068.0
2019-07-29 11:00:00	MSFT	Stock	140.04	140.57	139.99	140.535	699943.0
2019-07-29 11:30:00	MSFT	Stock	140.533	140.85	140.465	140.695	565008.0
2019-07-29 12:00:00	MSFT	Stock	140.703	140.729	140.44	140.591	543793.0
2019-07-29 12:30:00	MSFT	Stock	140.59	140.91	140.49	140.91	496452.0
2019-07-29 13:00:00	MSFT	Stock	140.9	141.14	140.87	141.065	543758.0

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

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