PREVIEW / stock_30min / 2020-10-02

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-02.parquet
  size:    2.0 MB
  rows:    100,486
  symbols: 2,504

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-10-02 04:00:00	AAPL	Stock	114.65	114.7	113.62	114.31	95233.0
2020-10-02 04:30:00	AAPL	Stock	114.3	114.63	114.07	114.27	44000.0
2020-10-02 05:00:00	AAPL	Stock	114.2	114.57	113.5	113.54	60481.0
2020-10-02 05:30:00	AAPL	Stock	113.54	114.0	113.23	113.46	76211.0
2020-10-02 06:00:00	AAPL	Stock	113.5	113.86	113.0	113.67	76255.0
2020-10-02 06:30:00	AAPL	Stock	113.66	114.38	113.54	114.0	66516.0
2020-10-02 07:00:00	AAPL	Stock	114.0	114.2	113.15	113.19	572318.0
2020-10-02 07:30:00	AAPL	Stock	113.19	113.4	112.8	112.92	431599.0
2020-10-02 08:00:00	AAPL	Stock	112.96	117.08	112.79	113.8	1368467.0
2020-10-02 08:30:00	AAPL	Stock	113.8	113.9	113.06	113.28	685505.0
2020-10-02 09:00:00	AAPL	Stock	113.25	113.32	112.56	112.83	984382.0
2020-10-02 09:30:00	AAPL	Stock	112.84	114.62	112.22	114.161	19692570.0
2020-10-02 10:00:00	AAPL	Stock	114.17	115.28	114.06	115.18	10320596.0
2020-10-02 10:30:00	AAPL	Stock	115.188	115.37	114.7	115.12	7423186.0
2020-10-02 11:00:00	AAPL	Stock	115.115	115.18	114.37	114.44	7382468.0
2020-10-02 11:30:00	AAPL	Stock	114.43	114.5	113.13	113.3	11178518.0
2020-10-02 12:00:00	AAPL	Stock	113.31	114.56	112.56	114.21	13261979.0
2020-10-02 12:30:00	AAPL	Stock	114.2	114.5	113.83	114.092	5991713.0
2020-10-02 13:00:00	AAPL	Stock	114.08	114.17	113.5	113.9	5947279.0
2020-10-02 13:30:00	AAPL	Stock	113.9	113.975	113.28	113.59	5580672.0
2020-10-02 14:00:00	AAPL	Stock	113.58	114.278	113.562	113.75	5366099.0
2020-10-02 14:30:00	AAPL	Stock	113.742	113.905	113.18	113.73	6545697.0
2020-10-02 15:00:00	AAPL	Stock	113.73	113.95	113.15	113.46	6037995.0
2020-10-02 15:30:00	AAPL	Stock	113.46	113.93	112.97	113.02	11355629.0
2020-10-02 16:00:00	AAPL	Stock	113.02	113.42	112.96	113.21	8220004.0
2020-10-02 16:30:00	AAPL	Stock	113.21	113.3	113.15	113.19	136321.0
2020-10-02 17:00:00	AAPL	Stock	113.18	113.18	112.5	112.52	244605.0
2020-10-02 17:30:00	AAPL	Stock	112.56	112.7	112.3	112.59	297230.0
2020-10-02 18:00:00	AAPL	Stock	112.6	112.6	112.42	112.45	97901.0
2020-10-02 18:30:00	AAPL	Stock	112.45	112.55	112.43	112.5	70878.0
2020-10-02 19:00:00	AAPL	Stock	112.52	112.65	112.5	112.5	109670.0
2020-10-02 19:30:00	AAPL	Stock	112.52	112.6	112.48	112.58	100220.0
2020-10-02 04:00:00	MSFT	Stock	209.49	209.49	208.18	209.01	8115.0
2020-10-02 04:30:00	MSFT	Stock	209.03	209.03	208.52	208.98	3732.0
2020-10-02 05:00:00	MSFT	Stock	208.99	209.19	207.34	207.34	8736.0
2020-10-02 05:30:00	MSFT	Stock	207.8	207.97	207.0	207.74	5752.0
2020-10-02 06:00:00	MSFT	Stock	207.5	208.2	207.2	208.2	9374.0
2020-10-02 06:30:00	MSFT	Stock	208.0	208.0	207.7	207.9	4859.0
2020-10-02 07:00:00	MSFT	Stock	208.06	208.19	207.53	207.61	71942.0
2020-10-02 07:30:00	MSFT	Stock	207.61	207.86	206.69	206.7	50090.0
2020-10-02 08:00:00	MSFT	Stock	208.007	208.7	206.7	208.687	104633.0
2020-10-02 08:30:00	MSFT	Stock	208.47	208.5	207.99	208.08	83474.0
2020-10-02 09:00:00	MSFT	Stock	208.11	208.25	207.5	208.21	106689.0
2020-10-02 09:30:00	MSFT	Stock	208.0	209.98	207.99	209.55	3337167.0
2020-10-02 10:00:00	MSFT	Stock	209.55	210.99	209.45	210.59	1679801.0
2020-10-02 10:30:00	MSFT	Stock	210.57	210.57	208.77	209.62	1420044.0
2020-10-02 11:00:00	MSFT	Stock	209.6	209.74	208.35	208.43	1343896.0
2020-10-02 11:30:00	MSFT	Stock	208.42	208.42	206.69	206.85	2169849.0
2020-10-02 12:00:00	MSFT	Stock	206.85	207.98	205.54	207.65	2712675.0
2020-10-02 12:30:00	MSFT	Stock	207.65	208.02	207.07	207.42	1237188.0

> showing 50 of 100,486 rows — these rows as CSV

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