PREVIEW / stock_30min / 2023-05-19

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-19.parquet
  size:    2.0 MB
  rows:    99,877
  symbols: 1,635

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
2023-05-19 04:00:00	AAPL	Stock	175.35	175.36	175.05	175.2	18335.0
2023-05-19 04:30:00	AAPL	Stock	175.29	175.51	175.29	175.51	4699.0
2023-05-19 05:00:00	AAPL	Stock	175.58	175.58	175.4	175.49	4877.0
2023-05-19 05:30:00	AAPL	Stock	175.49	175.62	175.4	175.62	2422.0
2023-05-19 06:00:00	AAPL	Stock	175.54	175.55	175.3	175.39	1884.0
2023-05-19 06:30:00	AAPL	Stock	175.37	175.38	175.22	175.35	5539.0
2023-05-19 07:00:00	AAPL	Stock	175.35	175.67	175.25	175.67	41691.0
2023-05-19 07:30:00	AAPL	Stock	175.75	175.95	175.32	175.7	44773.0
2023-05-19 08:00:00	AAPL	Stock	175.39	175.89	175.06	175.6181	81637.0
2023-05-19 08:30:00	AAPL	Stock	175.65	176.0	175.6	175.95	96087.0
2023-05-19 09:00:00	AAPL	Stock	175.98	176.44	175.86	176.39	315952.0
2023-05-19 09:30:00	AAPL	Stock	176.11	176.44	175.53	176.0	6993787.0
2023-05-19 10:00:00	AAPL	Stock	175.995	176.02	175.42	175.88	3011924.0
2023-05-19 10:30:00	AAPL	Stock	175.875	176.29	175.4	175.7	3361491.0
2023-05-19 11:00:00	AAPL	Stock	175.705	176.02	175.47	175.4759	3083164.0
2023-05-19 11:30:00	AAPL	Stock	175.46	175.98	175.21	175.645	3124748.0
2023-05-19 12:00:00	AAPL	Stock	175.64	175.825	175.35	175.44	2066605.0
2023-05-19 12:30:00	AAPL	Stock	175.43	175.5758	175.085	175.33	2329233.0
2023-05-19 13:00:00	AAPL	Stock	175.32	175.79	175.26	175.735	1541675.0
2023-05-19 13:30:00	AAPL	Stock	175.74	175.89	175.3	175.32	1461848.0
2023-05-19 14:00:00	AAPL	Stock	175.32	175.54	175.1	175.2322	1631028.0
2023-05-19 14:30:00	AAPL	Stock	175.2412	175.6	175.14	175.53	1772568.0
2023-05-19 15:00:00	AAPL	Stock	175.5289	175.6	175.1211	175.13	1867850.0
2023-05-19 15:30:00	AAPL	Stock	175.14	175.36	174.94	175.19	4538631.0
2023-05-19 16:00:00	AAPL	Stock	175.21	175.21	174.96	174.98	5961967.0
2023-05-19 16:30:00	AAPL	Stock	174.97	175.16	174.96	174.99	401530.0
2023-05-19 17:00:00	AAPL	Stock	174.99	175.0	174.97	174.9981	8687.0
2023-05-19 17:30:00	AAPL	Stock	174.972	175.0	174.95	174.95	4557.0
2023-05-19 18:00:00	AAPL	Stock	174.94	174.97	174.94	174.97	11522.0
2023-05-19 18:30:00	AAPL	Stock	175.03	175.07	175.01	175.07	13912.0
2023-05-19 19:00:00	AAPL	Stock	175.06	175.06	174.98	175.06	2729.0
2023-05-19 19:30:00	AAPL	Stock	175.07	175.1	175.02	175.09	8704.0
2023-05-19 04:00:00	MSFT	Stock	319.4	319.48	317.83	318.52	2171.0
2023-05-19 04:30:00	MSFT	Stock	318.79	319.0	318.79	319.0	1113.0
2023-05-19 05:00:00	MSFT	Stock	319.01	319.18	318.95	318.95	1685.0
2023-05-19 05:30:00	MSFT	Stock	318.97	318.97	318.8	318.8	803.0
2023-05-19 06:00:00	MSFT	Stock	318.87	318.87	316.61	316.99	15037.0
2023-05-19 06:30:00	MSFT	Stock	317.0	317.0	316.0	316.18	4377.0
2023-05-19 07:00:00	MSFT	Stock	316.36	318.31	316.02	317.66	22230.0
2023-05-19 07:30:00	MSFT	Stock	317.75	317.75	316.74	317.2	17498.0
2023-05-19 08:00:00	MSFT	Stock	316.37	319.5	316.37	317.25	34203.0
2023-05-19 08:30:00	MSFT	Stock	317.32	317.89	317.19	317.5	18014.0
2023-05-19 09:00:00	MSFT	Stock	317.69	318.35	316.06	316.94	58801.0
2023-05-19 09:30:00	MSFT	Stock	316.74	318.66	316.715	317.74	3331069.0
2023-05-19 10:00:00	MSFT	Stock	317.72	317.99	316.77	317.83	1232397.0
2023-05-19 10:30:00	MSFT	Stock	317.81	318.4199	317.09	317.87	1035022.0
2023-05-19 11:00:00	MSFT	Stock	317.86	317.98	317.03	317.12	925438.0
2023-05-19 11:30:00	MSFT	Stock	317.11	318.09	316.62	317.535	1178339.0
2023-05-19 12:00:00	MSFT	Stock	317.55	317.76	316.735	316.95	930662.0
2023-05-19 12:30:00	MSFT	Stock	316.9	317.59	316.37	317.44	695314.0

> showing 50 of 99,877 rows — these rows as CSV

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