PREVIEW / stock_30min / 2022-03-09

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-03-09.parquet
  size:    2.2 MB
  rows:    110,614
  symbols: 2,529

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-03-09 04:00:00	AAPL	Stock	157.94	160.32	157.94	160.22	24627.0
2022-03-09 04:30:00	AAPL	Stock	160.15	161.02	160.15	160.93	21111.0
2022-03-09 05:00:00	AAPL	Stock	160.99	161.4	160.85	161.37	29674.0
2022-03-09 05:30:00	AAPL	Stock	161.2	161.5	160.52	160.52	19777.0
2022-03-09 06:00:00	AAPL	Stock	160.99	161.25	160.57	161.05	6171.0
2022-03-09 06:30:00	AAPL	Stock	160.96	161.21	160.58	160.72	28796.0
2022-03-09 07:00:00	AAPL	Stock	160.64	160.8	160.2	160.49	70713.0
2022-03-09 07:30:00	AAPL	Stock	160.5	160.87	160.38	160.73	82860.0
2022-03-09 08:00:00	AAPL	Stock	157.44	161.12	157.44	161.0	472831.0
2022-03-09 08:30:00	AAPL	Stock	161.01	161.39	160.9	160.98	247765.0
2022-03-09 09:00:00	AAPL	Stock	160.97	161.99	160.7	161.52	431360.0
2022-03-09 09:30:00	AAPL	Stock	161.475	161.64	159.41	160.4073	10998141.0
2022-03-09 10:00:00	AAPL	Stock	160.41	161.61	160.151	161.33	6845223.0
2022-03-09 10:30:00	AAPL	Stock	161.34	162.26	161.03	162.0599	5183057.0
2022-03-09 11:00:00	AAPL	Stock	162.0499	162.16	161.0238	161.11	3924509.0
2022-03-09 11:30:00	AAPL	Stock	161.12	162.0499	161.08	162.005	3532325.0
2022-03-09 12:00:00	AAPL	Stock	162.01	162.23	161.57	162.01	3379938.0
2022-03-09 12:30:00	AAPL	Stock	162.015	162.69	162.01	162.655	3195441.0
2022-03-09 13:00:00	AAPL	Stock	162.67	162.6801	161.88	162.2799	3279730.0
2022-03-09 13:30:00	AAPL	Stock	162.2844	162.3	161.56	161.98	2865292.0
2022-03-09 14:00:00	AAPL	Stock	161.981	162.415	161.79	162.34	3082875.0
2022-03-09 14:30:00	AAPL	Stock	162.3444	163.0	162.315	162.56	4232361.0
2022-03-09 15:00:00	AAPL	Stock	162.58	163.29	162.54	163.195	4660551.0
2022-03-09 15:30:00	AAPL	Stock	163.195	163.41	162.28	162.98	9379041.0
2022-03-09 16:00:00	AAPL	Stock	162.77	163.2	162.73	162.96	9706157.0
2022-03-09 16:30:00	AAPL	Stock	163.0	163.11	162.56	162.66	255168.0
2022-03-09 17:00:00	AAPL	Stock	162.71	162.71	162.42	162.49	58170.0
2022-03-09 17:30:00	AAPL	Stock	162.5	162.55	162.35	162.5	30859.0
2022-03-09 18:00:00	AAPL	Stock	162.5	162.5	161.78	161.94	65308.0
2022-03-09 18:30:00	AAPL	Stock	161.94	162.08	161.8	161.97	30284.0
2022-03-09 19:00:00	AAPL	Stock	161.99	162.19	161.9	162.12	17758.0
2022-03-09 19:30:00	AAPL	Stock	162.05	162.27	162.05	162.25	16019.0
2022-03-09 04:00:00	MSFT	Stock	279.59	281.0	279.43	281.0	1506.0
2022-03-09 04:30:00	MSFT	Stock	281.0	281.3	280.89	281.3	6873.0
2022-03-09 05:00:00	MSFT	Stock	281.06	282.47	281.06	282.0	5634.0
2022-03-09 05:30:00	MSFT	Stock	282.29	282.7	282.0	282.31	32114.0
2022-03-09 06:00:00	MSFT	Stock	282.23	283.1	282.07	283.1	10246.0
2022-03-09 06:30:00	MSFT	Stock	282.61	282.63	282.01	282.01	2628.0
2022-03-09 07:00:00	MSFT	Stock	281.75	282.89	281.29	282.77	12801.0
2022-03-09 07:30:00	MSFT	Stock	282.9	283.68	282.6	283.68	15645.0
2022-03-09 08:00:00	MSFT	Stock	275.85	283.88	275.85	283.5	32322.0
2022-03-09 08:30:00	MSFT	Stock	283.48	283.98	283.26	283.35	30128.0
2022-03-09 09:00:00	MSFT	Stock	283.45	283.86	282.1	283.47	87354.0
2022-03-09 09:30:00	MSFT	Stock	283.44	284.88	280.78	283.67	3428598.0
2022-03-09 10:00:00	MSFT	Stock	283.7585	285.17	282.83	284.8	1873987.0
2022-03-09 10:30:00	MSFT	Stock	284.84	286.96	284.71	286.5136	1756207.0
2022-03-09 11:00:00	MSFT	Stock	286.52	286.605	284.62	284.67	1205804.0
2022-03-09 11:30:00	MSFT	Stock	284.77	285.71	284.49	285.0191	1119002.0
2022-03-09 12:00:00	MSFT	Stock	285.015	286.33	284.7486	285.93	1111605.0
2022-03-09 12:30:00	MSFT	Stock	285.97	287.58	285.82	286.8428	1087545.0

> showing 50 of 110,614 rows — these rows as CSV

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