PREVIEW / stock_30min / 2022-01-14

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-01-14.parquet
  size:    2.2 MB
  rows:    108,685
  symbols: 2,594

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-01-14 04:00:00	AAPL	Stock	172.2	172.8	172.2	172.54	11593.0
2022-01-14 04:30:00	AAPL	Stock	172.84	172.94	172.7	172.7	4033.0
2022-01-14 05:00:00	AAPL	Stock	172.85	172.9	172.3	172.3	10498.0
2022-01-14 05:30:00	AAPL	Stock	172.28	172.59	172.02	172.44	7842.0
2022-01-14 06:00:00	AAPL	Stock	172.41	172.5	172.3	172.34	2019.0
2022-01-14 06:30:00	AAPL	Stock	172.28	172.28	171.88	172.0	5920.0
2022-01-14 07:00:00	AAPL	Stock	172.11	172.3	171.5	171.55	64489.0
2022-01-14 07:30:00	AAPL	Stock	171.54	171.64	170.32	170.4	121200.0
2022-01-14 08:00:00	AAPL	Stock	172.0046	172.31	170.3	170.75	334050.0
2022-01-14 08:30:00	AAPL	Stock	170.7205	171.38	170.46	170.93	185527.0
2022-01-14 09:00:00	AAPL	Stock	170.93	171.48	170.76	171.36	307671.0
2022-01-14 09:30:00	AAPL	Stock	171.34	173.51	171.28	173.3609	8702842.0
2022-01-14 10:00:00	AAPL	Stock	173.37	173.78	172.65	172.695	5156299.0
2022-01-14 10:30:00	AAPL	Stock	172.6982	172.83	171.68	172.3359	5470589.0
2022-01-14 11:00:00	AAPL	Stock	172.34	172.87	171.26	171.71	4691050.0
2022-01-14 11:30:00	AAPL	Stock	171.7	172.94	171.555	172.705	3823080.0
2022-01-14 12:00:00	AAPL	Stock	172.71	172.92	171.83	172.12	2836456.0
2022-01-14 12:30:00	AAPL	Stock	172.107	172.46	171.3039	171.425	2869703.0
2022-01-14 13:00:00	AAPL	Stock	171.425	171.86	171.09	171.39	2762915.0
2022-01-14 13:30:00	AAPL	Stock	171.39	172.24	171.11	172.0811	3205108.0
2022-01-14 14:00:00	AAPL	Stock	172.07	172.52	171.78	171.93	2872524.0
2022-01-14 14:30:00	AAPL	Stock	171.93	172.58	171.89	172.07	2695840.0
2022-01-14 15:00:00	AAPL	Stock	172.06	172.85	171.99	172.495	3533903.0
2022-01-14 15:30:00	AAPL	Stock	172.5	173.28	172.5	173.07	6367515.0
2022-01-14 16:00:00	AAPL	Stock	173.07	173.3	173.02	173.3	8639485.0
2022-01-14 16:30:00	AAPL	Stock	173.3	173.38	173.07	173.33	61611.0
2022-01-14 17:00:00	AAPL	Stock	173.31	173.32	173.07	173.13	17463.0
2022-01-14 17:30:00	AAPL	Stock	173.16	173.2	173.13	173.19	5792.0
2022-01-14 18:00:00	AAPL	Stock	173.2	173.2	173.1	173.12	8600.0
2022-01-14 18:30:00	AAPL	Stock	173.11	173.24	173.11	173.2	10325.0
2022-01-14 19:00:00	AAPL	Stock	173.24	173.29	173.07	173.08	17747.0
2022-01-14 19:30:00	AAPL	Stock	173.06	173.3	173.06	173.3	27481.0
2022-01-14 04:00:00	MSFT	Stock	305.4	306.12	305.2	305.71	7105.0
2022-01-14 04:30:00	MSFT	Stock	305.89	306.33	305.89	306.0	762.0
2022-01-14 05:00:00	MSFT	Stock	306.01	306.01	305.0	305.0	4716.0
2022-01-14 05:30:00	MSFT	Stock	305.02	305.5	304.3	305.5	7142.0
2022-01-14 06:00:00	MSFT	Stock	305.5	305.5	305.13	305.2	1900.0
2022-01-14 06:30:00	MSFT	Stock	305.1	305.15	304.3	304.8	7215.0
2022-01-14 07:00:00	MSFT	Stock	305.0	305.18	303.81	303.9	29615.0
2022-01-14 07:30:00	MSFT	Stock	303.9	304.17	301.93	301.93	40253.0
2022-01-14 08:00:00	MSFT	Stock	304.4006	305.21	301.64	302.4	58586.0
2022-01-14 08:30:00	MSFT	Stock	302.5	302.88	301.7	302.32	46642.0
2022-01-14 09:00:00	MSFT	Stock	302.5	305.0	302.13	304.2	191816.0
2022-01-14 09:30:00	MSFT	Stock	304.24	309.72	303.75	308.9	5600761.0
2022-01-14 10:00:00	MSFT	Stock	308.87	309.16	306.96	307.09	2162769.0
2022-01-14 10:30:00	MSFT	Stock	307.12	308.66	306.66	308.01	2032513.0
2022-01-14 11:00:00	MSFT	Stock	308.0067	308.86	306.16	306.885	1665872.0
2022-01-14 11:30:00	MSFT	Stock	306.87	308.47	306.54	308.31	1324337.0
2022-01-14 12:00:00	MSFT	Stock	308.31	309.17	307.85	308.69	1559480.0
2022-01-14 12:30:00	MSFT	Stock	308.68	309.23	307.58	307.76	1367568.0

> showing 50 of 108,685 rows — these rows as CSV

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