PREVIEW / stock_30min / 2022-07-12

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-12.parquet
  size:    2.0 MB
  rows:    101,007
  symbols: 2,283

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-07-12 04:00:00	AAPL	Stock	143.98	144.07	143.42	143.9	12601.0
2022-07-12 04:30:00	AAPL	Stock	143.92	144.2	143.89	144.06	7607.0
2022-07-12 05:00:00	AAPL	Stock	144.01	144.15	143.96	144.0	6801.0
2022-07-12 05:30:00	AAPL	Stock	143.96	144.1	143.88	144.0	2361.0
2022-07-12 06:00:00	AAPL	Stock	144.03	144.66	144.03	144.29	20782.0
2022-07-12 06:30:00	AAPL	Stock	144.45	144.7	144.36	144.44	49525.0
2022-07-12 07:00:00	AAPL	Stock	144.45	144.96	144.34	144.8	29470.0
2022-07-12 07:30:00	AAPL	Stock	144.87	145.59	144.87	144.95	28803.0
2022-07-12 08:00:00	AAPL	Stock	144.61	145.2399	143.52	145.1693	97563.0
2022-07-12 08:30:00	AAPL	Stock	145.18	145.56	145.09	145.33	134661.0
2022-07-12 09:00:00	AAPL	Stock	145.32	145.9	145.11	145.82	245084.0
2022-07-12 09:30:00	AAPL	Stock	145.84	147.99	145.74	146.17	10530706.0
2022-07-12 10:00:00	AAPL	Stock	146.18	146.9399	145.5601	146.79	6490647.0
2022-07-12 10:30:00	AAPL	Stock	146.8	147.66	146.5	146.985	4761171.0
2022-07-12 11:00:00	AAPL	Stock	146.99	148.13	146.8406	148.0568	4405830.0
2022-07-12 11:30:00	AAPL	Stock	148.06	148.175	147.362	147.8001	2901462.0
2022-07-12 12:00:00	AAPL	Stock	147.8	148.08	147.33	147.75	2834449.0
2022-07-12 12:30:00	AAPL	Stock	147.75	148.45	147.61	148.0432	2905233.0
2022-07-12 13:00:00	AAPL	Stock	148.04	148.34	147.3576	147.555	2786686.0
2022-07-12 13:30:00	AAPL	Stock	147.56	148.18	147.52	148.15	2410486.0
2022-07-12 14:00:00	AAPL	Stock	148.15	148.22	147.45	147.51	2231386.0
2022-07-12 14:30:00	AAPL	Stock	147.515	147.59	146.72	146.77	2778075.0
2022-07-12 15:00:00	AAPL	Stock	146.765	146.77	145.52	145.76	4563269.0
2022-07-12 15:30:00	AAPL	Stock	145.76	146.21	145.05	145.86	9030543.0
2022-07-12 16:00:00	AAPL	Stock	145.88	146.0	145.7	145.79	7712134.0
2022-07-12 16:30:00	AAPL	Stock	145.77	145.9	145.7165	145.85	60082.0
2022-07-12 17:00:00	AAPL	Stock	145.82	145.86	145.71	145.76	19460.0
2022-07-12 17:30:00	AAPL	Stock	145.76	145.8	145.7	145.72	11389.0
2022-07-12 18:00:00	AAPL	Stock	145.75	145.85	145.72	145.75	28053.0
2022-07-12 18:30:00	AAPL	Stock	145.8	145.84	145.77	145.79	11801.0
2022-07-12 19:00:00	AAPL	Stock	145.78	145.81	145.75	145.75	11573.0
2022-07-12 19:30:00	AAPL	Stock	145.75	145.85	145.62	145.8	21589.0
2022-07-12 04:00:00	MSFT	Stock	262.3	262.3	261.9	261.9	1339.0
2022-07-12 04:30:00	MSFT	Stock	262.61	262.83	262.6	262.78	635.0
2022-07-12 05:00:00	MSFT	Stock	262.9	263.3	262.9	263.09	1535.0
2022-07-12 06:00:00	MSFT	Stock	263.24	264.24	263.24	263.8	3349.0
2022-07-12 06:30:00	MSFT	Stock	263.74	264.01	263.21	263.36	722.0
2022-07-12 07:00:00	MSFT	Stock	263.21	264.0	263.13	264.0	4974.0
2022-07-12 07:30:00	MSFT	Stock	263.86	266.03	263.86	264.51	13223.0
2022-07-12 08:00:00	MSFT	Stock	264.7468	265.48	263.14	264.54	10041.0
2022-07-12 08:30:00	MSFT	Stock	264.61	265.35	264.5	265.0	13099.0
2022-07-12 09:00:00	MSFT	Stock	265.0	266.15	265.0	266.0	19062.0
2022-07-12 09:30:00	MSFT	Stock	266.0	266.0	258.75	258.76	2987668.0
2022-07-12 10:00:00	MSFT	Stock	258.75	258.75	255.93	256.23	3140328.0
2022-07-12 10:30:00	MSFT	Stock	256.23	257.81	256.22	257.29	1685701.0
2022-07-12 11:00:00	MSFT	Stock	257.3	258.0	256.775	257.84	1389247.0
2022-07-12 11:30:00	MSFT	Stock	257.85	258.08	256.58	257.02	993380.0
2022-07-12 12:00:00	MSFT	Stock	257.01	257.69	256.81	257.1131	929760.0
2022-07-12 12:30:00	MSFT	Stock	257.116	257.98	256.95	257.7099	770342.0
2022-07-12 13:00:00	MSFT	Stock	257.7	258.28	257.0501	257.17	795965.0

> showing 50 of 101,007 rows — these rows as CSV

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