PREVIEW / stock_30min / 2022-09-07

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-07.parquet
  size:    2.1 MB
  rows:    102,590
  symbols: 2,197

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-07 04:00:00	AAPL	Stock	154.66	155.42	154.6	155.14	22166.0
2022-09-07 04:30:00	AAPL	Stock	155.12	155.35	155.04	155.35	3910.0
2022-09-07 05:00:00	AAPL	Stock	155.34	155.35	155.05	155.18	6084.0
2022-09-07 05:30:00	AAPL	Stock	155.2	155.3	155.15	155.27	3284.0
2022-09-07 06:00:00	AAPL	Stock	155.18	155.2	155.04	155.11	7124.0
2022-09-07 06:30:00	AAPL	Stock	155.11	155.12	154.98	155.09	19461.0
2022-09-07 07:00:00	AAPL	Stock	155.15	155.17	155.0	155.13	19335.0
2022-09-07 07:30:00	AAPL	Stock	155.1	155.1	154.28	154.59	81037.0
2022-09-07 08:00:00	AAPL	Stock	154.9814	155.18	154.144	154.47	201168.0
2022-09-07 08:30:00	AAPL	Stock	154.48	154.72	154.4	154.57	156031.0
2022-09-07 09:00:00	AAPL	Stock	154.54	155.15	154.53	154.81	260859.0
2022-09-07 09:30:00	AAPL	Stock	154.79	155.9162	154.75	155.31	9000466.0
2022-09-07 10:00:00	AAPL	Stock	155.305	155.459	154.12	154.57	6187851.0
2022-09-07 10:30:00	AAPL	Stock	154.58	155.03	153.61	154.12	5865474.0
2022-09-07 11:00:00	AAPL	Stock	154.12	155.26	153.9	154.895	3787405.0
2022-09-07 11:30:00	AAPL	Stock	154.895	155.12	154.41	154.75	3076712.0
2022-09-07 12:00:00	AAPL	Stock	154.755	154.92	154.235	154.5	2822395.0
2022-09-07 12:30:00	AAPL	Stock	154.49	155.33	154.33	154.86	3254441.0
2022-09-07 13:00:00	AAPL	Stock	154.855	155.2	154.55	154.6131	4102299.0
2022-09-07 13:30:00	AAPL	Stock	154.62	155.71	154.61	155.55	5015785.0
2022-09-07 14:00:00	AAPL	Stock	155.55	156.22	155.165	155.6393	5976335.0
2022-09-07 14:30:00	AAPL	Stock	155.64	155.87	154.75	155.745	7249959.0
2022-09-07 15:00:00	AAPL	Stock	155.74	156.67	155.66	156.6074	5632627.0
2022-09-07 15:30:00	AAPL	Stock	156.6	156.63	155.81	155.92	6694122.0
2022-09-07 16:00:00	AAPL	Stock	155.91	156.02	155.69	155.86	7767456.0
2022-09-07 16:30:00	AAPL	Stock	155.89	155.96	155.8	155.82	105977.0
2022-09-07 17:00:00	AAPL	Stock	155.83	155.96	155.82	155.95	53935.0
2022-09-07 17:30:00	AAPL	Stock	155.95	156.05	155.9	156.01	24731.0
2022-09-07 18:00:00	AAPL	Stock	156.07	156.11	156.01	156.02	18401.0
2022-09-07 18:30:00	AAPL	Stock	156.02	156.02	155.93	156.02	20175.0
2022-09-07 19:00:00	AAPL	Stock	155.98	156.04	155.96	155.96	21561.0
2022-09-07 19:30:00	AAPL	Stock	155.95	156.04	155.88	156.04	14422.0
2022-09-07 04:00:00	MSFT	Stock	253.89	254.02	253.4	253.4	5585.0
2022-09-07 04:30:00	MSFT	Stock	253.5	253.77	253.31	253.77	1305.0
2022-09-07 05:00:00	MSFT	Stock	253.5	253.7	253.5	253.7	868.0
2022-09-07 05:30:00	MSFT	Stock	253.67	253.67	253.67	253.67	105.0
2022-09-07 06:00:00	MSFT	Stock	253.45	253.58	253.25	253.58	620.0
2022-09-07 06:30:00	MSFT	Stock	253.5	253.7	253.5	253.7	2562.0
2022-09-07 07:00:00	MSFT	Stock	253.65	253.7	253.44	253.7	2541.0
2022-09-07 07:30:00	MSFT	Stock	253.6	253.84	252.71	253.75	20980.0
2022-09-07 08:00:00	MSFT	Stock	253.65	254.13	252.617	253.5172	53125.0
2022-09-07 08:30:00	MSFT	Stock	253.7	254.69	253.7	254.29	13700.0
2022-09-07 09:00:00	MSFT	Stock	254.4191	255.1	254.03	254.7	28293.0
2022-09-07 09:30:00	MSFT	Stock	254.7	255.89	254.14	255.07	2006162.0
2022-09-07 10:00:00	MSFT	Stock	255.04	255.094	253.22	254.28	1118228.0
2022-09-07 10:30:00	MSFT	Stock	254.3	255.28	253.47	254.18	956994.0
2022-09-07 11:00:00	MSFT	Stock	254.19	255.75	253.87	255.14	730600.0
2022-09-07 11:30:00	MSFT	Stock	255.14	255.54	254.77	255.26	478454.0
2022-09-07 12:00:00	MSFT	Stock	255.27	255.695	254.64	255.1	518642.0
2022-09-07 12:30:00	MSFT	Stock	255.08	256.45	254.72	256.11	614375.0

> showing 50 of 102,590 rows — these rows as CSV

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