PREVIEW / stock_30min / 2021-09-09

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-09.parquet
  size:    2.2 MB
  rows:    108,958
  symbols: 2,738

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-09-09 04:00:00	AAPL	Stock	154.98	155.0	154.62	154.62	11050.0
2021-09-09 04:30:00	AAPL	Stock	154.66	154.66	154.41	154.45	1699.0
2021-09-09 05:00:00	AAPL	Stock	154.43	154.68	154.39	154.66	5176.0
2021-09-09 05:30:00	AAPL	Stock	154.69	154.84	154.69	154.79	9267.0
2021-09-09 06:00:00	AAPL	Stock	154.8	154.82	154.7	154.71	5621.0
2021-09-09 06:30:00	AAPL	Stock	154.77	154.95	154.77	154.95	1927.0
2021-09-09 07:00:00	AAPL	Stock	154.81	154.92	154.72	154.75	20136.0
2021-09-09 07:30:00	AAPL	Stock	154.77	155.16	154.68	155.13	59697.0
2021-09-09 08:00:00	AAPL	Stock	154.9885	155.1581	154.68	155.1	154154.0
2021-09-09 08:30:00	AAPL	Stock	155.09	155.46	155.0	155.38	161662.0
2021-09-09 09:00:00	AAPL	Stock	155.36	155.59	155.25	155.49	212374.0
2021-09-09 09:30:00	AAPL	Stock	155.49	156.11	154.72	155.2912	9759619.0
2021-09-09 10:00:00	AAPL	Stock	155.29	155.605	155.08	155.595	4511052.0
2021-09-09 10:30:00	AAPL	Stock	155.595	155.8	155.175	155.27	3785618.0
2021-09-09 11:00:00	AAPL	Stock	155.28	155.4	154.7901	154.8057	3430421.0
2021-09-09 11:30:00	AAPL	Stock	154.81	155.08	154.75	154.9391	2329835.0
2021-09-09 12:00:00	AAPL	Stock	154.935	155.2	154.78	155.1	2139287.0
2021-09-09 12:30:00	AAPL	Stock	155.0999	155.23	154.87	154.91	1700708.0
2021-09-09 13:00:00	AAPL	Stock	154.9076	155.08	154.32	154.4962	2613039.0
2021-09-09 13:30:00	AAPL	Stock	154.4986	154.6	154.2501	154.4465	2780951.0
2021-09-09 14:00:00	AAPL	Stock	154.44	154.55	154.24	154.425	2043452.0
2021-09-09 14:30:00	AAPL	Stock	154.425	154.5399	154.0825	154.4999	2541130.0
2021-09-09 15:00:00	AAPL	Stock	154.495	154.58	154.18	154.2799	2317996.0
2021-09-09 15:30:00	AAPL	Stock	154.28	154.46	153.95	154.12	5134700.0
2021-09-09 16:00:00	AAPL	Stock	154.1	155.11	154.04	154.49	3992065.0
2021-09-09 16:30:00	AAPL	Stock	154.49	154.49	154.28	154.31	43594.0
2021-09-09 17:00:00	AAPL	Stock	154.33	154.33	154.25	154.26	16284.0
2021-09-09 17:30:00	AAPL	Stock	154.3	154.35	154.2601	154.28	10052.0
2021-09-09 18:00:00	AAPL	Stock	154.31	154.32	154.22	154.27	11607.0
2021-09-09 18:30:00	AAPL	Stock	154.28	154.3	154.2	154.2801	8025.0
2021-09-09 19:00:00	AAPL	Stock	154.3	154.32	154.2	154.32	6993.0
2021-09-09 19:30:00	AAPL	Stock	154.28	154.31	154.16	154.27	27463.0
2021-09-09 04:00:00	MSFT	Stock	299.63	299.63	299.42	299.42	300.0
2021-09-09 04:30:00	MSFT	Stock	299.1	299.1	299.1	299.1	892.0
2021-09-09 05:00:00	MSFT	Stock	299.3	299.35	299.28	299.29	2517.0
2021-09-09 05:30:00	MSFT	Stock	299.29	299.85	299.29	299.85	904.0
2021-09-09 06:00:00	MSFT	Stock	299.61	299.73	299.61	299.73	403.0
2021-09-09 06:30:00	MSFT	Stock	299.66	299.72	299.65	299.65	703.0
2021-09-09 07:00:00	MSFT	Stock	299.59	299.59	299.41	299.41	3401.0
2021-09-09 07:30:00	MSFT	Stock	299.48	300.2	299.25	300.19	6066.0
2021-09-09 08:00:00	MSFT	Stock	299.41	300.31	299.41	299.94	4759.0
2021-09-09 08:30:00	MSFT	Stock	299.99	300.5	299.95	300.28	4926.0
2021-09-09 09:00:00	MSFT	Stock	300.4	300.93	300.17	300.84	28511.0
2021-09-09 09:30:00	MSFT	Stock	300.83	302.14	299.74	301.4	1638404.0
2021-09-09 10:00:00	MSFT	Stock	301.39	301.92	300.535	300.94	772765.0
2021-09-09 10:30:00	MSFT	Stock	300.93	301.17	300.0	300.1597	759890.0
2021-09-09 11:00:00	MSFT	Stock	300.15	300.25	298.92	298.95	970660.0
2021-09-09 11:30:00	MSFT	Stock	298.93	299.48	298.72	299.35	695184.0
2021-09-09 12:00:00	MSFT	Stock	299.3499	299.42	299.0348	299.07	588894.0
2021-09-09 12:30:00	MSFT	Stock	299.06	299.38	298.81	298.84	468417.0

> showing 50 of 108,958 rows — these rows as CSV

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