PREVIEW / stock_30min / 2020-11-04

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-04.parquet
  size:    1.9 MB
  rows:    97,855
  symbols: 2,524

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-04 04:00:00	AAPL	Stock	113.3	114.2	113.0	114.13	143881.0
2020-11-04 04:30:00	AAPL	Stock	114.1	114.58	113.7	113.89	107802.0
2020-11-04 05:00:00	AAPL	Stock	113.77	113.77	112.79	112.84	86925.0
2020-11-04 05:30:00	AAPL	Stock	112.83	113.52	112.15	113.12	59583.0
2020-11-04 06:00:00	AAPL	Stock	113.14	113.2	112.3	112.3	25602.0
2020-11-04 06:30:00	AAPL	Stock	112.35	113.59	112.35	112.97	38007.0
2020-11-04 07:00:00	AAPL	Stock	112.9	113.72	112.5	113.59	425641.0
2020-11-04 07:30:00	AAPL	Stock	113.59	114.29	113.22	114.18	524025.0
2020-11-04 08:00:00	AAPL	Stock	114.17	114.89	112.52	114.7	1314784.0
2020-11-04 08:30:00	AAPL	Stock	114.75	114.8	114.2	114.35	507673.0
2020-11-04 09:00:00	AAPL	Stock	114.34	114.45	113.5	114.09	788142.0
2020-11-04 09:30:00	AAPL	Stock	114.01	114.48	112.35	113.55	19436244.0
2020-11-04 10:00:00	AAPL	Stock	113.55	115.51	113.5	114.926	15171034.0
2020-11-04 10:30:00	AAPL	Stock	114.93	114.99	114.24	114.89	8962427.0
2020-11-04 11:00:00	AAPL	Stock	114.89	114.92	113.81	114.34	7018561.0
2020-11-04 11:30:00	AAPL	Stock	114.35	115.22	114.35	115.11	6681477.0
2020-11-04 12:00:00	AAPL	Stock	115.1	115.45	114.67	115.25	6386494.0
2020-11-04 12:30:00	AAPL	Stock	115.255	115.59	115.11	115.193	5934546.0
2020-11-04 13:00:00	AAPL	Stock	115.191	115.29	114.71	115.2	5498691.0
2020-11-04 13:30:00	AAPL	Stock	115.206	115.505	114.62	114.86	6255763.0
2020-11-04 14:00:00	AAPL	Stock	114.87	115.13	114.44	114.875	5877073.0
2020-11-04 14:30:00	AAPL	Stock	114.88	115.17	114.47	115.03	5355990.0
2020-11-04 15:00:00	AAPL	Stock	115.035	115.35	114.57	114.772	6197822.0
2020-11-04 15:30:00	AAPL	Stock	114.775	115.5	114.68	114.94	11707085.0
2020-11-04 16:00:00	AAPL	Stock	114.94	115.17	114.88	115.06	10483724.0
2020-11-04 16:30:00	AAPL	Stock	115.05	116.0	114.95	115.8	362616.0
2020-11-04 17:00:00	AAPL	Stock	115.75	115.89	115.59	115.76	77887.0
2020-11-04 17:30:00	AAPL	Stock	115.77	115.79	115.52	115.61	82162.0
2020-11-04 18:00:00	AAPL	Stock	115.6	115.9	115.45	115.85	133190.0
2020-11-04 18:30:00	AAPL	Stock	115.86	115.87	115.43	115.5	104006.0
2020-11-04 19:00:00	AAPL	Stock	115.5	115.65	115.48	115.65	64005.0
2020-11-04 19:30:00	AAPL	Stock	115.66	116.0	115.52	115.99	125634.0
2020-11-04 04:00:00	MSFT	Stock	210.6	213.45	210.6	213.45	26512.0
2020-11-04 04:30:00	MSFT	Stock	213.25	214.18	212.13	213.0	17646.0
2020-11-04 05:00:00	MSFT	Stock	212.32	212.7	210.82	210.82	9266.0
2020-11-04 05:30:00	MSFT	Stock	211.01	212.29	210.0	212.1	9657.0
2020-11-04 06:00:00	MSFT	Stock	211.34	211.78	210.17	210.17	6678.0
2020-11-04 06:30:00	MSFT	Stock	210.7	212.5	210.4	212.09	17427.0
2020-11-04 07:00:00	MSFT	Stock	211.45	212.72	210.75	212.32	73283.0
2020-11-04 07:30:00	MSFT	Stock	212.39	214.51	211.75	214.51	130646.0
2020-11-04 08:00:00	MSFT	Stock	214.5	215.88	210.75	215.39	267476.0
2020-11-04 08:30:00	MSFT	Stock	215.25	215.5	214.2	214.8	128546.0
2020-11-04 09:00:00	MSFT	Stock	214.85	214.884	213.4	214.05	198064.0
2020-11-04 09:30:00	MSFT	Stock	214.02	215.13	212.418	213.75	4785634.0
2020-11-04 10:00:00	MSFT	Stock	213.75	216.44	213.53	215.625	3478952.0
2020-11-04 10:30:00	MSFT	Stock	215.63	216.535	214.97	216.48	2019623.0
2020-11-04 11:00:00	MSFT	Stock	216.48	217.14	215.69	216.69	2192289.0
2020-11-04 11:30:00	MSFT	Stock	216.7	217.42	216.57	217.27	1713853.0
2020-11-04 12:00:00	MSFT	Stock	217.27	217.85	216.64	217.61	1942883.0
2020-11-04 12:30:00	MSFT	Stock	217.61	218.32	217.45	217.588	1724634.0

> showing 50 of 97,855 rows — these rows as CSV

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