PREVIEW / stock_30min / 2020-06-03

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-03.parquet
  size:    1.9 MB
  rows:    98,154
  symbols: 2,394

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-06-03 04:00:00	AAPL	Stock	81.125	81.3725	81.075	81.3725	28380.0
2020-06-03 04:30:00	AAPL	Stock	81.3725	81.4125	81.275	81.275	10836.0
2020-06-03 05:00:00	AAPL	Stock	81.345	81.3725	81.275	81.3725	7504.0
2020-06-03 05:30:00	AAPL	Stock	81.3575	81.3725	81.3575	81.3725	3956.0
2020-06-03 06:00:00	AAPL	Stock	81.26	81.3125	81.225	81.25	28684.0
2020-06-03 06:30:00	AAPL	Stock	81.25	81.315	81.2025	81.22	31476.0
2020-06-03 07:00:00	AAPL	Stock	81.195	81.245	81.1	81.18	122164.0
2020-06-03 07:30:00	AAPL	Stock	81.165	81.3125	81.075	81.25	126496.0
2020-06-03 08:00:00	AAPL	Stock	81.1718	81.3125	81.075	81.225	206236.0
2020-06-03 08:30:00	AAPL	Stock	81.19	81.2175	80.875	81.045	264360.0
2020-06-03 09:00:00	AAPL	Stock	81.0075	81.2525	81.0	81.22	189108.0
2020-06-03 09:30:00	AAPL	Stock	81.165	81.25	80.615	81.1082	13890028.0
2020-06-03 10:00:00	AAPL	Stock	81.1125	81.2075	80.765	80.955	6538364.0
2020-06-03 10:30:00	AAPL	Stock	80.9525	81.0625	80.81	80.9802	4688936.0
2020-06-03 11:00:00	AAPL	Stock	80.9775	81.1475	80.895	80.9825	4183728.0
2020-06-03 11:30:00	AAPL	Stock	80.9875	80.9875	80.835	80.9225	3122260.0
2020-06-03 12:00:00	AAPL	Stock	80.9125	80.9262	80.575	80.7562	4622576.0
2020-06-03 12:30:00	AAPL	Stock	80.7575	80.985	80.75	80.8275	2685096.0
2020-06-03 13:00:00	AAPL	Stock	80.8275	81.1025	80.7875	81.085	2730560.0
2020-06-03 13:30:00	AAPL	Stock	81.0875	81.1	80.84	80.995	3497088.0
2020-06-03 14:00:00	AAPL	Stock	80.9925	81.1625	80.965	81.0375	3795268.0
2020-06-03 14:30:00	AAPL	Stock	81.0375	81.25	81.0275	81.1325	5992996.0
2020-06-03 15:00:00	AAPL	Stock	81.1332	81.4225	81.0625	81.422	7976744.0
2020-06-03 15:30:00	AAPL	Stock	81.4225	81.55	81.225	81.2725	11624932.0
2020-06-03 16:00:00	AAPL	Stock	81.28	81.28	81.0288	81.2625	10051760.0
2020-06-03 16:30:00	AAPL	Stock	81.2625	81.2625	81.1675	81.1675	19416.0
2020-06-03 17:00:00	AAPL	Stock	81.195	81.195	81.1675	81.1675	6880.0
2020-06-03 17:30:00	AAPL	Stock	81.175	81.2225	81.175	81.2225	5060.0
2020-06-03 18:00:00	AAPL	Stock	81.21	81.21	81.105	81.1375	24256.0
2020-06-03 18:30:00	AAPL	Stock	81.2	81.21	81.1975	81.1975	7280.0
2020-06-03 19:00:00	AAPL	Stock	81.21	81.25	81.1875	81.25	8296.0
2020-06-03 19:30:00	AAPL	Stock	81.2575	81.3	81.2375	81.3	27972.0
2020-06-03 04:00:00	MSFT	Stock	185.16	185.17	184.94	185.17	300.0
2020-06-03 04:30:00	MSFT	Stock	185.17	185.3	185.0	185.25	2263.0
2020-06-03 05:00:00	MSFT	Stock	185.31	185.31	185.25	185.25	355.0
2020-06-03 05:30:00	MSFT	Stock	185.2	185.7	185.2	185.59	1756.0
2020-06-03 06:00:00	MSFT	Stock	185.16	185.55	185.13	185.46	1184.0
2020-06-03 06:30:00	MSFT	Stock	185.24	185.52	185.16	185.2	4512.0
2020-06-03 07:00:00	MSFT	Stock	185.5	185.5	185.16	185.22	12720.0
2020-06-03 07:30:00	MSFT	Stock	185.25	185.26	185.0	185.21	18735.0
2020-06-03 08:00:00	MSFT	Stock	185.145	185.47	184.96	185.3	32888.0
2020-06-03 08:30:00	MSFT	Stock	185.3	185.35	184.13	184.5	54625.0
2020-06-03 09:00:00	MSFT	Stock	184.501	185.0	184.5	184.85	35130.0
2020-06-03 09:30:00	MSFT	Stock	184.83	185.15	183.61	184.56	3233314.0
2020-06-03 10:00:00	MSFT	Stock	184.57	184.73	183.625	184.05	1912814.0
2020-06-03 10:30:00	MSFT	Stock	184.06	184.42	183.86	184.14	1323167.0
2020-06-03 11:00:00	MSFT	Stock	184.143	184.51	183.93	184.21	1334210.0
2020-06-03 11:30:00	MSFT	Stock	184.2	184.49	184.04	184.365	1117714.0
2020-06-03 12:00:00	MSFT	Stock	184.36	184.37	183.58	184.088	1508119.0
2020-06-03 12:30:00	MSFT	Stock	184.087	184.45	184.07	184.13	727567.0

> showing 50 of 98,154 rows — these rows as CSV

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