PREVIEW / stock_30min / 2021-03-18

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-03-18.parquet
  size:    2.3 MB
  rows:    116,850
  symbols: 2,909

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-03-18 04:00:00	AAPL	Stock	123.36	124.27	123.36	123.85	21148.0
2021-03-18 04:30:00	AAPL	Stock	123.96	123.96	123.04	123.04	19627.0
2021-03-18 05:00:00	AAPL	Stock	123.19	123.51	123.02	123.35	10032.0
2021-03-18 05:30:00	AAPL	Stock	123.57	123.7	123.13	123.42	8100.0
2021-03-18 06:00:00	AAPL	Stock	123.6	123.69	123.45	123.61	4491.0
2021-03-18 06:30:00	AAPL	Stock	123.63	123.85	123.51	123.6	11870.0
2021-03-18 07:00:00	AAPL	Stock	123.65	123.89	123.25	123.4	205070.0
2021-03-18 07:30:00	AAPL	Stock	123.38	123.43	122.69	123.0	247280.0
2021-03-18 08:00:00	AAPL	Stock	123.8	125.071	122.68	123.04	473482.0
2021-03-18 08:30:00	AAPL	Stock	123.0	123.07	122.72	122.92	261824.0
2021-03-18 09:00:00	AAPL	Stock	122.92	123.1	122.68	122.85	429406.0
2021-03-18 09:30:00	AAPL	Stock	122.86	123.18	121.78	122.36	13762837.0
2021-03-18 10:00:00	AAPL	Stock	122.35	122.4	121.59	122.185	8717805.0
2021-03-18 10:30:00	AAPL	Stock	122.18	122.64	122.0099	122.51	6412774.0
2021-03-18 11:00:00	AAPL	Stock	122.51	122.73	121.96	122.21	5216610.0
2021-03-18 11:30:00	AAPL	Stock	122.21	122.27	121.77	121.93	4680944.0
2021-03-18 12:00:00	AAPL	Stock	121.93	122.59	121.835	122.32	4766595.0
2021-03-18 12:30:00	AAPL	Stock	122.32	122.34	121.71	121.75	4444346.0
2021-03-18 13:00:00	AAPL	Stock	121.76	122.04	121.7	121.9	4795264.0
2021-03-18 13:30:00	AAPL	Stock	121.9001	122.215	121.7	121.97	4955815.0
2021-03-18 14:00:00	AAPL	Stock	121.96	122.03	121.38	121.425	4984830.0
2021-03-18 14:30:00	AAPL	Stock	121.43	121.54	121.02	121.17	6955231.0
2021-03-18 15:00:00	AAPL	Stock	121.17	121.37	120.65	121.055	8310879.0
2021-03-18 15:30:00	AAPL	Stock	121.04	121.08	120.32	120.55	13544102.0
2021-03-18 16:00:00	AAPL	Stock	120.55	121.427	120.4	120.76	10206923.0
2021-03-18 16:30:00	AAPL	Stock	120.76	120.77	120.5	120.63	125733.0
2021-03-18 17:00:00	AAPL	Stock	120.61	120.78	120.57	120.61	51034.0
2021-03-18 17:30:00	AAPL	Stock	120.63	120.78	120.5	120.72	68347.0
2021-03-18 18:00:00	AAPL	Stock	120.75	120.87	120.72	120.75	60719.0
2021-03-18 18:30:00	AAPL	Stock	120.75	120.79	120.61	120.62	49179.0
2021-03-18 19:00:00	AAPL	Stock	120.65	120.65	120.5	120.5499	48022.0
2021-03-18 19:30:00	AAPL	Stock	120.58	120.67	120.5	120.55	77268.0
2021-03-18 04:00:00	MSFT	Stock	235.38	235.38	234.99	235.09	3490.0
2021-03-18 04:30:00	MSFT	Stock	234.92	234.92	234.13	234.4	3174.0
2021-03-18 05:00:00	MSFT	Stock	234.4	234.96	234.2	234.96	6076.0
2021-03-18 05:30:00	MSFT	Stock	234.9	235.37	234.85	234.85	3266.0
2021-03-18 06:00:00	MSFT	Stock	234.85	235.0	234.85	235.0	888.0
2021-03-18 06:30:00	MSFT	Stock	235.17	235.97	235.06	235.07	5595.0
2021-03-18 07:00:00	MSFT	Stock	235.29	235.46	234.2	234.6	30868.0
2021-03-18 07:30:00	MSFT	Stock	234.5	234.5	233.11	233.56	40014.0
2021-03-18 08:00:00	MSFT	Stock	234.839	236.448	233.26	233.85	25223.0
2021-03-18 08:30:00	MSFT	Stock	233.85	233.9	233.25	233.6	21614.0
2021-03-18 09:00:00	MSFT	Stock	233.6	233.72	232.03	232.72	69560.0
2021-03-18 09:30:00	MSFT	Stock	232.35	234.19	232.17	233.26	2549557.0
2021-03-18 10:00:00	MSFT	Stock	233.21	233.29	232.21	232.9099	1875399.0
2021-03-18 10:30:00	MSFT	Stock	232.9	233.36	232.38	232.99	1606289.0
2021-03-18 11:00:00	MSFT	Stock	233.0	233.3	232.3	232.61	1090607.0
2021-03-18 11:30:00	MSFT	Stock	232.61	232.6786	232.03	232.38	1280595.0
2021-03-18 12:00:00	MSFT	Stock	232.38	233.4	232.09	233.05	1044620.0
2021-03-18 12:30:00	MSFT	Stock	233.04	233.14	231.8	231.89	1146554.0

> showing 50 of 116,850 rows — these rows as CSV

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