PREVIEW / stock_30min / 2020-03-20

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-20.parquet
  size:    1.9 MB
  rows:    96,764
  symbols: 2,455

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-03-20 04:00:00	AAPL	Stock	63.525	64.6	63.25	64.25	102636.0
2020-03-20 04:30:00	AAPL	Stock	64.245	64.4175	63.605	64.35	115504.0
2020-03-20 05:00:00	AAPL	Stock	64.35	64.5	64.2475	64.29	76012.0
2020-03-20 05:30:00	AAPL	Stock	64.2525	64.625	64.25	64.575	25332.0
2020-03-20 06:00:00	AAPL	Stock	64.5375	64.6425	64.35	64.375	48980.0
2020-03-20 06:30:00	AAPL	Stock	64.375	64.4375	63.8875	63.9525	99176.0
2020-03-20 07:00:00	AAPL	Stock	63.9475	64.0	62.5	62.9375	678956.0
2020-03-20 07:30:00	AAPL	Stock	62.9525	63.25	62.6575	62.995	271732.0
2020-03-20 08:00:00	AAPL	Stock	63.6725	63.6725	62.4275	62.5	674712.0
2020-03-20 08:30:00	AAPL	Stock	62.4975	62.7475	61.195	62.0525	796068.0
2020-03-20 09:00:00	AAPL	Stock	62.0125	62.375	61.6875	61.8225	605160.0
2020-03-20 09:30:00	AAPL	Stock	61.795	62.6825	61.54	62.095	43008064.0
2020-03-20 10:00:00	AAPL	Stock	62.09	62.8675	62.0225	62.62	18020016.0
2020-03-20 10:30:00	AAPL	Stock	62.605	62.9575	62.32	62.905	13940448.0
2020-03-20 11:00:00	AAPL	Stock	62.9075	62.9425	62.0075	62.285	14930992.0
2020-03-20 11:30:00	AAPL	Stock	62.285	62.52	62.0625	62.14	12872056.0
2020-03-20 12:00:00	AAPL	Stock	62.125	62.258	61.085	61.3848	14186188.0
2020-03-20 12:30:00	AAPL	Stock	61.3862	62.255	61.2325	61.92	11960476.0
2020-03-20 13:00:00	AAPL	Stock	61.9205	62.42	61.77	61.975	11041788.0
2020-03-20 13:30:00	AAPL	Stock	61.97	62.2	61.5775	61.7775	9203644.0
2020-03-20 14:00:00	AAPL	Stock	61.7775	62.025	61.1875	61.3175	12483036.0
2020-03-20 14:30:00	AAPL	Stock	61.3125	61.495	60.235	60.39	16243408.0
2020-03-20 15:00:00	AAPL	Stock	60.39	60.7625	60.0	60.4375	17742132.0
2020-03-20 15:30:00	AAPL	Stock	60.45	60.655	57.0	57.185	65156368.0
2020-03-20 16:00:00	AAPL	Stock	57.1825	57.485	57.1125	57.3175	65801808.0
2020-03-20 16:30:00	AAPL	Stock	57.3475	57.43	57.0475	57.3225	922956.0
2020-03-20 17:00:00	AAPL	Stock	57.3625	57.425	57.125	57.1925	321100.0
2020-03-20 17:30:00	AAPL	Stock	57.2075	57.32	57.175	57.25	91128.0
2020-03-20 18:00:00	AAPL	Stock	57.225	57.29	57.1525	57.1925	91708.0
2020-03-20 18:30:00	AAPL	Stock	57.2	57.2225	57.125	57.15	102240.0
2020-03-20 19:00:00	AAPL	Stock	57.15	57.2875	57.1275	57.23	161880.0
2020-03-20 19:30:00	AAPL	Stock	57.2475	57.26	57.0	57.0	171184.0
2020-03-20 04:00:00	MSFT	Stock	148.19	152.63	147.05	151.4	29372.0
2020-03-20 04:30:00	MSFT	Stock	151.17	151.8	149.8	151.8	19510.0
2020-03-20 05:00:00	MSFT	Stock	151.8	151.89	151.1	151.35	11955.0
2020-03-20 05:30:00	MSFT	Stock	151.35	152.3	151.19	152.3	12619.0
2020-03-20 06:00:00	MSFT	Stock	152.01	153.0	152.0	152.5	8491.0
2020-03-20 06:30:00	MSFT	Stock	152.16	152.44	150.9	151.18	10805.0
2020-03-20 07:00:00	MSFT	Stock	151.0	151.23	148.01	148.97	122152.0
2020-03-20 07:30:00	MSFT	Stock	148.84	149.75	148.54	149.45	48946.0
2020-03-20 08:00:00	MSFT	Stock	150.89	150.89	148.2	148.2	132990.0
2020-03-20 08:30:00	MSFT	Stock	148.12	148.69	142.71	146.9	255193.0
2020-03-20 09:00:00	MSFT	Stock	146.62	147.99	145.05	145.99	238674.0
2020-03-20 09:30:00	MSFT	Stock	146.0	146.5	143.13	144.79	13970670.0
2020-03-20 10:00:00	MSFT	Stock	144.82	146.53	144.06	146.15	4407883.0
2020-03-20 10:30:00	MSFT	Stock	146.12	147.1	145.253	146.875	3684117.0
2020-03-20 11:00:00	MSFT	Stock	146.85	146.98	143.42	144.61	4255887.0
2020-03-20 11:30:00	MSFT	Stock	144.59	145.18	143.69	144.18	3318729.0
2020-03-20 12:00:00	MSFT	Stock	144.165	144.925	141.0	141.9	3693244.0
2020-03-20 12:30:00	MSFT	Stock	141.93	144.3	141.42	142.755	3497154.0

> showing 50 of 96,764 rows — these rows as CSV

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