PREVIEW / stock_30min / 2020-05-04

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-04.parquet
  size:    1.8 MB
  rows:    93,282
  symbols: 2,373

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-05-04 04:00:00	AAPL	Stock	72.0625	72.0625	71.7875	72.01	13004.0
2020-05-04 04:30:00	AAPL	Stock	72.015	72.0625	71.92	72.05	13912.0
2020-05-04 05:00:00	AAPL	Stock	71.965	71.965	71.775	71.7775	19404.0
2020-05-04 05:30:00	AAPL	Stock	71.775	71.845	71.7675	71.845	8940.0
2020-05-04 06:00:00	AAPL	Stock	71.755	72.0425	71.755	71.9825	16496.0
2020-05-04 06:30:00	AAPL	Stock	72.0	72.0	71.8525	71.8525	16900.0
2020-05-04 07:00:00	AAPL	Stock	71.8	72.0	71.7375	72.0	148544.0
2020-05-04 07:30:00	AAPL	Stock	71.9825	72.45	71.9825	72.23	184400.0
2020-05-04 08:00:00	AAPL	Stock	71.78	72.4725	71.755	72.4375	417192.0
2020-05-04 08:30:00	AAPL	Stock	72.4375	72.495	72.2475	72.2625	268164.0
2020-05-04 09:00:00	AAPL	Stock	72.2625	72.495	72.125	72.2575	477216.0
2020-05-04 09:30:00	AAPL	Stock	72.2925	72.395	71.5792	72.1762	18639288.0
2020-05-04 10:00:00	AAPL	Stock	72.185	72.8665	72.13	72.6425	12187392.0
2020-05-04 10:30:00	AAPL	Stock	72.6375	72.6525	72.34	72.5387	6814032.0
2020-05-04 11:00:00	AAPL	Stock	72.5412	72.805	72.47	72.6675	6212132.0
2020-05-04 11:30:00	AAPL	Stock	72.6825	73.025	72.625	72.8775	6404588.0
2020-05-04 12:00:00	AAPL	Stock	72.875	73.0225	72.8525	72.9175	4357460.0
2020-05-04 12:30:00	AAPL	Stock	72.9218	72.93	72.2725	72.4188	6941312.0
2020-05-04 13:00:00	AAPL	Stock	72.424	72.48	72.0325	72.275	6546156.0
2020-05-04 13:30:00	AAPL	Stock	72.28	72.6888	72.28	72.675	5383728.0
2020-05-04 14:00:00	AAPL	Stock	72.675	72.7575	72.525	72.745	4352992.0
2020-05-04 14:30:00	AAPL	Stock	72.7475	72.925	72.4925	72.8875	5980680.0
2020-05-04 15:00:00	AAPL	Stock	72.8825	73.1825	72.7875	73.12	7161472.0
2020-05-04 15:30:00	AAPL	Stock	73.1225	73.4225	73.075	73.2925	11678368.0
2020-05-04 16:00:00	AAPL	Stock	73.2925	73.43	73.15	73.2225	4913860.0
2020-05-04 16:30:00	AAPL	Stock	73.22	73.25	73.145	73.225	35236.0
2020-05-04 17:00:00	AAPL	Stock	73.225	73.2525	73.1775	73.2525	37468.0
2020-05-04 17:30:00	AAPL	Stock	73.22	73.25	73.1825	73.25	10292.0
2020-05-04 18:00:00	AAPL	Stock	73.1925	73.3625	73.1875	73.3625	67248.0
2020-05-04 18:30:00	AAPL	Stock	73.365	73.4075	73.3	73.325	52156.0
2020-05-04 19:00:00	AAPL	Stock	73.335	73.3625	73.3	73.3575	19328.0
2020-05-04 19:30:00	AAPL	Stock	73.36	73.415	73.315	73.415	27908.0
2020-05-04 04:00:00	MSFT	Stock	174.0	174.38	173.85	174.08	4900.0
2020-05-04 04:30:00	MSFT	Stock	173.8	173.94	173.75	173.77	4303.0
2020-05-04 05:00:00	MSFT	Stock	173.5	173.5	173.0	173.16	2305.0
2020-05-04 05:30:00	MSFT	Stock	173.1	173.45	173.1	173.45	445.0
2020-05-04 06:00:00	MSFT	Stock	173.47	173.87	173.47	173.87	431.0
2020-05-04 06:30:00	MSFT	Stock	173.85	173.85	173.75	173.75	883.0
2020-05-04 07:00:00	MSFT	Stock	173.5	173.8	173.04	173.2	31281.0
2020-05-04 07:30:00	MSFT	Stock	173.28	173.9	173.17	173.9	20899.0
2020-05-04 08:00:00	MSFT	Stock	173.65	174.0	173.03	174.0	41427.0
2020-05-04 08:30:00	MSFT	Stock	174.0	174.25	173.61	173.7	34605.0
2020-05-04 09:00:00	MSFT	Stock	173.72	174.49	173.12	174.49	86354.0
2020-05-04 09:30:00	MSFT	Stock	174.49	176.24	173.8	176.14	3661243.0
2020-05-04 10:00:00	MSFT	Stock	176.17	177.17	176.13	176.71	2348133.0
2020-05-04 10:30:00	MSFT	Stock	176.73	177.53	176.585	177.04	1768815.0
2020-05-04 11:00:00	MSFT	Stock	177.035	178.0	176.9	177.25	1711863.0
2020-05-04 11:30:00	MSFT	Stock	177.25	178.075	177.25	177.722	1318207.0
2020-05-04 12:00:00	MSFT	Stock	177.73	177.969	177.32	177.57	1059889.0
2020-05-04 12:30:00	MSFT	Stock	177.58	177.62	176.63	176.94	1471694.0

> showing 50 of 93,282 rows — these rows as CSV

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