PREVIEW / stock_30min / 2020-01-09

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-09.parquet
  size:    1.8 MB
  rows:    87,524
  symbols: 2,491

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-01-09 04:00:00	AAPL	Stock	76.2975	76.49	76.255	76.3875	77068.0
2020-01-09 04:30:00	AAPL	Stock	76.4125	76.4625	76.4125	76.4625	10108.0
2020-01-09 05:00:00	AAPL	Stock	76.4575	76.5	76.4075	76.4075	42284.0
2020-01-09 05:30:00	AAPL	Stock	76.4	76.4275	76.35	76.4225	34828.0
2020-01-09 06:00:00	AAPL	Stock	76.4225	76.4225	76.3475	76.4	8588.0
2020-01-09 06:30:00	AAPL	Stock	76.4025	76.4625	76.35	76.35	23944.0
2020-01-09 07:00:00	AAPL	Stock	76.35	76.6725	76.31	76.57	481312.0
2020-01-09 07:30:00	AAPL	Stock	76.595	76.6425	76.4525	76.575	277684.0
2020-01-09 08:00:00	AAPL	Stock	76.5	76.7	76.385	76.675	468404.0
2020-01-09 08:30:00	AAPL	Stock	76.6675	76.775	76.6675	76.69	435520.0
2020-01-09 09:00:00	AAPL	Stock	76.7025	76.875	76.6625	76.8125	575196.0
2020-01-09 09:30:00	AAPL	Stock	76.8125	77.2248	76.7175	77.075	27446728.0
2020-01-09 10:00:00	AAPL	Stock	77.0725	77.1575	76.855	77.085	10911764.0
2020-01-09 10:30:00	AAPL	Stock	77.085	77.365	77.0125	77.2768	9628516.0
2020-01-09 11:00:00	AAPL	Stock	77.2762	77.5025	77.245	77.4425	10566652.0
2020-01-09 11:30:00	AAPL	Stock	77.4425	77.6075	77.4025	77.4812	9691496.0
2020-01-09 12:00:00	AAPL	Stock	77.485	77.5075	76.885	76.9825	11174640.0
2020-01-09 12:30:00	AAPL	Stock	76.988	76.988	76.55	76.91	12770668.0
2020-01-09 13:00:00	AAPL	Stock	76.9125	77.3475	76.8575	77.345	10715440.0
2020-01-09 13:30:00	AAPL	Stock	77.345	77.4625	77.26	77.2702	6080460.0
2020-01-09 14:00:00	AAPL	Stock	77.2688	77.3725	77.1825	77.2325	4859356.0
2020-01-09 14:30:00	AAPL	Stock	77.2375	77.3725	77.1925	77.2562	4523400.0
2020-01-09 15:00:00	AAPL	Stock	77.2525	77.265	77.0625	77.2575	6278852.0
2020-01-09 15:30:00	AAPL	Stock	77.26	77.43	77.1425	77.4275	11559312.0
2020-01-09 16:00:00	AAPL	Stock	77.425	77.45	77.355	77.4375	9112924.0
2020-01-09 16:30:00	AAPL	Stock	77.44	77.4475	77.4075	77.4375	93292.0
2020-01-09 17:00:00	AAPL	Stock	77.425	77.4475	77.4075	77.4175	97864.0
2020-01-09 17:30:00	AAPL	Stock	77.4075	77.4475	77.4075	77.445	40320.0
2020-01-09 18:00:00	AAPL	Stock	77.4475	77.6	77.4475	77.57	140664.0
2020-01-09 18:30:00	AAPL	Stock	77.575	77.595	77.5425	77.5875	46764.0
2020-01-09 19:00:00	AAPL	Stock	77.5925	77.5925	77.555	77.575	34940.0
2020-01-09 19:30:00	AAPL	Stock	77.585	77.6	77.5625	77.6	168744.0
2020-01-09 04:00:00	MSFT	Stock	160.89	161.39	160.89	161.39	4369.0
2020-01-09 04:30:00	MSFT	Stock	161.3	161.3	161.25	161.3	1200.0
2020-01-09 05:00:00	MSFT	Stock	161.4	161.54	161.17	161.22	6708.0
2020-01-09 05:30:00	MSFT	Stock	161.22	161.48	160.82	161.03	6163.0
2020-01-09 06:00:00	MSFT	Stock	161.25	161.25	161.15	161.2	1799.0
2020-01-09 06:30:00	MSFT	Stock	161.38	161.38	161.08	161.11	5374.0
2020-01-09 07:00:00	MSFT	Stock	161.2	161.87	161.2	161.6	40809.0
2020-01-09 07:30:00	MSFT	Stock	161.6	161.66	161.33	161.5	18879.0
2020-01-09 08:00:00	MSFT	Stock	161.44	161.75	160.49	161.47	36292.0
2020-01-09 08:30:00	MSFT	Stock	161.55	161.88	161.55	161.8	40219.0
2020-01-09 09:00:00	MSFT	Stock	161.73	161.9	161.6	161.85	29234.0
2020-01-09 09:30:00	MSFT	Stock	161.81	162.215	161.34	161.63	2915436.0
2020-01-09 10:00:00	MSFT	Stock	161.635	161.69	161.38	161.38	1098840.0
2020-01-09 10:30:00	MSFT	Stock	161.386	161.77	161.37	161.7	992772.0
2020-01-09 11:00:00	MSFT	Stock	161.7	161.896	161.62	161.845	908269.0
2020-01-09 11:30:00	MSFT	Stock	161.84	162.17	161.821	162.126	875021.0
2020-01-09 12:00:00	MSFT	Stock	162.12	162.2	161.6	161.66	903966.0
2020-01-09 12:30:00	MSFT	Stock	161.65	161.75	161.03	161.68	1149348.0

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

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