PREVIEW / stock_30min / 2022-09-09

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-09.parquet
  size:    2.1 MB
  rows:    103,529
  symbols: 2,203

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-09-09 04:00:00	AAPL	Stock	155.3	155.77	155.3	155.66	41701.0
2022-09-09 04:30:00	AAPL	Stock	155.69	155.88	155.42	155.86	21312.0
2022-09-09 05:00:00	AAPL	Stock	155.83	155.92	155.68	155.83	9749.0
2022-09-09 05:30:00	AAPL	Stock	155.84	156.0	155.7	155.8	3001.0
2022-09-09 06:00:00	AAPL	Stock	155.75	155.99	155.75	155.99	18268.0
2022-09-09 06:30:00	AAPL	Stock	155.99	156.37	155.97	156.09	40113.0
2022-09-09 07:00:00	AAPL	Stock	156.1	156.1	155.68	155.7	89456.0
2022-09-09 07:30:00	AAPL	Stock	155.7	155.76	155.53	155.63	33518.0
2022-09-09 08:00:00	AAPL	Stock	155.98	156.035	155.32	155.64	165392.0
2022-09-09 08:30:00	AAPL	Stock	155.62	155.92	154.46	155.62	213000.0
2022-09-09 09:00:00	AAPL	Stock	155.62	155.79	155.27	155.48	176685.0
2022-09-09 09:30:00	AAPL	Stock	155.48	156.08	154.75	156.08	8571472.0
2022-09-09 10:00:00	AAPL	Stock	156.07	156.61	155.91	156.44	5590723.0
2022-09-09 10:30:00	AAPL	Stock	156.4428	156.84	156.22	156.645	4126999.0
2022-09-09 11:00:00	AAPL	Stock	156.65	156.965	156.465	156.96	3216774.0
2022-09-09 11:30:00	AAPL	Stock	156.95	157.18	156.69	156.85	3028287.0
2022-09-09 12:00:00	AAPL	Stock	156.86	156.9397	156.09	156.2799	3009641.0
2022-09-09 12:30:00	AAPL	Stock	156.28	156.87	156.145	156.855	2340069.0
2022-09-09 13:00:00	AAPL	Stock	156.855	157.1676	156.7	157.06	2386191.0
2022-09-09 13:30:00	AAPL	Stock	157.0592	157.34	156.92	157.08	2193603.0
2022-09-09 14:00:00	AAPL	Stock	157.075	157.51	156.77	157.505	2658939.0
2022-09-09 14:30:00	AAPL	Stock	157.5099	157.52	156.902	157.16	2446349.0
2022-09-09 15:00:00	AAPL	Stock	157.16	157.55	157.0508	157.425	3051835.0
2022-09-09 15:30:00	AAPL	Stock	157.43	157.82	157.32	157.35	7129428.0
2022-09-09 16:00:00	AAPL	Stock	157.34	157.54	157.2803	157.54	7091586.0
2022-09-09 16:30:00	AAPL	Stock	157.53	157.55	157.37	157.5	101831.0
2022-09-09 17:00:00	AAPL	Stock	157.49	157.55	157.46	157.49	30572.0
2022-09-09 17:30:00	AAPL	Stock	157.5	157.55	157.44	157.48	19269.0
2022-09-09 18:00:00	AAPL	Stock	157.47	157.47	157.45	157.45	6758.0
2022-09-09 18:30:00	AAPL	Stock	157.44	157.48	157.44	157.44	7935.0
2022-09-09 19:00:00	AAPL	Stock	157.44	157.46	157.42	157.46	9665.0
2022-09-09 19:30:00	AAPL	Stock	157.46	157.54	157.42	157.5	16723.0
2022-09-09 04:00:00	MSFT	Stock	260.96	261.87	260.41	261.87	6228.0
2022-09-09 04:30:00	MSFT	Stock	261.73	261.73	261.02	261.43	1919.0
2022-09-09 05:30:00	MSFT	Stock	261.55	261.93	261.01	261.35	2742.0
2022-09-09 06:00:00	MSFT	Stock	261.16	261.16	261.16	261.16	100.0
2022-09-09 06:30:00	MSFT	Stock	261.65	261.81	261.44	261.8	2560.0
2022-09-09 07:00:00	MSFT	Stock	261.75	261.8	260.95	261.0	10984.0
2022-09-09 07:30:00	MSFT	Stock	261.03	261.4	260.88	261.04	4540.0
2022-09-09 08:00:00	MSFT	Stock	261.65	261.75	257.874	261.33	18632.0
2022-09-09 08:30:00	MSFT	Stock	261.21	261.6	261.08	261.28	16286.0
2022-09-09 09:00:00	MSFT	Stock	261.11	261.15	260.08	260.32	27751.0
2022-09-09 09:30:00	MSFT	Stock	260.32	262.95	260.29	262.4	1830327.0
2022-09-09 10:00:00	MSFT	Stock	262.41	263.84	262.23	263.84	1147460.0
2022-09-09 10:30:00	MSFT	Stock	263.84	265.17	263.77	264.83	1359100.0
2022-09-09 11:00:00	MSFT	Stock	264.83	265.06	263.27	264.24	959848.0
2022-09-09 11:30:00	MSFT	Stock	264.21	264.525	263.43	263.81	621538.0
2022-09-09 12:00:00	MSFT	Stock	263.8	263.9073	262.73	262.9776	637060.0
2022-09-09 12:30:00	MSFT	Stock	262.98	264.035	262.78	263.98	675675.0
2022-09-09 13:00:00	MSFT	Stock	264.0186	264.45	263.54	264.216	669848.0

> showing 50 of 103,529 rows — these rows as CSV

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