PREVIEW / stock_30min / 2022-07-27

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-27.parquet
  size:    2.1 MB
  rows:    102,504
  symbols: 2,262

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-07-27 04:00:00	AAPL	Stock	152.9	153.3	152.8	153.26	17458.0
2022-07-27 04:30:00	AAPL	Stock	153.29	153.45	153.25	153.33	12705.0
2022-07-27 05:00:00	AAPL	Stock	153.35	153.4	153.05	153.06	18234.0
2022-07-27 05:30:00	AAPL	Stock	153.17	153.23	153.03	153.15	10138.0
2022-07-27 06:00:00	AAPL	Stock	153.1	153.15	152.92	152.92	7759.0
2022-07-27 06:30:00	AAPL	Stock	152.95	153.04	152.82	152.99	4221.0
2022-07-27 07:00:00	AAPL	Stock	152.99	152.99	152.67	152.84	28315.0
2022-07-27 07:30:00	AAPL	Stock	152.84	152.85	152.69	152.72	13389.0
2022-07-27 08:00:00	AAPL	Stock	152.92	153.04	151.221	152.6106	137680.0
2022-07-27 08:30:00	AAPL	Stock	152.62	152.9	152.51	152.89	88915.0
2022-07-27 09:00:00	AAPL	Stock	152.89	153.1	152.27	152.54	220741.0
2022-07-27 09:30:00	AAPL	Stock	152.55	154.8	152.16	154.37	8427216.0
2022-07-27 10:00:00	AAPL	Stock	154.37	154.72	154.1	154.7	4245097.0
2022-07-27 10:30:00	AAPL	Stock	154.7	154.77	154.1636	154.395	3059710.0
2022-07-27 11:00:00	AAPL	Stock	154.399	154.58	153.575	153.78	2926168.0
2022-07-27 11:30:00	AAPL	Stock	153.7731	154.28	153.76	154.1599	2310604.0
2022-07-27 12:00:00	AAPL	Stock	154.16	154.56	154.015	154.385	1971467.0
2022-07-27 12:30:00	AAPL	Stock	154.39	154.4	154.06	154.26	1772345.0
2022-07-27 13:00:00	AAPL	Stock	154.25	154.57	154.16	154.42	1780326.0
2022-07-27 13:30:00	AAPL	Stock	154.43	154.59	154.28	154.3943	1609965.0
2022-07-27 14:00:00	AAPL	Stock	154.402	155.0	154.0	154.455	3455307.0
2022-07-27 14:30:00	AAPL	Stock	154.46	156.23	153.91	155.91	6051529.0
2022-07-27 15:00:00	AAPL	Stock	155.92	157.2899	155.72	157.2899	5709736.0
2022-07-27 15:30:00	AAPL	Stock	157.29	157.33	156.54	156.71	9609940.0
2022-07-27 16:00:00	AAPL	Stock	156.71	156.79	155.71	155.93	12349377.0
2022-07-27 16:30:00	AAPL	Stock	156.2	156.79	155.8	155.8	148314.0
2022-07-27 17:00:00	AAPL	Stock	155.9	156.79	155.81	156.1	87318.0
2022-07-27 17:30:00	AAPL	Stock	156.1	156.25	156.06	156.2	52609.0
2022-07-27 18:00:00	AAPL	Stock	156.2	156.38	156.06	156.33	65066.0
2022-07-27 18:30:00	AAPL	Stock	156.35	156.45	156.25	156.28	18642.0
2022-07-27 19:00:00	AAPL	Stock	156.3	156.5	156.3	156.48	17629.0
2022-07-27 19:30:00	AAPL	Stock	156.42	156.5	156.36	156.5	52647.0
2022-07-27 04:00:00	MSFT	Stock	261.5	262.87	261.16	261.85	36637.0
2022-07-27 04:30:00	MSFT	Stock	261.7	261.84	261.3	261.5	8184.0
2022-07-27 05:00:00	MSFT	Stock	261.51	261.51	260.76	261.0	4339.0
2022-07-27 05:30:00	MSFT	Stock	261.35	261.55	261.0	261.01	13971.0
2022-07-27 06:00:00	MSFT	Stock	261.04	261.59	261.0	261.59	10126.0
2022-07-27 06:30:00	MSFT	Stock	261.45	261.84	261.32	261.84	6077.0
2022-07-27 07:00:00	MSFT	Stock	261.82	261.88	259.37	260.03	91052.0
2022-07-27 07:30:00	MSFT	Stock	260.25	260.54	260.0	260.4	51793.0
2022-07-27 08:00:00	MSFT	Stock	261.8398	263.33	258.9	260.7	203504.0
2022-07-27 08:30:00	MSFT	Stock	260.7	262.2	259.4	261.15	115677.0
2022-07-27 09:00:00	MSFT	Stock	261.09	261.7	260.0	261.09	105657.0
2022-07-27 09:30:00	MSFT	Stock	261.15	265.0	258.85	263.66	6819508.0
2022-07-27 10:00:00	MSFT	Stock	263.69	264.93	262.83	263.5	2416613.0
2022-07-27 10:30:00	MSFT	Stock	263.5	263.73	262.63	263.22	1569900.0
2022-07-27 11:00:00	MSFT	Stock	263.2	264.8704	262.95	263.49	1605646.0
2022-07-27 11:30:00	MSFT	Stock	263.48	264.74	263.45	264.34	1029291.0
2022-07-27 12:00:00	MSFT	Stock	264.34	265.55	264.265	264.9495	1586928.0
2022-07-27 12:30:00	MSFT	Stock	264.94	265.0699	263.56	263.86	945563.0

> showing 50 of 102,504 rows — these rows as CSV

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