PREVIEW / stock_30min / 2020-05-22

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-22.parquet
  size:    1.8 MB
  rows:    93,058
  symbols: 2,370

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-05-22 04:00:00	AAPL	Stock	78.35	78.35	78.125	78.25	20560.0
2020-05-22 04:30:00	AAPL	Stock	78.425	78.55	78.3825	78.55	9240.0
2020-05-22 05:00:00	AAPL	Stock	78.505	78.695	78.5	78.695	6020.0
2020-05-22 05:30:00	AAPL	Stock	78.64	78.67	78.4825	78.54	28976.0
2020-05-22 06:00:00	AAPL	Stock	78.535	78.6625	78.535	78.6625	11872.0
2020-05-22 06:30:00	AAPL	Stock	78.725	78.84	78.6775	78.725	19980.0
2020-05-22 07:00:00	AAPL	Stock	78.75	79.0625	78.75	78.9025	124348.0
2020-05-22 07:30:00	AAPL	Stock	78.96	79.2425	78.9125	79.15	126044.0
2020-05-22 08:00:00	AAPL	Stock	79.2025	79.2475	78.7625	79.0	204024.0
2020-05-22 08:30:00	AAPL	Stock	79.0225	79.1525	78.94	79.025	123880.0
2020-05-22 09:00:00	AAPL	Stock	79.0	79.1825	78.9125	78.9375	123536.0
2020-05-22 09:30:00	AAPL	Stock	78.9375	79.4875	78.8375	79.435	9476136.0
2020-05-22 10:00:00	AAPL	Stock	79.4375	79.465	79.125	79.375	6422812.0
2020-05-22 10:30:00	AAPL	Stock	79.38	79.4875	79.1525	79.18	5945920.0
2020-05-22 11:00:00	AAPL	Stock	79.175	79.32	79.1325	79.2375	3771228.0
2020-05-22 11:30:00	AAPL	Stock	79.2425	79.4225	79.1875	79.3575	3532784.0
2020-05-22 12:00:00	AAPL	Stock	79.36	79.3988	79.2325	79.315	2633860.0
2020-05-22 12:30:00	AAPL	Stock	79.3175	79.5	79.3025	79.365	3744560.0
2020-05-22 13:00:00	AAPL	Stock	79.365	79.6075	79.35	79.56	3896696.0
2020-05-22 13:30:00	AAPL	Stock	79.56	79.575	79.375	79.4625	3436760.0
2020-05-22 14:00:00	AAPL	Stock	79.465	79.65	79.4325	79.5588	3809584.0
2020-05-22 14:30:00	AAPL	Stock	79.56	79.6425	79.475	79.55	3673936.0
2020-05-22 15:00:00	AAPL	Stock	79.5492	79.645	79.33	79.44	4592348.0
2020-05-22 15:30:00	AAPL	Stock	79.4375	79.8075	79.3125	79.7225	8139856.0
2020-05-22 16:00:00	AAPL	Stock	79.7225	79.775	79.6825	79.7375	3946820.0
2020-05-22 16:30:00	AAPL	Stock	79.75	79.8125	79.745	79.7875	49276.0
2020-05-22 17:00:00	AAPL	Stock	79.7875	79.8	79.765	79.7775	23892.0
2020-05-22 17:30:00	AAPL	Stock	79.765	79.7875	79.7625	79.7625	15780.0
2020-05-22 18:00:00	AAPL	Stock	79.755	79.7775	79.75	79.75	28384.0
2020-05-22 18:30:00	AAPL	Stock	79.7625	79.7625	79.725	79.75	19324.0
2020-05-22 19:00:00	AAPL	Stock	79.7325	79.745	79.725	79.7275	8764.0
2020-05-22 19:30:00	AAPL	Stock	79.73	79.765	79.7225	79.765	27016.0
2020-05-22 04:00:00	MSFT	Stock	181.9	181.9	181.45	181.45	1906.0
2020-05-22 04:30:00	MSFT	Stock	182.1	182.17	182.1	182.17	523.0
2020-05-22 05:00:00	MSFT	Stock	182.19	182.19	182.07	182.07	1365.0
2020-05-22 05:30:00	MSFT	Stock	182.15	182.7	181.66	181.9	2764.0
2020-05-22 06:30:00	MSFT	Stock	182.15	182.32	182.1	182.12	2189.0
2020-05-22 07:00:00	MSFT	Stock	182.5	182.75	182.08	182.2	21896.0
2020-05-22 07:30:00	MSFT	Stock	182.2	183.0	182.03	182.85	17459.0
2020-05-22 08:00:00	MSFT	Stock	182.7	183.2	182.1	182.9	34648.0
2020-05-22 08:30:00	MSFT	Stock	182.73	183.43	182.65	183.0	19548.0
2020-05-22 09:00:00	MSFT	Stock	183.0	183.45	182.804	183.37	24869.0
2020-05-22 09:30:00	MSFT	Stock	183.24	184.46	182.75	184.33	2461211.0
2020-05-22 10:00:00	MSFT	Stock	184.35	184.4	183.005	183.9	1768586.0
2020-05-22 10:30:00	MSFT	Stock	183.92	183.97	183.0	183.04	1215218.0
2020-05-22 11:00:00	MSFT	Stock	183.02	183.12	182.54	182.85	1221889.0
2020-05-22 11:30:00	MSFT	Stock	182.84	183.14	182.76	182.848	852397.0
2020-05-22 12:00:00	MSFT	Stock	182.87	183.08	182.67	182.97	838108.0
2020-05-22 12:30:00	MSFT	Stock	182.97	183.65	182.97	183.16	1017166.0
2020-05-22 13:00:00	MSFT	Stock	183.14	183.54	183.14	183.449	924974.0

> showing 50 of 93,058 rows — these rows as CSV

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