PREVIEW / stock_30min / 2020-05-27

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-27.parquet
  size:    1.9 MB
  rows:    98,018
  symbols: 2,375

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-27 04:00:00	AAPL	Stock	79.8	79.9125	79.8	79.825	7948.0
2020-05-27 04:30:00	AAPL	Stock	79.9625	79.9625	79.8825	79.8825	1936.0
2020-05-27 05:00:00	AAPL	Stock	79.9725	80.25	79.9725	80.25	23676.0
2020-05-27 05:30:00	AAPL	Stock	80.1675	80.255	80.055	80.25	25388.0
2020-05-27 06:00:00	AAPL	Stock	80.3025	80.3025	80.1	80.1225	15956.0
2020-05-27 06:30:00	AAPL	Stock	80.12	80.12	79.955	80.025	24592.0
2020-05-27 07:00:00	AAPL	Stock	80.0125	80.0125	79.65	79.7125	122052.0
2020-05-27 07:30:00	AAPL	Stock	79.6625	79.685	79.445	79.475	80028.0
2020-05-27 08:00:00	AAPL	Stock	79.4975	79.95	79.38	79.55	182892.0
2020-05-27 08:30:00	AAPL	Stock	79.5908	79.62	79.15	79.2525	241720.0
2020-05-27 09:00:00	AAPL	Stock	79.23	79.45	78.975	78.985	382856.0
2020-05-27 09:30:00	AAPL	Stock	78.985	79.6775	78.7925	78.995	13087600.0
2020-05-27 10:00:00	AAPL	Stock	78.9988	79.515	78.75	79.435	8368368.0
2020-05-27 10:30:00	AAPL	Stock	79.43	79.465	78.2725	78.6875	9916196.0
2020-05-27 11:00:00	AAPL	Stock	78.6875	78.9875	78.44	78.8475	6321376.0
2020-05-27 11:30:00	AAPL	Stock	78.84	78.9015	78.3525	78.7075	5265768.0
2020-05-27 12:00:00	AAPL	Stock	78.715	78.875	78.3875	78.535	4464328.0
2020-05-27 12:30:00	AAPL	Stock	78.5375	78.96	78.4825	78.835	3808424.0
2020-05-27 13:00:00	AAPL	Stock	78.83	78.93	78.6275	78.84	3189384.0
2020-05-27 13:30:00	AAPL	Stock	78.8325	78.8545	78.615	78.815	2685056.0
2020-05-27 14:00:00	AAPL	Stock	78.8175	79.11	78.8175	79.0275	3937256.0
2020-05-27 14:30:00	AAPL	Stock	79.0275	79.2575	78.9055	79.25	3518572.0
2020-05-27 15:00:00	AAPL	Stock	79.255	79.335	79.09	79.265	4603084.0
2020-05-27 15:30:00	AAPL	Stock	79.26	79.6	79.105	79.52	7527468.0
2020-05-27 16:00:00	AAPL	Stock	79.5275	79.575	79.435	79.5025	7247336.0
2020-05-27 16:30:00	AAPL	Stock	79.55	79.6	79.5125	79.5125	29128.0
2020-05-27 17:00:00	AAPL	Stock	79.5125	79.55	79.5	79.5125	58292.0
2020-05-27 17:30:00	AAPL	Stock	79.5	79.5275	79.4825	79.4825	18416.0
2020-05-27 18:00:00	AAPL	Stock	79.475	79.5	79.4	79.43	28608.0
2020-05-27 18:30:00	AAPL	Stock	79.405	79.4475	79.3125	79.4475	14500.0
2020-05-27 19:00:00	AAPL	Stock	79.43	79.4625	79.375	79.375	11276.0
2020-05-27 19:30:00	AAPL	Stock	79.375	79.45	79.305	79.45	34128.0
2020-05-27 04:00:00	MSFT	Stock	183.26	183.5	183.02	183.21	8812.0
2020-05-27 04:30:00	MSFT	Stock	183.35	183.35	182.82	182.82	3233.0
2020-05-27 05:00:00	MSFT	Stock	183.04	183.34	183.0	183.3	4837.0
2020-05-27 05:30:00	MSFT	Stock	183.33	183.48	183.11	183.48	4671.0
2020-05-27 06:00:00	MSFT	Stock	183.46	183.48	183.23	183.28	3906.0
2020-05-27 06:30:00	MSFT	Stock	183.16	183.25	183.1	183.24	3578.0
2020-05-27 07:00:00	MSFT	Stock	183.15	183.24	182.3	182.5	21440.0
2020-05-27 07:30:00	MSFT	Stock	182.5	182.54	182.05	182.1	11872.0
2020-05-27 08:00:00	MSFT	Stock	182.29	183.1	181.8	182.25	45874.0
2020-05-27 08:30:00	MSFT	Stock	182.18	182.2	181.0	181.05	67263.0
2020-05-27 09:00:00	MSFT	Stock	181.12	181.4	180.05	180.12	77333.0
2020-05-27 09:30:00	MSFT	Stock	180.04	180.95	177.1	178.08	6578520.0
2020-05-27 10:00:00	MSFT	Stock	178.079	179.14	177.66	177.98	3206291.0
2020-05-27 10:30:00	MSFT	Stock	177.98	178.27	176.6	177.68	2931445.0
2020-05-27 11:00:00	MSFT	Stock	177.68	178.16	176.876	177.84	1672288.0
2020-05-27 11:30:00	MSFT	Stock	177.84	178.84	177.0	178.64	1714792.0
2020-05-27 12:00:00	MSFT	Stock	178.65	179.47	178.39	179.06	1376406.0
2020-05-27 12:30:00	MSFT	Stock	179.06	180.29	178.985	179.81	1300097.0

> showing 50 of 98,018 rows — these rows as CSV

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