PREVIEW / stock_30min / 2020-04-28

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-28.parquet
  size:    1.9 MB
  rows:    94,593
  symbols: 2,390

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-04-28 04:00:00	AAPL	Stock	71.125	71.125	71.125	71.125	540.0
2020-04-28 04:30:00	AAPL	Stock	71.0	71.0	71.0	71.0	800.0
2020-04-28 05:00:00	AAPL	Stock	70.9725	71.3175	70.9725	71.3175	6960.0
2020-04-28 06:00:00	AAPL	Stock	71.55	71.7325	71.5025	71.5025	10356.0
2020-04-28 06:30:00	AAPL	Stock	71.5225	71.5225	71.5225	71.5225	400.0
2020-04-28 07:00:00	AAPL	Stock	71.5275	71.5525	71.29	71.55	79316.0
2020-04-28 07:30:00	AAPL	Stock	71.55	71.55	71.3775	71.4675	46192.0
2020-04-28 08:00:00	AAPL	Stock	71.42	71.55	71.21	71.2575	225356.0
2020-04-28 08:30:00	AAPL	Stock	71.25	71.33	71.205	71.3225	92892.0
2020-04-28 09:00:00	AAPL	Stock	71.2875	71.33	71.225	71.2375	185104.0
2020-04-28 09:30:00	AAPL	Stock	71.2475	71.4575	71.0575	71.175	12146756.0
2020-04-28 10:00:00	AAPL	Stock	71.17	71.3525	70.59	70.8175	10606688.0
2020-04-28 10:30:00	AAPL	Stock	70.8225	71.0375	70.16	70.2712	8961616.0
2020-04-28 11:00:00	AAPL	Stock	70.285	70.545	70.14	70.4925	5705704.0
2020-04-28 11:30:00	AAPL	Stock	70.49	70.59	70.235	70.2875	4413964.0
2020-04-28 12:00:00	AAPL	Stock	70.2875	70.3273	69.8328	70.055	5505524.0
2020-04-28 12:30:00	AAPL	Stock	70.0525	70.4125	69.959	70.3625	4975400.0
2020-04-28 13:00:00	AAPL	Stock	70.3625	70.4325	70.1675	70.1882	3330380.0
2020-04-28 13:30:00	AAPL	Stock	70.1975	70.3525	70.045	70.2612	3437844.0
2020-04-28 14:00:00	AAPL	Stock	70.255	70.5125	70.2175	70.2912	3474040.0
2020-04-28 14:30:00	AAPL	Stock	70.2875	70.3725	70.1132	70.2062	3138748.0
2020-04-28 15:00:00	AAPL	Stock	70.205	70.6	70.0	70.19	4594400.0
2020-04-28 15:30:00	AAPL	Stock	70.185	70.2025	69.55	69.6425	10033004.0
2020-04-28 16:00:00	AAPL	Stock	69.6425	70.0375	69.6275	70.0	6367340.0
2020-04-28 16:30:00	AAPL	Stock	70.0	70.3015	69.8775	69.945	332576.0
2020-04-28 17:00:00	AAPL	Stock	69.9375	70.115	69.915	70.115	54028.0
2020-04-28 17:30:00	AAPL	Stock	70.1075	70.2	70.0425	70.0425	67516.0
2020-04-28 18:00:00	AAPL	Stock	70.025	70.1725	70.0	70.125	49956.0
2020-04-28 18:30:00	AAPL	Stock	70.15	70.15	69.9475	70.0475	45564.0
2020-04-28 19:00:00	AAPL	Stock	70.0475	70.2075	69.975	70.175	26100.0
2020-04-28 19:30:00	AAPL	Stock	70.2	70.2	70.0525	70.145	61600.0
2020-04-28 04:00:00	MSFT	Stock	175.08	175.15	175.08	175.15	659.0
2020-04-28 04:30:00	MSFT	Stock	175.05	175.05	175.05	175.05	100.0
2020-04-28 05:00:00	MSFT	Stock	175.5	176.25	175.5	176.18	2878.0
2020-04-28 05:30:00	MSFT	Stock	176.14	176.7	176.14	176.7	6451.0
2020-04-28 06:00:00	MSFT	Stock	176.7	176.7	176.3	176.3	3973.0
2020-04-28 06:30:00	MSFT	Stock	176.3	176.65	176.3	176.55	3445.0
2020-04-28 07:00:00	MSFT	Stock	176.37	176.37	175.25	175.76	50203.0
2020-04-28 07:30:00	MSFT	Stock	175.8	175.9	175.45	175.83	24768.0
2020-04-28 08:00:00	MSFT	Stock	175.829	176.2	175.3	175.3	58374.0
2020-04-28 08:30:00	MSFT	Stock	175.3	175.65	175.09	175.6	47367.0
2020-04-28 09:00:00	MSFT	Stock	175.65	175.7	175.1	175.5	57779.0
2020-04-28 09:30:00	MSFT	Stock	175.5	175.67	173.86	173.99	3596372.0
2020-04-28 10:00:00	MSFT	Stock	173.97	174.18	171.75	172.365	2764871.0
2020-04-28 10:30:00	MSFT	Stock	172.39	173.05	170.59	170.96	2422745.0
2020-04-28 11:00:00	MSFT	Stock	171.0	171.69	170.319	171.467	2232269.0
2020-04-28 11:30:00	MSFT	Stock	171.47	171.8	170.93	171.105	1323400.0
2020-04-28 12:00:00	MSFT	Stock	171.11	171.19	170.17	170.77	1461671.0
2020-04-28 12:30:00	MSFT	Stock	170.78	171.3	170.59	171.25	1120672.0
2020-04-28 13:00:00	MSFT	Stock	171.245	171.69	171.221	171.355	1035035.0

> showing 50 of 94,593 rows — these rows as CSV

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