PREVIEW / stock_30min / 2021-05-19

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-05-19.parquet
  size:    2.2 MB
  rows:    110,822
  symbols: 2,957

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
2021-05-19 04:00:00	AAPL	Stock	123.83	123.83	123.2	123.5	27670.0
2021-05-19 04:30:00	AAPL	Stock	123.5	123.58	123.16	123.44	24544.0
2021-05-19 05:00:00	AAPL	Stock	123.5	123.71	123.5	123.61	3618.0
2021-05-19 05:30:00	AAPL	Stock	123.6	123.64	123.01	123.19	25725.0
2021-05-19 06:00:00	AAPL	Stock	123.1	123.41	123.06	123.32	11333.0
2021-05-19 06:30:00	AAPL	Stock	123.36	123.48	123.27	123.41	5192.0
2021-05-19 07:00:00	AAPL	Stock	123.5	123.67	123.03	123.18	156066.0
2021-05-19 07:30:00	AAPL	Stock	123.15	123.19	122.95	123.05	147633.0
2021-05-19 08:00:00	AAPL	Stock	123.52	125.162	122.99	123.15	312466.0
2021-05-19 08:30:00	AAPL	Stock	123.15	123.3	122.85	123.0401	254881.0
2021-05-19 09:00:00	AAPL	Stock	123.06	123.24	122.86	123.12	292853.0
2021-05-19 09:30:00	AAPL	Stock	123.16	124.07	122.86	123.35	10786462.0
2021-05-19 10:00:00	AAPL	Stock	123.345	123.85	123.1075	123.76	6445141.0
2021-05-19 10:30:00	AAPL	Stock	123.7557	124.05	123.45	123.62	5495718.0
2021-05-19 11:00:00	AAPL	Stock	123.62	124.12	123.31	123.7517	5533245.0
2021-05-19 11:30:00	AAPL	Stock	123.755	123.99	123.55	123.9001	3993145.0
2021-05-19 12:00:00	AAPL	Stock	123.8901	124.215	123.715	124.15	3905279.0
2021-05-19 12:30:00	AAPL	Stock	124.16	124.25	123.84	123.99	2978516.0
2021-05-19 13:00:00	AAPL	Stock	123.98	124.439	123.9789	124.2501	3145371.0
2021-05-19 13:30:00	AAPL	Stock	124.25	124.42	123.97	124.26	2685156.0
2021-05-19 14:00:00	AAPL	Stock	124.26	124.79	123.5	124.7199	6245430.0
2021-05-19 14:30:00	AAPL	Stock	124.71	124.915	123.81	123.95	5144946.0
2021-05-19 15:00:00	AAPL	Stock	123.95	124.64	123.77	124.5472	4432023.0
2021-05-19 15:30:00	AAPL	Stock	124.545	124.79	123.88	124.69	7852595.0
2021-05-19 16:00:00	AAPL	Stock	124.7	124.82	124.46	124.58	9990230.0
2021-05-19 16:30:00	AAPL	Stock	124.57	124.69	124.56	124.67	32104.0
2021-05-19 17:00:00	AAPL	Stock	124.63	124.72	124.5501	124.62	14154.0
2021-05-19 17:30:00	AAPL	Stock	124.62	124.74	124.62	124.68	16779.0
2021-05-19 18:00:00	AAPL	Stock	124.69	124.74	124.59	124.61	35985.0
2021-05-19 18:30:00	AAPL	Stock	124.64	124.65	124.45	124.45	26991.0
2021-05-19 19:00:00	AAPL	Stock	124.47	124.48	124.33	124.39	23541.0
2021-05-19 19:30:00	AAPL	Stock	124.37	124.39	124.22	124.3	39080.0
2021-05-19 04:00:00	MSFT	Stock	240.5	240.5	240.0	240.1	6839.0
2021-05-19 04:30:00	MSFT	Stock	240.14	240.14	239.65	239.7	2587.0
2021-05-19 05:00:00	MSFT	Stock	239.95	241.0	239.95	241.0	3147.0
2021-05-19 05:30:00	MSFT	Stock	240.3	240.3	239.11	239.21	2512.0
2021-05-19 06:00:00	MSFT	Stock	239.7	239.72	239.53	239.72	1963.0
2021-05-19 06:30:00	MSFT	Stock	239.9	240.0	239.7	239.7	3967.0
2021-05-19 07:00:00	MSFT	Stock	240.28	240.28	239.2	239.45	16809.0
2021-05-19 07:30:00	MSFT	Stock	239.25	239.25	238.9	239.1	17959.0
2021-05-19 08:00:00	MSFT	Stock	240.15	240.5	238.88	239.27	50811.0
2021-05-19 08:30:00	MSFT	Stock	239.4	239.53	238.9001	238.9001	22397.0
2021-05-19 09:00:00	MSFT	Stock	238.9	239.4	238.32	239.26	55788.0
2021-05-19 09:30:00	MSFT	Stock	239.31	241.2126	238.6	239.9901	2747722.0
2021-05-19 10:00:00	MSFT	Stock	239.99	241.51	239.65	241.22	1817597.0
2021-05-19 10:30:00	MSFT	Stock	241.19	241.56	240.34	240.965	1045060.0
2021-05-19 11:00:00	MSFT	Stock	240.96	241.91	240.72	241.42	910250.0
2021-05-19 11:30:00	MSFT	Stock	241.4	241.65	240.82	241.59	719265.0
2021-05-19 12:00:00	MSFT	Stock	241.53	241.92	241.3	241.71	664844.0
2021-05-19 12:30:00	MSFT	Stock	241.74	242.17	241.63	241.94	745042.0

> showing 50 of 110,822 rows — these rows as CSV

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