PREVIEW / stock_30min / 2020-09-17

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-17.parquet
  size:    1.9 MB
  rows:    96,744
  symbols: 2,484

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-09-17 04:00:00	AAPL	Stock	110.34	111.2	110.0	110.86	99519.0
2020-09-17 04:30:00	AAPL	Stock	110.86	111.08	110.58	110.98	36312.0
2020-09-17 05:00:00	AAPL	Stock	111.08	111.25	110.76	110.99	18906.0
2020-09-17 05:30:00	AAPL	Stock	111.04	111.6	111.0	111.4	25823.0
2020-09-17 06:00:00	AAPL	Stock	111.45	111.45	111.01	111.32	22915.0
2020-09-17 06:30:00	AAPL	Stock	111.36	111.5	110.47	110.5	49729.0
2020-09-17 07:00:00	AAPL	Stock	110.67	111.0	110.13	110.34	554324.0
2020-09-17 07:30:00	AAPL	Stock	110.42	110.6	109.8	109.96	573776.0
2020-09-17 08:00:00	AAPL	Stock	109.95	111.0	109.6	110.04	1170829.0
2020-09-17 08:30:00	AAPL	Stock	110.05	110.06	109.27	109.46	830880.0
2020-09-17 09:00:00	AAPL	Stock	109.5	109.82	108.65	109.73	1719020.0
2020-09-17 09:30:00	AAPL	Stock	109.7	110.85	108.71	110.37	23916801.0
2020-09-17 10:00:00	AAPL	Stock	110.36	111.18	109.91	110.21	12587163.0
2020-09-17 10:30:00	AAPL	Stock	110.23	111.525	109.8	110.905	10757284.0
2020-09-17 11:00:00	AAPL	Stock	110.91	112.2	110.9	111.65	9944626.0
2020-09-17 11:30:00	AAPL	Stock	111.64	111.885	110.2	110.3	9173779.0
2020-09-17 12:00:00	AAPL	Stock	110.29	110.67	109.46	109.87	10717479.0
2020-09-17 12:30:00	AAPL	Stock	109.88	110.06	108.96	109.75	10486732.0
2020-09-17 13:00:00	AAPL	Stock	109.75	110.1	109.37	109.86	6735833.0
2020-09-17 13:30:00	AAPL	Stock	109.87	110.46	109.75	109.904	6583754.0
2020-09-17 14:00:00	AAPL	Stock	109.9	110.48	109.47	109.48	6827455.0
2020-09-17 14:30:00	AAPL	Stock	109.47	109.72	109.1	109.41	8152742.0
2020-09-17 15:00:00	AAPL	Stock	109.41	109.9	108.96	109.198	9825990.0
2020-09-17 15:30:00	AAPL	Stock	109.18	110.67	109.11	110.32	14686716.0
2020-09-17 16:00:00	AAPL	Stock	110.34	112.13	110.25	110.35	11163725.0
2020-09-17 16:30:00	AAPL	Stock	110.36	110.5	110.19	110.22	124698.0
2020-09-17 17:00:00	AAPL	Stock	110.22	110.3	110.02	110.05	92928.0
2020-09-17 17:30:00	AAPL	Stock	110.08	110.26	110.05	110.25	60222.0
2020-09-17 18:00:00	AAPL	Stock	110.24	110.31	110.1	110.28	66264.0
2020-09-17 18:30:00	AAPL	Stock	110.27	110.58	110.27	110.54	83186.0
2020-09-17 19:00:00	AAPL	Stock	110.54	110.68	110.53	110.56	95855.0
2020-09-17 19:30:00	AAPL	Stock	110.56	110.6	110.25	110.34	112044.0
2020-09-17 04:00:00	MSFT	Stock	202.6	203.0	202.28	202.8	8922.0
2020-09-17 04:30:00	MSFT	Stock	203.1	203.1	202.5	202.86	709.0
2020-09-17 05:00:00	MSFT	Stock	203.34	203.61	202.91	203.54	3488.0
2020-09-17 05:30:00	MSFT	Stock	203.5	204.34	203.5	204.25	6627.0
2020-09-17 06:00:00	MSFT	Stock	204.2	204.2	203.35	204.0	4041.0
2020-09-17 06:30:00	MSFT	Stock	203.97	203.97	202.04	202.04	8427.0
2020-09-17 07:00:00	MSFT	Stock	202.88	203.35	201.85	202.06	39227.0
2020-09-17 07:30:00	MSFT	Stock	202.19	202.5	201.19	201.5	53719.0
2020-09-17 08:00:00	MSFT	Stock	202.465	203.0	200.7	201.66	101737.0
2020-09-17 08:30:00	MSFT	Stock	201.42	201.5	200.59	200.8	84450.0
2020-09-17 09:00:00	MSFT	Stock	200.96	201.0	199.44	200.02	235717.0
2020-09-17 09:30:00	MSFT	Stock	200.05	203.36	200.0	203.1	4482263.0
2020-09-17 10:00:00	MSFT	Stock	203.105	204.165	201.87	202.41	2036673.0
2020-09-17 10:30:00	MSFT	Stock	202.43	204.16	201.85	203.308	1266490.0
2020-09-17 11:00:00	MSFT	Stock	203.3	204.33	202.74	203.23	1290287.0
2020-09-17 11:30:00	MSFT	Stock	203.2	203.51	201.29	201.45	1363512.0
2020-09-17 12:00:00	MSFT	Stock	201.44	201.92	200.08	200.82	1852981.0
2020-09-17 12:30:00	MSFT	Stock	200.78	201.38	199.96	201.36	1931885.0

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

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