PREVIEW / stock_30min / 2020-02-28

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-28.parquet
  size:    2.0 MB
  rows:    97,269
  symbols: 2,468

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-02-28 04:00:00	AAPL	Stock	66.2	66.3425	65.425	65.57	289576.0
2020-02-28 04:30:00	AAPL	Stock	65.625	66.125	65.375	65.9725	245160.0
2020-02-28 05:00:00	AAPL	Stock	66.0	66.6125	65.75	66.5	125924.0
2020-02-28 05:30:00	AAPL	Stock	66.5975	66.5975	66.1	66.4875	342296.0
2020-02-28 06:00:00	AAPL	Stock	66.47	66.8125	66.125	66.125	391004.0
2020-02-28 06:30:00	AAPL	Stock	66.125	66.85	66.125	66.5975	133500.0
2020-02-28 07:00:00	AAPL	Stock	66.45	67.2	66.125	67.0525	709420.0
2020-02-28 07:30:00	AAPL	Stock	67.0	67.3375	66.675	66.9075	443772.0
2020-02-28 08:00:00	AAPL	Stock	67.0	67.2725	66.1775	66.3	970144.0
2020-02-28 08:30:00	AAPL	Stock	66.2525	66.5	65.25	65.25	1759084.0
2020-02-28 09:00:00	AAPL	Stock	65.25	65.625	64.2825	64.3175	2234248.0
2020-02-28 09:30:00	AAPL	Stock	64.3175	66.3125	64.0925	65.1225	59635508.0
2020-02-28 10:00:00	AAPL	Stock	65.105	66.1275	64.2725	65.2375	35961808.0
2020-02-28 10:30:00	AAPL	Stock	65.21	67.1925	65.16	67.125	26531228.0
2020-02-28 11:00:00	AAPL	Stock	67.1225	67.405	66.04	67.395	21558088.0
2020-02-28 11:30:00	AAPL	Stock	67.4	69.6025	66.875	67.5375	30710228.0
2020-02-28 12:00:00	AAPL	Stock	67.5	68.08	66.755	68.08	15196388.0
2020-02-28 12:30:00	AAPL	Stock	68.07	68.68	67.5125	68.487	15247224.0
2020-02-28 13:00:00	AAPL	Stock	68.483	68.795	67.57	67.5825	13090488.0
2020-02-28 13:30:00	AAPL	Stock	67.5825	67.59	66.31	66.73	14077356.0
2020-02-28 14:00:00	AAPL	Stock	66.72	66.895	65.915	66.75	12554484.0
2020-02-28 14:30:00	AAPL	Stock	66.735	68.12	66.575	67.2205	19306720.0
2020-02-28 15:00:00	AAPL	Stock	67.245	67.845	66.62	66.671	16122880.0
2020-02-28 15:30:00	AAPL	Stock	66.6762	68.6625	66.4175	68.66	26768456.0
2020-02-28 16:00:00	AAPL	Stock	68.6575	68.7125	66.7475	68.6275	27558000.0
2020-02-28 16:30:00	AAPL	Stock	68.675	68.995	68.34	68.83	490844.0
2020-02-28 17:00:00	AAPL	Stock	68.8125	68.8125	68.64	68.695	138432.0
2020-02-28 17:30:00	AAPL	Stock	68.7075	68.875	68.68	68.875	136180.0
2020-02-28 18:00:00	AAPL	Stock	68.875	69.0	68.8575	68.96	80532.0
2020-02-28 18:30:00	AAPL	Stock	68.955	69.0625	68.9375	68.9375	104100.0
2020-02-28 19:00:00	AAPL	Stock	68.95	68.96	68.7275	68.75	67928.0
2020-02-28 19:30:00	AAPL	Stock	68.7325	68.8125	68.6875	68.775	86172.0
2020-02-28 04:00:00	MSFT	Stock	154.8	154.8	152.0	152.1	51360.0
2020-02-28 04:30:00	MSFT	Stock	152.13	154.0	151.8	152.62	65509.0
2020-02-28 05:00:00	MSFT	Stock	152.88	154.74	152.8	154.6	36039.0
2020-02-28 05:30:00	MSFT	Stock	154.61	155.15	153.8	155.15	26563.0
2020-02-28 06:00:00	MSFT	Stock	155.1	155.78	155.1	155.68	24074.0
2020-02-28 06:30:00	MSFT	Stock	155.68	156.65	155.25	155.25	22871.0
2020-02-28 07:00:00	MSFT	Stock	155.56	156.68	154.23	156.38	133625.0
2020-02-28 07:30:00	MSFT	Stock	156.11	156.75	154.66	155.25	162900.0
2020-02-28 08:00:00	MSFT	Stock	155.59	156.72	154.0	154.3	367365.0
2020-02-28 08:30:00	MSFT	Stock	154.32	154.68	152.3	152.523	267916.0
2020-02-28 09:00:00	MSFT	Stock	152.6	153.61	152.29	152.42	386871.0
2020-02-28 09:30:00	MSFT	Stock	152.42	157.6	152.0	154.7	14621912.0
2020-02-28 10:00:00	MSFT	Stock	154.75	157.2	153.65	155.86	7423717.0
2020-02-28 10:30:00	MSFT	Stock	155.855	158.6	155.73	158.54	5263291.0
2020-02-28 11:00:00	MSFT	Stock	158.53	159.72	156.0	159.64	4716074.0
2020-02-28 11:30:00	MSFT	Stock	159.7	163.71	158.05	159.34	6649623.0
2020-02-28 12:00:00	MSFT	Stock	159.31	160.83	158.1	160.758	3155908.0
2020-02-28 12:30:00	MSFT	Stock	160.74	162.1	160.1	161.93	3124015.0

> showing 50 of 97,269 rows — these rows as CSV

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