PREVIEW / stock_30min / 2020-08-18

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-18.parquet
  size:    1.9 MB
  rows:    97,034
  symbols: 2,444

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-08-18 04:00:00	AAPL	Stock	114.6825	114.9975	114.595	114.86	20888.0
2020-08-18 04:30:00	AAPL	Stock	114.925	114.9975	114.9	114.95	5160.0
2020-08-18 05:00:00	AAPL	Stock	114.9975	115.115	114.95	115.1125	5908.0
2020-08-18 05:30:00	AAPL	Stock	115.17	115.17	115.12	115.1375	6100.0
2020-08-18 06:00:00	AAPL	Stock	115.1125	115.1825	115.0	115.0	11760.0
2020-08-18 06:30:00	AAPL	Stock	115.0475	115.05	114.995	115.025	10128.0
2020-08-18 07:00:00	AAPL	Stock	115.1	115.1	114.1875	114.1875	310952.0
2020-08-18 07:30:00	AAPL	Stock	114.2125	114.47	114.175	114.325	112532.0
2020-08-18 08:00:00	AAPL	Stock	114.65	115.17	114.125	114.42	322972.0
2020-08-18 08:30:00	AAPL	Stock	114.39	114.875	114.3525	114.58	314760.0
2020-08-18 09:00:00	AAPL	Stock	114.5575	114.6775	114.34	114.375	293548.0
2020-08-18 09:30:00	AAPL	Stock	114.35	115.5	114.18	114.62	14277496.0
2020-08-18 10:00:00	AAPL	Stock	114.6175	114.69	114.055	114.105	6288024.0
2020-08-18 10:30:00	AAPL	Stock	114.1	115.095	114.0075	114.9902	5618220.0
2020-08-18 11:00:00	AAPL	Stock	114.9925	115.2	114.8175	115.0745	3796428.0
2020-08-18 11:30:00	AAPL	Stock	115.0875	115.175	114.8	115.126	3527612.0
2020-08-18 12:00:00	AAPL	Stock	115.1092	115.465	115.095	115.31	4186876.0
2020-08-18 12:30:00	AAPL	Stock	115.3	115.705	115.295	115.375	5231568.0
2020-08-18 13:00:00	AAPL	Stock	115.3775	115.625	115.211	115.5775	4124508.0
2020-08-18 13:30:00	AAPL	Stock	115.586	115.875	115.5575	115.645	5580292.0
2020-08-18 14:00:00	AAPL	Stock	115.6525	116.0	115.5488	115.9158	5193304.0
2020-08-18 14:30:00	AAPL	Stock	115.9225	115.9728	115.6	115.6875	4087664.0
2020-08-18 15:00:00	AAPL	Stock	115.6925	115.7075	115.4	115.568	5300228.0
2020-08-18 15:30:00	AAPL	Stock	115.565	115.71	115.4375	115.52	7011996.0
2020-08-18 16:00:00	AAPL	Stock	115.5625	115.675	115.5175	115.525	4628172.0
2020-08-18 16:30:00	AAPL	Stock	115.6425	115.675	115.5375	115.675	15008.0
2020-08-18 17:00:00	AAPL	Stock	115.685	115.685	115.65	115.675	13448.0
2020-08-18 17:30:00	AAPL	Stock	115.675	115.75	115.6	115.7	29544.0
2020-08-18 18:00:00	AAPL	Stock	115.74	115.765	115.6875	115.69	50624.0
2020-08-18 18:30:00	AAPL	Stock	115.72	115.72	115.655	115.7	13032.0
2020-08-18 19:00:00	AAPL	Stock	115.6625	115.7	115.65	115.6875	32072.0
2020-08-18 19:30:00	AAPL	Stock	115.6875	115.7475	115.615	115.7125	45160.0
2020-08-18 04:00:00	MSFT	Stock	210.08	210.08	209.9	209.9	602.0
2020-08-18 04:30:00	MSFT	Stock	209.9	209.93	209.83	209.87	1324.0
2020-08-18 05:00:00	MSFT	Stock	209.84	210.25	209.84	210.25	1648.0
2020-08-18 05:30:00	MSFT	Stock	210.4	210.4	210.4	210.4	200.0
2020-08-18 06:00:00	MSFT	Stock	210.26	210.55	210.25	210.44	1787.0
2020-08-18 06:30:00	MSFT	Stock	210.55	210.67	210.49	210.67	755.0
2020-08-18 07:00:00	MSFT	Stock	210.45	210.68	210.08	210.26	14828.0
2020-08-18 07:30:00	MSFT	Stock	210.14	210.28	210.07	210.28	12952.0
2020-08-18 08:00:00	MSFT	Stock	210.439	210.78	210.06	210.78	18772.0
2020-08-18 08:30:00	MSFT	Stock	210.76	211.0	210.28	210.5	14720.0
2020-08-18 09:00:00	MSFT	Stock	210.42	210.5	209.81	210.5	28364.0
2020-08-18 09:30:00	MSFT	Stock	210.49	212.36	209.87	210.62	2733995.0
2020-08-18 10:00:00	MSFT	Stock	210.63	210.75	209.21	209.46	1096378.0
2020-08-18 10:30:00	MSFT	Stock	209.45	210.2	209.25	210.1	727295.0
2020-08-18 11:00:00	MSFT	Stock	210.1	210.6	209.96	210.47	531367.0
2020-08-18 11:30:00	MSFT	Stock	210.48	210.69	210.3	210.36	456296.0
2020-08-18 12:00:00	MSFT	Stock	210.35	210.66	210.16	210.29	373596.0
2020-08-18 12:30:00	MSFT	Stock	210.31	210.88	210.285	210.491	455043.0

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

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