PREVIEW / stock_30min / 2021-06-22

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-22.parquet
  size:    2.2 MB
  rows:    110,992
  symbols: 2,940

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-06-22 04:00:00	AAPL	Stock	131.65	131.84	131.39	131.64	25410.0
2021-06-22 04:30:00	AAPL	Stock	131.6	131.7	131.6	131.65	3033.0
2021-06-22 05:00:00	AAPL	Stock	131.7	132.0	131.7	131.92	5410.0
2021-06-22 05:30:00	AAPL	Stock	131.82	131.85	131.67	131.82	6833.0
2021-06-22 06:00:00	AAPL	Stock	131.87	132.08	131.87	132.0	4448.0
2021-06-22 06:30:00	AAPL	Stock	131.98	132.12	131.98	132.04	2167.0
2021-06-22 07:00:00	AAPL	Stock	132.1	132.63	132.09	132.59	50158.0
2021-06-22 07:30:00	AAPL	Stock	132.58	132.63	132.42	132.5	30830.0
2021-06-22 08:00:00	AAPL	Stock	132.2101	132.65	132.06	132.33	202773.0
2021-06-22 08:30:00	AAPL	Stock	132.34	132.4	132.04	132.18	97860.0
2021-06-22 09:00:00	AAPL	Stock	132.19	132.3	132.01	132.1	159337.0
2021-06-22 09:30:00	AAPL	Stock	132.1	132.83	131.77	131.875	9133936.0
2021-06-22 10:00:00	AAPL	Stock	131.88	132.23	131.62	132.1199	5592340.0
2021-06-22 10:30:00	AAPL	Stock	132.115	132.44	132.0599	132.28	3733128.0
2021-06-22 11:00:00	AAPL	Stock	132.275	132.76	132.2401	132.615	3168445.0
2021-06-22 11:30:00	AAPL	Stock	132.615	132.62	132.4	132.45	2521671.0
2021-06-22 12:00:00	AAPL	Stock	132.46	132.9173	132.4	132.9173	2958972.0
2021-06-22 12:30:00	AAPL	Stock	132.915	133.38	132.8	133.1784	5173014.0
2021-06-22 13:00:00	AAPL	Stock	133.17	133.415	133.0423	133.3201	2656148.0
2021-06-22 13:30:00	AAPL	Stock	133.33	133.39	133.125	133.205	1738764.0
2021-06-22 14:00:00	AAPL	Stock	133.205	133.47	133.08	133.3356	2401347.0
2021-06-22 14:30:00	AAPL	Stock	133.33	133.58	133.26	133.565	2859285.0
2021-06-22 15:00:00	AAPL	Stock	133.56	133.99	133.56	133.93	4633287.0
2021-06-22 15:30:00	AAPL	Stock	133.94	134.08	133.6542	133.97	8758068.0
2021-06-22 16:00:00	AAPL	Stock	133.98	134.05	132.8606	133.96	11518958.0
2021-06-22 16:30:00	AAPL	Stock	133.95	134.1	133.95	133.98	56263.0
2021-06-22 17:00:00	AAPL	Stock	134.0	134.05	133.93	133.97	36454.0
2021-06-22 17:30:00	AAPL	Stock	133.95	133.98	133.92	133.97	17491.0
2021-06-22 18:00:00	AAPL	Stock	133.97	134.08	133.89	133.96	69130.0
2021-06-22 18:30:00	AAPL	Stock	133.99	134.07	133.95	133.98	25358.0
2021-06-22 19:00:00	AAPL	Stock	133.98	134.09	133.96	134.05	24272.0
2021-06-22 19:30:00	AAPL	Stock	134.06	134.09	134.03	134.07	28955.0
2021-06-22 04:00:00	MSFT	Stock	261.69	261.8	261.69	261.8	1062.0
2021-06-22 04:30:00	MSFT	Stock	262.2	262.3	262.2	262.3	600.0
2021-06-22 05:00:00	MSFT	Stock	262.39	262.63	262.34	262.63	1657.0
2021-06-22 05:30:00	MSFT	Stock	262.5	262.5	262.5	262.5	467.0
2021-06-22 06:00:00	MSFT	Stock	262.63	263.0	262.63	262.63	1881.0
2021-06-22 07:00:00	MSFT	Stock	263.4	263.77	263.35	263.4	8011.0
2021-06-22 07:30:00	MSFT	Stock	263.4	263.46	263.24	263.35	4276.0
2021-06-22 08:00:00	MSFT	Stock	263.5	263.65	263.08	263.08	15441.0
2021-06-22 08:30:00	MSFT	Stock	263.15	263.35	262.7	263.0	23474.0
2021-06-22 09:00:00	MSFT	Stock	262.96	263.6	262.79	262.79	20681.0
2021-06-22 09:30:00	MSFT	Stock	262.79	264.69	262.4	264.08	2629676.0
2021-06-22 10:00:00	MSFT	Stock	264.08	264.81	263.91	264.215	1403092.0
2021-06-22 10:30:00	MSFT	Stock	264.21	264.63	263.46	263.6882	879315.0
2021-06-22 11:00:00	MSFT	Stock	263.69	264.56	263.37	264.433	753923.0
2021-06-22 11:30:00	MSFT	Stock	264.43	264.44	264.08	264.2599	576603.0
2021-06-22 12:00:00	MSFT	Stock	264.27	264.7563	264.15	264.725	1075759.0
2021-06-22 12:30:00	MSFT	Stock	264.73	264.785	264.53	264.57	480270.0
2021-06-22 13:00:00	MSFT	Stock	264.56	264.68	264.24	264.5493	495548.0

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

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