PREVIEW / stock_30min / 2022-02-14

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-02-14.parquet
  size:    2.2 MB
  rows:    109,315
  symbols: 2,551

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-02-14 04:00:00	AAPL	Stock	168.2	168.2	165.25	166.2	79942.0
2022-02-14 04:30:00	AAPL	Stock	166.3	166.4	165.9	166.0	17170.0
2022-02-14 05:00:00	AAPL	Stock	165.88	166.41	165.62	166.37	21397.0
2022-02-14 05:30:00	AAPL	Stock	166.12	166.6	166.12	166.39	11312.0
2022-02-14 06:00:00	AAPL	Stock	166.22	166.4	165.87	166.4	26447.0
2022-02-14 06:30:00	AAPL	Stock	166.2	166.75	166.14	166.49	38945.0
2022-02-14 07:00:00	AAPL	Stock	166.49	166.79	166.0	166.24	93172.0
2022-02-14 07:30:00	AAPL	Stock	166.2	168.4	166.0	168.01	284039.0
2022-02-14 08:00:00	AAPL	Stock	166.22	168.45	165.92	168.12	504635.0
2022-02-14 08:30:00	AAPL	Stock	168.17	168.22	167.35	167.51	165729.0
2022-02-14 09:00:00	AAPL	Stock	167.55	168.19	166.86	167.37	326953.0
2022-02-14 09:30:00	AAPL	Stock	167.37	169.0	167.09	168.435	8297965.0
2022-02-14 10:00:00	AAPL	Stock	168.42	168.75	167.57	168.42	5327660.0
2022-02-14 10:30:00	AAPL	Stock	168.4299	168.68	167.7	167.885	4055467.0
2022-02-14 11:00:00	AAPL	Stock	167.89	169.17	167.78	168.99	3546443.0
2022-02-14 11:30:00	AAPL	Stock	169.0	169.2	168.47	168.875	3309848.0
2022-02-14 12:00:00	AAPL	Stock	168.88	169.34	168.72	169.33	2463216.0
2022-02-14 12:30:00	AAPL	Stock	169.315	169.48	169.05	169.28	2166580.0
2022-02-14 13:00:00	AAPL	Stock	169.28	169.58	168.8501	168.959	2199475.0
2022-02-14 13:30:00	AAPL	Stock	168.965	168.97	166.87	166.89	3838763.0
2022-02-14 14:00:00	AAPL	Stock	166.9	168.16	166.56	167.5	4168882.0
2022-02-14 14:30:00	AAPL	Stock	167.5	168.56	167.0	168.16	3645886.0
2022-02-14 15:00:00	AAPL	Stock	168.16	169.1289	167.75	168.5303	3769489.0
2022-02-14 15:30:00	AAPL	Stock	168.54	169.39	167.72	169.13	10582696.0
2022-02-14 16:00:00	AAPL	Stock	168.88	168.95	168.66	168.8	15314626.0
2022-02-14 16:30:00	AAPL	Stock	168.8	168.88	168.7	168.75	46978.0
2022-02-14 17:00:00	AAPL	Stock	168.78	168.88	168.66	168.66	12069.0
2022-02-14 17:30:00	AAPL	Stock	168.67	168.68	168.6	168.65	6127.0
2022-02-14 18:00:00	AAPL	Stock	168.7	169.02	168.7	168.98	20922.0
2022-02-14 18:30:00	AAPL	Stock	169.0	169.1	168.97	169.0	18601.0
2022-02-14 19:00:00	AAPL	Stock	169.14	169.19	168.76	168.8	16446.0
2022-02-14 19:30:00	AAPL	Stock	168.77	168.87	168.63	168.87	26894.0
2022-02-14 04:00:00	MSFT	Stock	291.2	291.91	290.0	291.1	12520.0
2022-02-14 04:30:00	MSFT	Stock	290.89	291.0	290.32	290.37	5313.0
2022-02-14 05:00:00	MSFT	Stock	290.02	291.5	289.76	291.5	5674.0
2022-02-14 05:30:00	MSFT	Stock	291.0	291.8	291.0	291.7	3392.0
2022-02-14 06:00:00	MSFT	Stock	291.52	291.55	291.11	291.4	12508.0
2022-02-14 06:30:00	MSFT	Stock	291.2	292.19	291.2	292.19	5252.0
2022-02-14 07:00:00	MSFT	Stock	291.85	291.89	290.5	290.72	30085.0
2022-02-14 07:30:00	MSFT	Stock	290.85	294.85	290.7	294.33	45954.0
2022-02-14 08:00:00	MSFT	Stock	290.6001	294.94	290.5001	294.7	58923.0
2022-02-14 08:30:00	MSFT	Stock	294.682	294.7	292.5149	293.15	33250.0
2022-02-14 09:00:00	MSFT	Stock	293.17	294.1	292.7	293.81	52413.0
2022-02-14 09:30:00	MSFT	Stock	293.81	295.88	292.55	294.6	3109097.0
2022-02-14 10:00:00	MSFT	Stock	294.58	294.7199	292.54	293.3	2143326.0
2022-02-14 10:30:00	MSFT	Stock	293.33	295.12	292.04	293.925	1557902.0
2022-02-14 11:00:00	MSFT	Stock	293.93	296.76	293.76	296.285	1297034.0
2022-02-14 11:30:00	MSFT	Stock	296.3	296.72	294.96	295.705	1106166.0
2022-02-14 12:00:00	MSFT	Stock	295.64	296.15	295.2	296.05	786532.0
2022-02-14 12:30:00	MSFT	Stock	296.0	296.52	295.51	295.8066	668666.0

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

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