PREVIEW / stock_30min / 2020-01-02

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-02.parquet
  size:    1.8 MB
  rows:    88,081
  symbols: 2,467

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-01-02 04:00:00	AAPL	Stock	73.7625	73.9375	73.7625	73.935	55120.0
2020-01-02 04:30:00	AAPL	Stock	73.925	73.935	73.875	73.9325	31644.0
2020-01-02 05:00:00	AAPL	Stock	73.9375	74.0	73.9375	73.98	17376.0
2020-01-02 05:30:00	AAPL	Stock	73.9975	74.0125	73.95	74.0	34932.0
2020-01-02 06:00:00	AAPL	Stock	73.9375	73.9625	73.875	73.875	23088.0
2020-01-02 06:30:00	AAPL	Stock	73.8775	73.8975	73.825	73.8775	23880.0
2020-01-02 07:00:00	AAPL	Stock	73.875	74.02	73.7825	73.9875	299384.0
2020-01-02 07:30:00	AAPL	Stock	73.975	74.045	73.9525	74.025	141620.0
2020-01-02 08:00:00	AAPL	Stock	73.9725	74.0925	73.8588	74.0525	434304.0
2020-01-02 08:30:00	AAPL	Stock	74.0485	74.1875	74.0275	74.17	280320.0
2020-01-02 09:00:00	AAPL	Stock	74.1725	74.1725	74.0	74.075	478356.0
2020-01-02 09:30:00	AAPL	Stock	74.06	74.5375	73.7975	74.4925	20349168.0
2020-01-02 10:00:00	AAPL	Stock	74.4975	74.6025	74.1488	74.385	12394352.0
2020-01-02 10:30:00	AAPL	Stock	74.385	74.59	74.2775	74.5275	8352696.0
2020-01-02 11:00:00	AAPL	Stock	74.5325	74.6875	74.445	74.5275	8204768.0
2020-01-02 11:30:00	AAPL	Stock	74.525	74.625	74.3625	74.6025	6383996.0
2020-01-02 12:00:00	AAPL	Stock	74.6025	74.7	74.5125	74.5713	5201636.0
2020-01-02 12:30:00	AAPL	Stock	74.5725	74.6885	74.5725	74.6752	3410892.0
2020-01-02 13:00:00	AAPL	Stock	74.6768	74.6825	74.5925	74.6235	3081728.0
2020-01-02 13:30:00	AAPL	Stock	74.625	74.6375	74.525	74.61	3989004.0
2020-01-02 14:00:00	AAPL	Stock	74.61	74.69	74.515	74.6725	4345956.0
2020-01-02 14:30:00	AAPL	Stock	74.67	74.7892	74.603	74.77	6064616.0
2020-01-02 15:00:00	AAPL	Stock	74.77	74.9225	74.76	74.8153	6915672.0
2020-01-02 15:30:00	AAPL	Stock	74.8175	75.15	74.77	75.145	15876352.0
2020-01-02 16:00:00	AAPL	Stock	75.0875	75.1825	75.08	75.1475	10189216.0
2020-01-02 16:30:00	AAPL	Stock	75.15	75.2325	75.0875	75.225	270764.0
2020-01-02 17:00:00	AAPL	Stock	75.235	75.235	75.175	75.19	78880.0
2020-01-02 17:30:00	AAPL	Stock	75.1975	75.2075	75.19	75.19	68660.0
2020-01-02 18:00:00	AAPL	Stock	75.2125	75.225	75.19	75.2125	23948.0
2020-01-02 18:30:00	AAPL	Stock	75.2	75.2125	75.19	75.1925	24820.0
2020-01-02 19:00:00	AAPL	Stock	75.2	75.25	75.195	75.2	49900.0
2020-01-02 19:30:00	AAPL	Stock	75.225	75.2975	75.2175	75.2975	78320.0
2020-01-02 04:00:00	MSFT	Stock	158.7	158.98	158.7	158.98	4583.0
2020-01-02 04:30:00	MSFT	Stock	158.96	158.99	158.9	158.98	2200.0
2020-01-02 05:00:00	MSFT	Stock	159.09	159.1	158.99	159.1	2431.0
2020-01-02 05:30:00	MSFT	Stock	159.16	159.19	158.89	158.97	4091.0
2020-01-02 06:00:00	MSFT	Stock	158.98	158.98	158.82	158.82	7478.0
2020-01-02 06:30:00	MSFT	Stock	158.9	158.95	158.86	158.86	1529.0
2020-01-02 07:00:00	MSFT	Stock	158.86	158.97	158.77	158.79	14459.0
2020-01-02 07:30:00	MSFT	Stock	158.85	158.98	158.81	158.9	12610.0
2020-01-02 08:00:00	MSFT	Stock	158.89	159.04	157.7	159.0	38295.0
2020-01-02 08:30:00	MSFT	Stock	159.04	159.19	158.92	159.1	29948.0
2020-01-02 09:00:00	MSFT	Stock	159.1	159.15	158.64	158.7	48144.0
2020-01-02 09:30:00	MSFT	Stock	158.65	159.55	158.33	159.525	3186055.0
2020-01-02 10:00:00	MSFT	Stock	159.53	159.555	158.78	159.1	1492474.0
2020-01-02 10:30:00	MSFT	Stock	159.095	159.49	158.99	159.464	1002863.0
2020-01-02 11:00:00	MSFT	Stock	159.47	159.63	159.34	159.485	980374.0
2020-01-02 11:30:00	MSFT	Stock	159.48	159.48	159.11	159.375	796393.0
2020-01-02 12:00:00	MSFT	Stock	159.375	159.62	159.305	159.53	664932.0
2020-01-02 12:30:00	MSFT	Stock	159.52	159.8	159.52	159.69	673498.0

> showing 50 of 88,081 rows — these rows as CSV

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