PREVIEW / stock_30min / 2022-02-18

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-02-18.parquet
  size:    2.2 MB
  rows:    107,050
  symbols: 2,520

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-18 04:00:00	AAPL	Stock	169.84	169.91	169.58	169.75	3790.0
2022-02-18 04:30:00	AAPL	Stock	169.75	169.78	169.6	169.78	4565.0
2022-02-18 05:00:00	AAPL	Stock	169.8	169.8	169.6	169.8	6313.0
2022-02-18 05:30:00	AAPL	Stock	169.75	170.05	169.75	169.89	6498.0
2022-02-18 06:00:00	AAPL	Stock	169.99	170.07	169.99	170.02	699.0
2022-02-18 06:30:00	AAPL	Stock	170.05	170.1	169.61	169.8	15190.0
2022-02-18 07:00:00	AAPL	Stock	169.8	170.06	169.76	170.0	33472.0
2022-02-18 07:30:00	AAPL	Stock	170.02	170.07	169.89	169.9	12238.0
2022-02-18 08:00:00	AAPL	Stock	169.9899	170.99	168.96	168.97	173100.0
2022-02-18 08:30:00	AAPL	Stock	168.97	169.51	168.67	169.49	101571.0
2022-02-18 09:00:00	AAPL	Stock	169.36	170.26	169.13	169.84	614257.0
2022-02-18 09:30:00	AAPL	Stock	169.84	170.5413	167.97	169.01	9828654.0
2022-02-18 10:00:00	AAPL	Stock	169.02	169.1154	168.28	168.5	3691707.0
2022-02-18 10:30:00	AAPL	Stock	168.495	168.495	167.67	168.06	4230535.0
2022-02-18 11:00:00	AAPL	Stock	168.04	168.2198	167.29	168.105	4193160.0
2022-02-18 11:30:00	AAPL	Stock	168.11	168.36	167.21	167.3	2837271.0
2022-02-18 12:00:00	AAPL	Stock	167.29	168.0711	167.22	167.6955	2952906.0
2022-02-18 12:30:00	AAPL	Stock	167.69	167.81	166.63	166.67	3867084.0
2022-02-18 13:00:00	AAPL	Stock	166.67	166.78	166.19	166.35	2896578.0
2022-02-18 13:30:00	AAPL	Stock	166.34	167.3	166.2995	167.07	3020495.0
2022-02-18 14:00:00	AAPL	Stock	167.06	168.11	167.03	168.04	2941054.0
2022-02-18 14:30:00	AAPL	Stock	168.035	168.66	167.71	168.2901	4070092.0
2022-02-18 15:00:00	AAPL	Stock	168.29	168.6556	167.28	167.375	4077947.0
2022-02-18 15:30:00	AAPL	Stock	167.365	167.91	166.76	167.6	7832795.0
2022-02-18 16:00:00	AAPL	Stock	167.42	167.56	167.13	167.52	9057749.0
2022-02-18 16:30:00	AAPL	Stock	167.5	167.53	167.3	167.39	358690.0
2022-02-18 17:00:00	AAPL	Stock	167.41	167.42	167.03	167.05	64530.0
2022-02-18 17:30:00	AAPL	Stock	167.04	167.04	166.8	166.8	31888.0
2022-02-18 18:00:00	AAPL	Stock	166.81	166.88	166.42	166.42	20697.0
2022-02-18 18:30:00	AAPL	Stock	166.41	166.5	166.32	166.47	18778.0
2022-02-18 19:00:00	AAPL	Stock	166.49	166.53	166.38	166.44	15269.0
2022-02-18 19:30:00	AAPL	Stock	166.39	166.5	166.3	166.5	14937.0
2022-02-18 04:00:00	MSFT	Stock	291.92	292.27	291.51	291.91	2635.0
2022-02-18 04:30:00	MSFT	Stock	291.92	292.11	291.91	292.1	1777.0
2022-02-18 05:00:00	MSFT	Stock	292.5	292.99	292.5	292.99	450.0
2022-02-18 05:30:00	MSFT	Stock	292.9	293.0	292.8	292.8	2996.0
2022-02-18 06:00:00	MSFT	Stock	292.8	293.01	292.77	293.01	4968.0
2022-02-18 06:30:00	MSFT	Stock	292.8	292.9	292.57	292.6	943.0
2022-02-18 07:00:00	MSFT	Stock	292.62	292.73	292.35	292.54	8009.0
2022-02-18 07:30:00	MSFT	Stock	292.7	293.0	292.7	293.0	9573.0
2022-02-18 08:00:00	MSFT	Stock	292.85	293.1	291.0	291.3	60007.0
2022-02-18 08:30:00	MSFT	Stock	291.3	291.98	290.86	291.9	33407.0
2022-02-18 09:00:00	MSFT	Stock	291.6096	293.34	291.18	293.21	206022.0
2022-02-18 09:30:00	MSFT	Stock	293.21	293.86	289.9325	291.29	3464202.0
2022-02-18 10:00:00	MSFT	Stock	291.32	291.505	289.62	289.96	1213043.0
2022-02-18 10:30:00	MSFT	Stock	289.89	289.89	288.27	289.53	1350588.0
2022-02-18 11:00:00	MSFT	Stock	289.51	290.05	288.45	289.84	1295884.0
2022-02-18 11:30:00	MSFT	Stock	289.8201	290.68	289.03	289.33	1116565.0
2022-02-18 12:00:00	MSFT	Stock	289.32	290.31	289.07	289.225	1080421.0
2022-02-18 12:30:00	MSFT	Stock	289.215	289.62	287.44	287.4701	1217125.0

> showing 50 of 107,050 rows — these rows as CSV

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