PREVIEW / stock_30min / 2022-02-22

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-02-22.parquet
  size:    2.2 MB
  rows:    111,631
  symbols: 2,546

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-22 04:00:00	AAPL	Stock	166.0	166.0	162.24	163.8	80011.0
2022-02-22 04:30:00	AAPL	Stock	163.9	164.15	163.72	163.84	30158.0
2022-02-22 05:00:00	AAPL	Stock	163.84	165.29	163.71	165.29	30388.0
2022-02-22 05:30:00	AAPL	Stock	165.09	166.6	165.0	165.99	33925.0
2022-02-22 06:00:00	AAPL	Stock	166.0	166.15	165.71	165.85	6669.0
2022-02-22 06:30:00	AAPL	Stock	165.85	166.12	165.5	165.9	8397.0
2022-02-22 07:00:00	AAPL	Stock	165.92	166.48	165.3	166.26	113729.0
2022-02-22 07:30:00	AAPL	Stock	166.27	166.48	165.75	166.18	73817.0
2022-02-22 08:00:00	AAPL	Stock	165.5109	167.718	160.0	165.6226	175313.0
2022-02-22 08:30:00	AAPL	Stock	165.7	166.21	165.7	165.9	132913.0
2022-02-22 09:00:00	AAPL	Stock	165.9023	166.137	164.52	164.99	462656.0
2022-02-22 09:30:00	AAPL	Stock	164.98	166.5	163.85	165.71	12123115.0
2022-02-22 10:00:00	AAPL	Stock	165.72	166.69	165.05	166.63	5367402.0
2022-02-22 10:30:00	AAPL	Stock	166.63	166.68	164.5703	164.66	4483416.0
2022-02-22 11:00:00	AAPL	Stock	164.67	165.0	164.41	164.55	4081848.0
2022-02-22 11:30:00	AAPL	Stock	164.541	165.32	164.43	164.695	3639005.0
2022-02-22 12:00:00	AAPL	Stock	164.68	165.045	164.33	164.405	2883669.0
2022-02-22 12:30:00	AAPL	Stock	164.4	164.59	163.9	164.1	3061009.0
2022-02-22 13:00:00	AAPL	Stock	164.12	164.365	163.562	163.9	2770948.0
2022-02-22 13:30:00	AAPL	Stock	163.89	164.06	162.73	162.935	3666244.0
2022-02-22 14:00:00	AAPL	Stock	162.93	163.42	162.15	163.35	5735682.0
2022-02-22 14:30:00	AAPL	Stock	163.325	164.47	162.7847	164.2	5496993.0
2022-02-22 15:00:00	AAPL	Stock	164.21	165.3586	164.205	165.115	4917762.0
2022-02-22 15:30:00	AAPL	Stock	165.12	165.21	163.45	164.3	7796074.0
2022-02-22 16:00:00	AAPL	Stock	164.32	165.47	164.32	164.85	8040733.0
2022-02-22 16:30:00	AAPL	Stock	164.84	165.15	164.32	164.6	89703.0
2022-02-22 17:00:00	AAPL	Stock	164.65	164.8	164.57	164.66	10255.0
2022-02-22 17:30:00	AAPL	Stock	164.7	165.04	164.66	165.02	31604.0
2022-02-22 18:00:00	AAPL	Stock	164.98	165.3	164.82	165.26	30596.0
2022-02-22 18:30:00	AAPL	Stock	165.22	165.47	165.16	165.26	19502.0
2022-02-22 19:00:00	AAPL	Stock	165.43	165.47	165.13	165.2	18839.0
2022-02-22 19:30:00	AAPL	Stock	165.15	165.45	165.13	165.45	19730.0
2022-02-22 04:00:00	MSFT	Stock	281.97	285.0	281.2	281.5	25812.0
2022-02-22 04:30:00	MSFT	Stock	281.6	282.0	280.78	281.15	32003.0
2022-02-22 05:00:00	MSFT	Stock	280.82	283.65	280.82	283.5	13059.0
2022-02-22 05:30:00	MSFT	Stock	283.6	286.45	283.16	285.2	10808.0
2022-02-22 06:00:00	MSFT	Stock	285.09	285.5	284.5	285.48	5517.0
2022-02-22 06:30:00	MSFT	Stock	285.05	285.23	284.52	285.19	8958.0
2022-02-22 07:00:00	MSFT	Stock	285.04	286.19	284.1	285.7	32719.0
2022-02-22 07:30:00	MSFT	Stock	285.7	286.2	285.02	285.55	26477.0
2022-02-22 08:00:00	MSFT	Stock	284.65	286.2	279.0	284.95	49021.0
2022-02-22 08:30:00	MSFT	Stock	284.827	286.16	284.827	286.0	33211.0
2022-02-22 09:00:00	MSFT	Stock	285.89	286.12	284.1	284.7	45902.0
2022-02-22 09:30:00	MSFT	Stock	285.13	291.54	284.5	289.41	3683533.0
2022-02-22 10:00:00	MSFT	Stock	289.35	290.53	288.95	290.47	1779854.0
2022-02-22 10:30:00	MSFT	Stock	290.51	290.54	288.09	288.28	1420581.0
2022-02-22 11:00:00	MSFT	Stock	288.27	288.52	287.01	287.65	1167580.0
2022-02-22 11:30:00	MSFT	Stock	287.67	288.0	286.2	286.855	979404.0
2022-02-22 12:00:00	MSFT	Stock	286.815	287.5001	286.54	286.74	848649.0
2022-02-22 12:30:00	MSFT	Stock	286.73	287.14	286.45	286.6725	787418.0

> showing 50 of 111,631 rows — these rows as CSV

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