PREVIEW / stock_30min / 2020-02-21

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-21.parquet
  size:    1.8 MB
  rows:    86,597
  symbols: 2,425

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-02-21 04:00:00	AAPL	Stock	79.425	79.5025	79.415	79.465	16852.0
2020-02-21 04:30:00	AAPL	Stock	79.485	79.485	79.35	79.35	19952.0
2020-02-21 05:00:00	AAPL	Stock	79.42	79.565	79.42	79.5225	10352.0
2020-02-21 05:30:00	AAPL	Stock	79.4825	79.625	79.475	79.625	11408.0
2020-02-21 06:00:00	AAPL	Stock	79.5	79.5	79.4575	79.4575	9816.0
2020-02-21 06:30:00	AAPL	Stock	79.495	79.6725	79.495	79.61	4660.0
2020-02-21 07:00:00	AAPL	Stock	79.5175	79.625	79.5	79.625	109456.0
2020-02-21 07:30:00	AAPL	Stock	79.635	79.7775	79.625	79.675	69764.0
2020-02-21 08:00:00	AAPL	Stock	79.575	79.7825	79.525	79.6	272304.0
2020-02-21 08:30:00	AAPL	Stock	79.625	79.667	79.55	79.6	84304.0
2020-02-21 09:00:00	AAPL	Stock	79.5875	79.825	79.5875	79.5875	249396.0
2020-02-21 09:30:00	AAPL	Stock	79.5875	80.1125	79.075	79.3175	17207488.0
2020-02-21 10:00:00	AAPL	Stock	79.32	79.445	79.1075	79.3732	6722068.0
2020-02-21 10:30:00	AAPL	Stock	79.375	79.42	78.8928	79.0725	6347544.0
2020-02-21 11:00:00	AAPL	Stock	79.075	79.24	78.91	79.22	4008716.0
2020-02-21 11:30:00	AAPL	Stock	79.22	79.32	79.1375	79.2398	2907028.0
2020-02-21 12:00:00	AAPL	Stock	79.2338	79.355	78.9775	79.02	3316460.0
2020-02-21 12:30:00	AAPL	Stock	79.021	79.0498	78.6675	78.7762	5224720.0
2020-02-21 13:00:00	AAPL	Stock	78.78	78.8675	78.5875	78.639	4001236.0
2020-02-21 13:30:00	AAPL	Stock	78.6365	78.64	77.795	78.0288	10955324.0
2020-02-21 14:00:00	AAPL	Stock	78.02	78.155	77.625	77.895	9348676.0
2020-02-21 14:30:00	AAPL	Stock	77.89	78.15	77.84	78.0325	6239712.0
2020-02-21 15:00:00	AAPL	Stock	78.025	78.0725	77.7775	77.8325	5268380.0
2020-02-21 15:30:00	AAPL	Stock	77.8275	78.39	77.71	78.2575	12390416.0
2020-02-21 16:00:00	AAPL	Stock	78.2625	78.275	78.175	78.2125	11168524.0
2020-02-21 16:30:00	AAPL	Stock	78.2125	78.27	78.15	78.2	502652.0
2020-02-21 17:00:00	AAPL	Stock	78.2	78.24	78.1625	78.1875	106884.0
2020-02-21 17:30:00	AAPL	Stock	78.1875	78.21	78.1675	78.2	33224.0
2020-02-21 18:00:00	AAPL	Stock	78.2	78.215	78.0375	78.0375	19076.0
2020-02-21 18:30:00	AAPL	Stock	78.125	78.125	78.025	78.075	34564.0
2020-02-21 19:00:00	AAPL	Stock	78.0875	78.095	78.0275	78.0275	40420.0
2020-02-21 19:30:00	AAPL	Stock	78.055	78.075	78.005	78.0625	30076.0
2020-02-21 04:00:00	MSFT	Stock	183.59	183.66	183.4	183.5	1770.0
2020-02-21 04:30:00	MSFT	Stock	183.31	183.49	183.23	183.23	754.0
2020-02-21 05:00:00	MSFT	Stock	183.3	183.5	183.3	183.5	1976.0
2020-02-21 05:30:00	MSFT	Stock	183.66	183.66	183.65	183.66	850.0
2020-02-21 06:00:00	MSFT	Stock	183.55	183.55	183.36	183.36	238.0
2020-02-21 06:30:00	MSFT	Stock	183.55	183.55	183.4	183.4	401.0
2020-02-21 07:00:00	MSFT	Stock	183.4	183.57	183.34	183.5	17867.0
2020-02-21 07:30:00	MSFT	Stock	183.5	183.79	183.5	183.75	13727.0
2020-02-21 08:00:00	MSFT	Stock	183.45	183.84	183.32	183.41	37365.0
2020-02-21 08:30:00	MSFT	Stock	183.43	183.55	183.19	183.54	26383.0
2020-02-21 09:00:00	MSFT	Stock	183.48	184.2	183.17	183.17	55433.0
2020-02-21 09:30:00	MSFT	Stock	183.17	183.5	178.23	180.055	9231244.0
2020-02-21 10:00:00	MSFT	Stock	180.04	181.13	179.53	180.92	3537694.0
2020-02-21 10:30:00	MSFT	Stock	180.9	181.01	179.828	180.5	2197406.0
2020-02-21 11:00:00	MSFT	Stock	180.52	181.06	180.02	180.559	1861097.0
2020-02-21 11:30:00	MSFT	Stock	180.58	180.68	179.91	179.95	1618934.0
2020-02-21 12:00:00	MSFT	Stock	179.94	180.45	179.92	179.96	1220497.0
2020-02-21 12:30:00	MSFT	Stock	179.95	180.04	179.25	179.508	1535778.0

> showing 50 of 86,597 rows — these rows as CSV

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