PREVIEW / stock_30min / 2022-04-04

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-04.parquet
  size:    2.2 MB
  rows:    109,331
  symbols: 2,517

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
2022-04-04 04:00:00	AAPL	Stock	174.18	174.18	173.8	174.11	4015.0
2022-04-04 04:30:00	AAPL	Stock	174.28	174.41	174.22	174.41	4340.0
2022-04-04 05:00:00	AAPL	Stock	174.4	174.79	174.4	174.69	3117.0
2022-04-04 05:30:00	AAPL	Stock	174.65	174.92	174.6	174.92	3058.0
2022-04-04 06:00:00	AAPL	Stock	174.98	175.15	174.87	175.07	11499.0
2022-04-04 06:30:00	AAPL	Stock	175.09	175.1	174.86	174.86	3555.0
2022-04-04 07:00:00	AAPL	Stock	174.83	174.87	174.6	174.82	37860.0
2022-04-04 07:30:00	AAPL	Stock	174.81	174.93	174.68	174.83	22488.0
2022-04-04 08:00:00	AAPL	Stock	174.8	174.9	173.875	174.61	169959.0
2022-04-04 08:30:00	AAPL	Stock	174.63	174.7	174.14	174.26	89203.0
2022-04-04 09:00:00	AAPL	Stock	174.24	174.62	174.24	174.59	106728.0
2022-04-04 09:30:00	AAPL	Stock	174.57	177.95	174.44	177.7801	11485640.0
2022-04-04 10:00:00	AAPL	Stock	177.79	178.21	176.98	177.36	7665053.0
2022-04-04 10:30:00	AAPL	Stock	177.36	177.43	176.73	177.35	5277336.0
2022-04-04 11:00:00	AAPL	Stock	177.36	177.84	177.29	177.645	3349087.0
2022-04-04 11:30:00	AAPL	Stock	177.65	177.705	177.11	177.245	3032672.0
2022-04-04 12:00:00	AAPL	Stock	177.25	177.8306	177.185	177.66	2845882.0
2022-04-04 12:30:00	AAPL	Stock	177.665	177.685	177.01	177.2091	2806888.0
2022-04-04 13:00:00	AAPL	Stock	177.2099	177.32	176.92	177.2296	2320961.0
2022-04-04 13:30:00	AAPL	Stock	177.23	177.615	177.1	177.5352	2421951.0
2022-04-04 14:00:00	AAPL	Stock	177.535	177.545	177.02	177.49	2983177.0
2022-04-04 14:30:00	AAPL	Stock	177.49	177.81	177.422	177.76	2721134.0
2022-04-04 15:00:00	AAPL	Stock	177.76	178.3	177.69	178.29	4689404.0
2022-04-04 15:30:00	AAPL	Stock	178.29	178.49	177.98	178.465	8381501.0
2022-04-04 16:00:00	AAPL	Stock	178.44	178.55	178.32	178.47	7402499.0
2022-04-04 16:30:00	AAPL	Stock	178.45	178.48	178.39	178.39	78928.0
2022-04-04 17:00:00	AAPL	Stock	178.39	178.44	178.3	178.3	110730.0
2022-04-04 17:30:00	AAPL	Stock	178.3	178.39	178.25	178.3072	28547.0
2022-04-04 18:00:00	AAPL	Stock	178.3099	178.5	178.3	178.3	17529.0
2022-04-04 18:30:00	AAPL	Stock	178.3	178.38	178.23	178.34	13784.0
2022-04-04 19:00:00	AAPL	Stock	178.33	178.33	178.28	178.29	23338.0
2022-04-04 19:30:00	AAPL	Stock	178.3	178.37	178.14	178.36	19856.0
2022-04-04 04:00:00	MSFT	Stock	309.01	310.0	309.01	310.0	753.0
2022-04-04 04:30:00	MSFT	Stock	310.3	310.98	310.15	310.62	4897.0
2022-04-04 05:00:00	MSFT	Stock	310.75	310.9	310.75	310.9	237.0
2022-04-04 05:30:00	MSFT	Stock	310.95	311.0	310.75	311.0	2253.0
2022-04-04 06:00:00	MSFT	Stock	311.2	311.24	311.2	311.24	1145.0
2022-04-04 06:30:00	MSFT	Stock	311.25	311.25	311.0	311.0	532.0
2022-04-04 07:00:00	MSFT	Stock	310.82	311.18	310.6	311.11	5543.0
2022-04-04 07:30:00	MSFT	Stock	311.1	311.4	310.94	311.06	10198.0
2022-04-04 08:00:00	MSFT	Stock	310.7	311.24	308.647	310.58	48094.0
2022-04-04 08:30:00	MSFT	Stock	310.36	310.89	309.76	309.9	34874.0
2022-04-04 09:00:00	MSFT	Stock	309.8	310.4	309.8	310.2	24319.0
2022-04-04 09:30:00	MSFT	Stock	310.09	314.33	309.71	313.985	3024233.0
2022-04-04 10:00:00	MSFT	Stock	313.985	314.35	312.19	312.88	1366312.0
2022-04-04 10:30:00	MSFT	Stock	312.89	313.51	312.11	312.5	903891.0
2022-04-04 11:00:00	MSFT	Stock	312.5	313.85	312.485	313.3	843985.0
2022-04-04 11:30:00	MSFT	Stock	313.26	314.02	312.805	313.3	754160.0
2022-04-04 12:00:00	MSFT	Stock	313.34	314.1	313.07	313.82	863644.0
2022-04-04 12:30:00	MSFT	Stock	313.82	314.0	313.27	313.32	645226.0

> showing 50 of 109,331 rows — these rows as CSV

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