PREVIEW / stock_30min / 2022-05-03

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-05-03.parquet
  size:    2.1 MB
  rows:    105,574
  symbols: 2,433

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-05-03 04:00:00	AAPL	Stock	158.1	158.71	158.1	158.45	19910.0
2022-05-03 04:30:00	AAPL	Stock	158.25	158.25	157.91	158.01	8255.0
2022-05-03 05:00:00	AAPL	Stock	158.1	158.1	157.8	157.96	7069.0
2022-05-03 05:30:00	AAPL	Stock	157.98	158.32	157.95	158.19	4899.0
2022-05-03 06:00:00	AAPL	Stock	158.19	158.21	157.5	157.61	9651.0
2022-05-03 06:30:00	AAPL	Stock	157.64	157.65	157.01	157.48	14194.0
2022-05-03 07:00:00	AAPL	Stock	157.44	158.02	157.35	157.9	28996.0
2022-05-03 07:30:00	AAPL	Stock	157.83	158.1	157.26	158.1	24122.0
2022-05-03 08:00:00	AAPL	Stock	157.4	158.9	157.31	158.23	289697.0
2022-05-03 08:30:00	AAPL	Stock	158.23	158.88	158.04	158.66	307405.0
2022-05-03 09:00:00	AAPL	Stock	158.6598	158.75	158.0	158.05	141926.0
2022-05-03 09:30:00	AAPL	Stock	158.14	158.2	156.32	158.11	9232821.0
2022-05-03 10:00:00	AAPL	Stock	158.15	158.64	157.1	157.85	6184222.0
2022-05-03 10:30:00	AAPL	Stock	157.86	158.411	157.01	157.585	4629282.0
2022-05-03 11:00:00	AAPL	Stock	157.58	159.49	157.3028	159.348	6301706.0
2022-05-03 11:30:00	AAPL	Stock	159.3499	159.85	158.59	159.3441	5412316.0
2022-05-03 12:00:00	AAPL	Stock	159.34	159.88	158.58	159.14	4763828.0
2022-05-03 12:30:00	AAPL	Stock	159.13	159.62	158.73	159.34	3184121.0
2022-05-03 13:00:00	AAPL	Stock	159.35	160.32	159.11	159.9	4380324.0
2022-05-03 13:30:00	AAPL	Stock	159.9	160.71	159.75	159.92	3445990.0
2022-05-03 14:00:00	AAPL	Stock	159.93	159.9762	158.87	158.95	3871274.0
2022-05-03 14:30:00	AAPL	Stock	158.9401	159.74	158.22	159.6412	5313459.0
2022-05-03 15:00:00	AAPL	Stock	159.6399	159.92	158.89	159.308	4426479.0
2022-05-03 15:30:00	AAPL	Stock	159.29	159.66	158.54	159.48	7839173.0
2022-05-03 16:00:00	AAPL	Stock	159.48	160.17	159.28	159.41	4983319.0
2022-05-03 16:30:00	AAPL	Stock	159.41	159.6	159.33	159.57	88963.0
2022-05-03 17:00:00	AAPL	Stock	159.5	159.75	159.47	159.63	30055.0
2022-05-03 17:30:00	AAPL	Stock	159.6301	159.7754	159.6301	159.7	31955.0
2022-05-03 18:00:00	AAPL	Stock	159.7	159.94	159.6	159.62	13811.0
2022-05-03 18:30:00	AAPL	Stock	159.75	159.75	159.6	159.6001	6720.0
2022-05-03 19:00:00	AAPL	Stock	159.59	159.65	159.5	159.58	7214.0
2022-05-03 19:30:00	AAPL	Stock	159.58	159.7	159.45	159.68	20874.0
2022-05-03 04:00:00	MSFT	Stock	284.49	286.12	284.49	285.32	4463.0
2022-05-03 04:30:00	MSFT	Stock	285.02	285.02	284.25	284.5	2649.0
2022-05-03 05:00:00	MSFT	Stock	284.0	284.44	284.0	284.44	473.0
2022-05-03 05:30:00	MSFT	Stock	284.47	285.02	284.47	285.02	2980.0
2022-05-03 06:00:00	MSFT	Stock	285.05	285.05	284.0	284.0	372.0
2022-05-03 06:30:00	MSFT	Stock	283.56	283.81	283.4	283.4	815.0
2022-05-03 07:00:00	MSFT	Stock	283.7	283.7	283.28	283.44	3727.0
2022-05-03 07:30:00	MSFT	Stock	283.95	284.4	283.8	284.4	5069.0
2022-05-03 08:00:00	MSFT	Stock	283.43	285.0	283.0018	284.4	16141.0
2022-05-03 08:30:00	MSFT	Stock	284.61	285.0	284.31	284.64	7793.0
2022-05-03 09:00:00	MSFT	Stock	284.873	284.91	283.8	284.1	12571.0
2022-05-03 09:30:00	MSFT	Stock	283.96	283.97	281.29	283.345	2125673.0
2022-05-03 10:00:00	MSFT	Stock	283.34	284.13	280.85	281.74	1289593.0
2022-05-03 10:30:00	MSFT	Stock	281.76	282.86	280.26	281.27	1081994.0
2022-05-03 11:00:00	MSFT	Stock	281.25	283.6	280.75	282.5	1032450.0
2022-05-03 11:30:00	MSFT	Stock	282.55	283.22	281.61	282.5	719343.0
2022-05-03 12:00:00	MSFT	Stock	282.48	283.73	280.84	281.91	1010016.0
2022-05-03 12:30:00	MSFT	Stock	281.87	282.28	281.19	281.81	641334.0

> showing 50 of 105,574 rows — these rows as CSV

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