PREVIEW / stock_30min / 2020-11-18

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-18.parquet
  size:    2.0 MB
  rows:    102,268
  symbols: 2,559

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-11-18 04:00:00	AAPL	Stock	119.4	119.56	119.4	119.52	8685.0
2020-11-18 04:30:00	AAPL	Stock	119.41	119.49	119.4	119.46	2147.0
2020-11-18 05:00:00	AAPL	Stock	119.42	119.65	119.42	119.53	12452.0
2020-11-18 05:30:00	AAPL	Stock	119.62	119.86	119.58	119.86	20088.0
2020-11-18 06:00:00	AAPL	Stock	119.75	119.88	118.75	119.0	81662.0
2020-11-18 06:30:00	AAPL	Stock	119.24	119.25	118.63	118.96	45087.0
2020-11-18 07:00:00	AAPL	Stock	118.98	119.5	118.97	119.43	147582.0
2020-11-18 07:30:00	AAPL	Stock	119.43	119.43	119.11	119.27	105009.0
2020-11-18 08:00:00	AAPL	Stock	119.2	119.53	118.94	119.01	331224.0
2020-11-18 08:30:00	AAPL	Stock	119.01	119.13	118.9	118.93	158007.0
2020-11-18 09:00:00	AAPL	Stock	118.95	119.438	118.55	118.61	433822.0
2020-11-18 09:30:00	AAPL	Stock	118.61	119.385	118.24	118.79	11738258.0
2020-11-18 10:00:00	AAPL	Stock	118.77	119.15	118.4	119.034	5649647.0
2020-11-18 10:30:00	AAPL	Stock	119.016	119.5	118.74	119.485	4084220.0
2020-11-18 11:00:00	AAPL	Stock	119.49	119.5	119.07	119.27	3372434.0
2020-11-18 11:30:00	AAPL	Stock	119.268	119.59	119.22	119.515	3062340.0
2020-11-18 12:00:00	AAPL	Stock	119.511	119.82	119.48	119.574	3359400.0
2020-11-18 12:30:00	AAPL	Stock	119.575	119.77	119.44	119.55	2298019.0
2020-11-18 13:00:00	AAPL	Stock	119.54	119.7	119.26	119.26	2648925.0
2020-11-18 13:30:00	AAPL	Stock	119.26	119.515	119.12	119.315	2795768.0
2020-11-18 14:00:00	AAPL	Stock	119.315	119.33	118.8	119.029	3302579.0
2020-11-18 14:30:00	AAPL	Stock	119.02	119.335	118.91	119.335	2902504.0
2020-11-18 15:00:00	AAPL	Stock	119.33	119.62	119.17	119.37	3614531.0
2020-11-18 15:30:00	AAPL	Stock	119.38	119.44	118.0	118.0	8511963.0
2020-11-18 16:00:00	AAPL	Stock	118.03	119.137	117.9	117.95	7231806.0
2020-11-18 16:30:00	AAPL	Stock	117.94	118.09	117.72	117.98	155946.0
2020-11-18 17:00:00	AAPL	Stock	117.98	118.03	117.93	117.97	47410.0
2020-11-18 17:30:00	AAPL	Stock	117.96	118.0	117.84	117.96	53280.0
2020-11-18 18:00:00	AAPL	Stock	117.95	118.05	117.95	118.05	33421.0
2020-11-18 18:30:00	AAPL	Stock	118.05	118.07	117.95	118.0	23911.0
2020-11-18 19:00:00	AAPL	Stock	118.0	118.0	117.82	117.85	43718.0
2020-11-18 19:30:00	AAPL	Stock	117.86	117.98	117.85	117.87	45277.0
2020-11-18 04:00:00	MSFT	Stock	214.57	214.57	214.57	214.57	258.0
2020-11-18 04:30:00	MSFT	Stock	214.64	214.64	214.32	214.5	1287.0
2020-11-18 05:00:00	MSFT	Stock	214.83	214.83	214.83	214.83	200.0
2020-11-18 05:30:00	MSFT	Stock	214.96	214.97	214.56	214.62	782.0
2020-11-18 06:00:00	MSFT	Stock	214.06	214.74	214.05	214.74	1080.0
2020-11-18 06:30:00	MSFT	Stock	214.52	214.65	214.3	214.3	4145.0
2020-11-18 07:00:00	MSFT	Stock	214.58	214.6	214.25	214.58	8911.0
2020-11-18 07:30:00	MSFT	Stock	214.6	214.68	214.41	214.46	11617.0
2020-11-18 08:00:00	MSFT	Stock	214.3	214.7	214.253	214.489	25857.0
2020-11-18 08:30:00	MSFT	Stock	214.45	214.56	214.2	214.35	20708.0
2020-11-18 09:00:00	MSFT	Stock	214.3	214.4	213.48	213.48	70146.0
2020-11-18 09:30:00	MSFT	Stock	213.56	215.17	213.05	213.289	2987799.0
2020-11-18 10:00:00	MSFT	Stock	213.24	213.43	211.88	212.3	2490306.0
2020-11-18 10:30:00	MSFT	Stock	212.32	212.8	211.89	212.68	1997569.0
2020-11-18 11:00:00	MSFT	Stock	212.67	213.03	212.43	212.77	855253.0
2020-11-18 11:30:00	MSFT	Stock	212.79	213.061	212.35	213.061	779852.0
2020-11-18 12:00:00	MSFT	Stock	213.05	213.58	213.02	213.41	749414.0
2020-11-18 12:30:00	MSFT	Stock	213.41	213.45	212.76	212.972	563942.0

> showing 50 of 102,268 rows — these rows as CSV

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