PREVIEW / stock_30min / 2020-06-02

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-02.parquet
  size:    1.9 MB
  rows:    95,572
  symbols: 2,410

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-02 04:00:00	AAPL	Stock	80.6225	80.75	80.6225	80.7175	31632.0
2020-06-02 04:30:00	AAPL	Stock	80.7475	80.905	80.7475	80.905	12660.0
2020-06-02 05:00:00	AAPL	Stock	80.8525	80.9325	80.8525	80.9	6952.0
2020-06-02 05:30:00	AAPL	Stock	80.9125	80.9975	80.9	80.9975	2968.0
2020-06-02 06:00:00	AAPL	Stock	80.98	80.995	80.945	80.95	6016.0
2020-06-02 06:30:00	AAPL	Stock	80.8775	80.995	80.85	80.9475	14468.0
2020-06-02 07:00:00	AAPL	Stock	80.8625	80.96	80.5125	80.575	151380.0
2020-06-02 07:30:00	AAPL	Stock	80.625	80.685	80.2025	80.3125	241124.0
2020-06-02 08:00:00	AAPL	Stock	80.8075	80.9538	80.05	80.175	379288.0
2020-06-02 08:30:00	AAPL	Stock	80.2	80.325	80.065	80.225	224120.0
2020-06-02 09:00:00	AAPL	Stock	80.225	80.375	80.125	80.1825	261432.0
2020-06-02 09:30:00	AAPL	Stock	80.1825	80.6175	80.155	80.255	10736000.0
2020-06-02 10:00:00	AAPL	Stock	80.2625	80.575	80.2525	80.4975	5661056.0
2020-06-02 10:30:00	AAPL	Stock	80.5	80.525	80.0425	80.1218	6207120.0
2020-06-02 11:00:00	AAPL	Stock	80.12	80.1375	79.7325	79.829	6436512.0
2020-06-02 11:30:00	AAPL	Stock	79.8288	80.1175	79.7725	79.93	3968288.0
2020-06-02 12:00:00	AAPL	Stock	79.9275	80.175	79.9125	80.145	2521320.0
2020-06-02 12:30:00	AAPL	Stock	80.1375	80.2775	80.08	80.2625	2149264.0
2020-06-02 13:00:00	AAPL	Stock	80.27	80.425	80.245	80.4125	2979172.0
2020-06-02 13:30:00	AAPL	Stock	80.4125	80.55	80.375	80.436	3445336.0
2020-06-02 14:00:00	AAPL	Stock	80.4375	80.5775	80.36	80.495	2979212.0
2020-06-02 14:30:00	AAPL	Stock	80.4902	80.545	80.32	80.4975	3041144.0
2020-06-02 15:00:00	AAPL	Stock	80.4975	80.5425	80.3275	80.46	3768628.0
2020-06-02 15:30:00	AAPL	Stock	80.4588	80.86	80.3425	80.855	8906244.0
2020-06-02 16:00:00	AAPL	Stock	80.8525	80.855	80.1515	80.8	7516020.0
2020-06-02 16:30:00	AAPL	Stock	80.8	80.8325	80.775	80.7775	53120.0
2020-06-02 17:00:00	AAPL	Stock	80.775	80.8	80.765	80.7975	61420.0
2020-06-02 17:30:00	AAPL	Stock	80.795	80.8	80.7625	80.775	55384.0
2020-06-02 18:00:00	AAPL	Stock	80.775	80.7975	80.755	80.765	34044.0
2020-06-02 18:30:00	AAPL	Stock	80.775	80.8	80.705	80.7475	84488.0
2020-06-02 19:00:00	AAPL	Stock	80.7475	80.8	80.7025	80.8	101920.0
2020-06-02 19:30:00	AAPL	Stock	80.8	80.87	80.7625	80.8375	76944.0
2020-06-02 04:00:00	MSFT	Stock	183.41	184.2	183.41	184.2	8822.0
2020-06-02 04:30:00	MSFT	Stock	184.03	184.3	184.0	184.09	4419.0
2020-06-02 05:00:00	MSFT	Stock	184.08	184.25	184.0	184.02	1453.0
2020-06-02 05:30:00	MSFT	Stock	184.2	184.42	184.2	184.35	891.0
2020-06-02 06:00:00	MSFT	Stock	184.5	184.67	184.48	184.67	2124.0
2020-06-02 06:30:00	MSFT	Stock	184.65	185.4	184.57	185.1	20941.0
2020-06-02 07:00:00	MSFT	Stock	185.01	185.01	184.37	184.54	49252.0
2020-06-02 07:30:00	MSFT	Stock	184.5	184.75	184.18	184.18	34666.0
2020-06-02 08:00:00	MSFT	Stock	184.316	184.95	183.28	184.2	60240.0
2020-06-02 08:30:00	MSFT	Stock	184.16	184.55	183.85	184.26	63826.0
2020-06-02 09:00:00	MSFT	Stock	184.374	184.85	184.0	184.2	100211.0
2020-06-02 09:30:00	MSFT	Stock	184.21	184.322	182.31	182.5	3352556.0
2020-06-02 10:00:00	MSFT	Stock	182.49	183.45	182.47	183.06	2031002.0
2020-06-02 10:30:00	MSFT	Stock	183.065	183.22	181.91	182.32	1885436.0
2020-06-02 11:00:00	MSFT	Stock	182.32	182.32	181.35	181.445	1928927.0
2020-06-02 11:30:00	MSFT	Stock	181.461	182.16	181.36	181.98	1331968.0
2020-06-02 12:00:00	MSFT	Stock	181.96	182.44	181.93	182.261	757986.0
2020-06-02 12:30:00	MSFT	Stock	182.26	182.57	182.15	182.45	659510.0

> showing 50 of 95,572 rows — these rows as CSV

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