PREVIEW / stock_30min / 2020-08-27

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-27.parquet
  size:    1.9 MB
  rows:    95,755
  symbols: 2,449

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
2020-08-27 04:00:00	AAPL	Stock	126.5275	126.645	126.3825	126.425	15896.0
2020-08-27 04:30:00	AAPL	Stock	126.4175	126.48	126.4175	126.4225	2312.0
2020-08-27 05:00:00	AAPL	Stock	126.36	126.36	126.005	126.005	8440.0
2020-08-27 05:30:00	AAPL	Stock	126.245	126.325	126.2075	126.325	5212.0
2020-08-27 06:00:00	AAPL	Stock	126.325	126.37	126.2925	126.3625	8544.0
2020-08-27 06:30:00	AAPL	Stock	126.355	126.375	126.35	126.375	17068.0
2020-08-27 07:00:00	AAPL	Stock	126.375	127.1425	126.29	127.0525	331368.0
2020-08-27 07:30:00	AAPL	Stock	127.0525	127.4675	126.84	127.1375	291772.0
2020-08-27 08:00:00	AAPL	Stock	126.825	127.445	126.2625	126.935	377412.0
2020-08-27 08:30:00	AAPL	Stock	126.9975	127.15	126.905	126.985	253072.0
2020-08-27 09:00:00	AAPL	Stock	126.9725	127.375	126.25	127.125	1015024.0
2020-08-27 09:30:00	AAPL	Stock	127.125	127.485	126.555	126.7568	15908700.0
2020-08-27 10:00:00	AAPL	Stock	126.7662	126.8375	125.715	126.39	11418584.0
2020-08-27 10:30:00	AAPL	Stock	126.385	126.4625	125.775	126.1962	6895048.0
2020-08-27 11:00:00	AAPL	Stock	126.19	126.44	125.895	126.0025	5370836.0
2020-08-27 11:30:00	AAPL	Stock	126.0125	126.385	125.9225	126.1828	4546884.0
2020-08-27 12:00:00	AAPL	Stock	126.1925	126.21	125.525	125.5835	6351096.0
2020-08-27 12:30:00	AAPL	Stock	125.57	125.725	123.8325	124.405	14125108.0
2020-08-27 13:00:00	AAPL	Stock	124.3725	125.2175	124.04	125.1575	9722260.0
2020-08-27 13:30:00	AAPL	Stock	125.1562	125.4325	124.575	125.3788	6093972.0
2020-08-27 14:00:00	AAPL	Stock	125.3875	125.65	125.2725	125.5798	6005272.0
2020-08-27 14:30:00	AAPL	Stock	125.585	125.865	125.3225	125.665	5279692.0
2020-08-27 15:00:00	AAPL	Stock	125.6588	125.8	125.3525	125.565	4781688.0
2020-08-27 15:30:00	AAPL	Stock	125.5825	125.6675	124.9925	125.01	11532868.0
2020-08-27 16:00:00	AAPL	Stock	125.01	125.25	125.01	125.15	5623468.0
2020-08-27 16:30:00	AAPL	Stock	125.18	125.18	125.025	125.1	217108.0
2020-08-27 17:00:00	AAPL	Stock	125.1	125.1075	125.0025	125.0175	142348.0
2020-08-27 17:30:00	AAPL	Stock	125.03	125.05	124.8	124.9125	108784.0
2020-08-27 18:00:00	AAPL	Stock	124.9125	125.0375	124.77	124.8375	99616.0
2020-08-27 18:30:00	AAPL	Stock	124.925	125.0	124.85	125.0	41344.0
2020-08-27 19:00:00	AAPL	Stock	125.0	125.0375	124.9125	124.9725	49808.0
2020-08-27 19:30:00	AAPL	Stock	124.975	125.225	124.95	125.225	198968.0
2020-08-27 04:00:00	MSFT	Stock	221.21	221.5	221.01	221.2	5526.0
2020-08-27 04:30:00	MSFT	Stock	221.02	221.02	221.0	221.0	439.0
2020-08-27 05:00:00	MSFT	Stock	220.92	221.13	220.5	220.78	3237.0
2020-08-27 05:30:00	MSFT	Stock	220.72	221.17	220.69	221.0	4039.0
2020-08-27 06:00:00	MSFT	Stock	221.16	221.16	221.0	221.0	1985.0
2020-08-27 06:30:00	MSFT	Stock	221.1	221.77	221.1	221.33	2809.0
2020-08-27 07:00:00	MSFT	Stock	221.08	221.52	220.81	220.81	5023.0
2020-08-27 07:30:00	MSFT	Stock	220.98	221.0	219.99	220.45	16832.0
2020-08-27 08:00:00	MSFT	Stock	221.018	221.7	220.0	220.657	15857.0
2020-08-27 08:30:00	MSFT	Stock	220.65	221.05	220.42	220.75	16709.0
2020-08-27 09:00:00	MSFT	Stock	220.71	223.07	220.15	223.05	103421.0
2020-08-27 09:30:00	MSFT	Stock	223.05	230.44	219.4	228.5	9054736.0
2020-08-27 10:00:00	MSFT	Stock	228.45	228.66	225.0	228.246	6619459.0
2020-08-27 10:30:00	MSFT	Stock	228.23	231.15	228.0	229.405	6301026.0
2020-08-27 11:00:00	MSFT	Stock	229.4	230.07	228.08	229.35	2976463.0
2020-08-27 11:30:00	MSFT	Stock	229.37	229.8	228.38	229.42	2280861.0
2020-08-27 12:00:00	MSFT	Stock	229.443	229.443	226.9	227.765	2271190.0
2020-08-27 12:30:00	MSFT	Stock	227.764	228.073	224.23	225.22	2802118.0

> showing 50 of 95,755 rows — these rows as CSV

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