PREVIEW / stock_30min / 2022-04-13

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-13.parquet
  size:    2.2 MB
  rows:    106,248
  symbols: 2,500

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-13 04:00:00	AAPL	Stock	168.7	169.22	168.52	168.93	22202.0
2022-04-13 04:30:00	AAPL	Stock	168.97	169.2	168.97	169.2	5537.0
2022-04-13 05:00:00	AAPL	Stock	169.14	169.21	168.97	168.97	6225.0
2022-04-13 05:30:00	AAPL	Stock	169.05	169.05	168.38	168.38	6814.0
2022-04-13 06:00:00	AAPL	Stock	168.4	168.47	168.2	168.26	11751.0
2022-04-13 06:30:00	AAPL	Stock	168.44	168.94	168.44	168.75	9685.0
2022-04-13 07:00:00	AAPL	Stock	168.78	169.17	168.75	169.05	37767.0
2022-04-13 07:30:00	AAPL	Stock	169.04	169.06	168.03	168.12	56160.0
2022-04-13 08:00:00	AAPL	Stock	169.0	169.79	167.61	167.79	286740.0
2022-04-13 08:30:00	AAPL	Stock	167.75	168.13	167.45	167.49	183448.0
2022-04-13 09:00:00	AAPL	Stock	167.49	167.92	167.03	167.35	214358.0
2022-04-13 09:30:00	AAPL	Stock	167.39	168.5	166.77	167.87	7788578.0
2022-04-13 10:00:00	AAPL	Stock	167.88	168.9	167.62	168.69	4833512.0
2022-04-13 10:30:00	AAPL	Stock	168.7	169.04	168.285	168.61	3755828.0
2022-04-13 11:00:00	AAPL	Stock	168.61	170.0	168.61	169.69	4149990.0
2022-04-13 11:30:00	AAPL	Stock	169.7	170.215	169.64	169.8052	3781722.0
2022-04-13 12:00:00	AAPL	Stock	169.8	171.0	169.6001	170.4401	4188213.0
2022-04-13 12:30:00	AAPL	Stock	170.45	171.0	170.28	170.665	3108431.0
2022-04-13 13:00:00	AAPL	Stock	170.67	170.99	170.4601	170.56	2992491.0
2022-04-13 13:30:00	AAPL	Stock	170.57	170.5936	169.95	170.29	2493986.0
2022-04-13 14:00:00	AAPL	Stock	170.295	170.48	170.065	170.28	2628468.0
2022-04-13 14:30:00	AAPL	Stock	170.28	170.5525	170.15	170.51	2399998.0
2022-04-13 15:00:00	AAPL	Stock	170.5175	170.83	170.115	170.8	3541226.0
2022-04-13 15:30:00	AAPL	Stock	170.8042	171.04	170.28	170.4	7252074.0
2022-04-13 16:00:00	AAPL	Stock	170.36	170.41	170.13	170.3	5641072.0
2022-04-13 16:30:00	AAPL	Stock	170.33	170.4	170.16	170.16	54391.0
2022-04-13 17:00:00	AAPL	Stock	170.1801	170.4	170.1	170.14	104942.0
2022-04-13 17:30:00	AAPL	Stock	170.19	170.28	170.19	170.22	10100.0
2022-04-13 18:00:00	AAPL	Stock	170.25	170.25	170.15	170.16	9031.0
2022-04-13 18:30:00	AAPL	Stock	170.1799	170.35	170.16	170.35	13107.0
2022-04-13 19:00:00	AAPL	Stock	170.35	170.39	170.3	170.39	11783.0
2022-04-13 19:30:00	AAPL	Stock	170.3	170.4	170.15	170.4	26210.0
2022-04-13 04:00:00	MSFT	Stock	285.0	285.0	284.2	284.2	3237.0
2022-04-13 04:30:00	MSFT	Stock	284.4	284.5	284.3	284.3	1097.0
2022-04-13 05:30:00	MSFT	Stock	283.83	283.83	283.03	283.08	2796.0
2022-04-13 06:00:00	MSFT	Stock	283.0	283.49	282.87	283.49	1508.0
2022-04-13 06:30:00	MSFT	Stock	283.47	284.71	283.47	284.71	1997.0
2022-04-13 07:00:00	MSFT	Stock	284.63	284.95	284.02	284.02	6418.0
2022-04-13 07:30:00	MSFT	Stock	284.45	284.45	283.01	283.01	20845.0
2022-04-13 08:00:00	MSFT	Stock	284.7	284.8799	282.3106	282.84	36982.0
2022-04-13 08:30:00	MSFT	Stock	282.8	283.77	282.4	282.75	18699.0
2022-04-13 09:00:00	MSFT	Stock	282.75	283.24	282.3	282.52	10563.0
2022-04-13 09:30:00	MSFT	Stock	282.73	283.86	281.3	282.76	2286974.0
2022-04-13 10:00:00	MSFT	Stock	282.78	284.63	282.3586	284.07	1134364.0
2022-04-13 10:30:00	MSFT	Stock	284.1	285.26	283.51	283.6	924821.0
2022-04-13 11:00:00	MSFT	Stock	283.64	285.9032	283.615	285.56	1039870.0
2022-04-13 11:30:00	MSFT	Stock	285.57	286.1	285.1	285.67	741916.0
2022-04-13 12:00:00	MSFT	Stock	285.66	286.42	285.23	286.0699	755780.0
2022-04-13 12:30:00	MSFT	Stock	286.09	286.62	285.83	286.085	671933.0
2022-04-13 13:00:00	MSFT	Stock	286.1	286.86	285.97	286.54	629942.0

> showing 50 of 106,248 rows — these rows as CSV

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