PREVIEW / stock_30min / 2021-07-26

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-26.parquet
  size:    2.2 MB
  rows:    110,690
  symbols: 2,845

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
2021-07-26 04:00:00	AAPL	Stock	148.35	148.35	147.4	147.46	46071.0
2021-07-26 04:30:00	AAPL	Stock	147.46	147.7	147.46	147.6	19726.0
2021-07-26 05:00:00	AAPL	Stock	147.56	147.99	147.56	147.9	24798.0
2021-07-26 05:30:00	AAPL	Stock	147.8	148.05	147.8	147.95	11111.0
2021-07-26 06:00:00	AAPL	Stock	147.94	148.0	147.89	147.9	3438.0
2021-07-26 06:30:00	AAPL	Stock	147.92	147.94	147.64	147.64	4652.0
2021-07-26 07:00:00	AAPL	Stock	147.7	148.32	147.7	148.27	82839.0
2021-07-26 07:30:00	AAPL	Stock	148.29	148.51	148.27	148.35	68706.0
2021-07-26 08:00:00	AAPL	Stock	148.4	148.55	147.77	148.28	289906.0
2021-07-26 08:30:00	AAPL	Stock	148.3	148.33	148.0	148.16	135300.0
2021-07-26 09:00:00	AAPL	Stock	148.14	148.4	148.09	148.27	176153.0
2021-07-26 09:30:00	AAPL	Stock	148.27	149.74	147.7	149.49	11265135.0
2021-07-26 10:00:00	AAPL	Stock	149.49	149.83	148.92	149.1499	6417264.0
2021-07-26 10:30:00	AAPL	Stock	149.13	149.61	149.125	149.34	4410195.0
2021-07-26 11:00:00	AAPL	Stock	149.35	149.6	149.21	149.5132	3074071.0
2021-07-26 11:30:00	AAPL	Stock	149.51	149.81	149.39	149.5	3497401.0
2021-07-26 12:00:00	AAPL	Stock	149.52	149.6299	149.35	149.3874	2286899.0
2021-07-26 12:30:00	AAPL	Stock	149.385	149.43	149.04	149.08	2598085.0
2021-07-26 13:00:00	AAPL	Stock	149.085	149.51	149.06	149.4	2344198.0
2021-07-26 13:30:00	AAPL	Stock	149.405	149.45	149.19	149.35	1646841.0
2021-07-26 14:00:00	AAPL	Stock	149.34	149.44	149.0421	149.25	2333202.0
2021-07-26 14:30:00	AAPL	Stock	149.26	149.5	149.223	149.48	2244628.0
2021-07-26 15:00:00	AAPL	Stock	149.475	149.5	149.29	149.45	2585800.0
2021-07-26 15:30:00	AAPL	Stock	149.445	149.47	148.7717	148.99	6494854.0
2021-07-26 16:00:00	AAPL	Stock	148.99	149.17	148.91	149.15	6921917.0
2021-07-26 16:30:00	AAPL	Stock	149.12	149.27	149.01	149.21	91206.0
2021-07-26 17:00:00	AAPL	Stock	149.24	149.3	149.16	149.27	54400.0
2021-07-26 17:30:00	AAPL	Stock	149.27	149.34	149.13	149.3	69086.0
2021-07-26 18:00:00	AAPL	Stock	149.3	149.32	149.24	149.25	58821.0
2021-07-26 18:30:00	AAPL	Stock	149.25	149.32	149.21	149.29	36552.0
2021-07-26 19:00:00	AAPL	Stock	149.295	149.33	149.27	149.3	33313.0
2021-07-26 19:30:00	AAPL	Stock	149.29	149.35	149.26	149.26	43664.0
2021-07-26 04:00:00	MSFT	Stock	289.74	289.74	289.0	289.4	7669.0
2021-07-26 04:30:00	MSFT	Stock	289.4	289.88	289.4	289.8	3233.0
2021-07-26 05:00:00	MSFT	Stock	289.89	290.04	289.8	290.0	1535.0
2021-07-26 05:30:00	MSFT	Stock	290.0	290.44	290.0	290.38	1478.0
2021-07-26 06:00:00	MSFT	Stock	290.13	290.3	290.1	290.3	411.0
2021-07-26 06:30:00	MSFT	Stock	290.07	290.12	289.6	289.6	4045.0
2021-07-26 07:00:00	MSFT	Stock	289.69	289.95	289.64	289.74	9711.0
2021-07-26 07:30:00	MSFT	Stock	289.64	290.39	289.6	289.9	15337.0
2021-07-26 08:00:00	MSFT	Stock	289.95	290.394	289.12	289.12	39411.0
2021-07-26 08:30:00	MSFT	Stock	289.2	289.67	288.66	289.0	77110.0
2021-07-26 09:00:00	MSFT	Stock	288.97	289.39	288.85	289.39	19634.0
2021-07-26 09:30:00	MSFT	Stock	288.94	289.065	286.642	288.025	2319371.0
2021-07-26 10:00:00	MSFT	Stock	288.035	288.2	286.665	286.74	1237773.0
2021-07-26 10:30:00	MSFT	Stock	286.74	287.89	286.66	286.97	1118424.0
2021-07-26 11:00:00	MSFT	Stock	286.94	287.74	286.815	287.68	892577.0
2021-07-26 11:30:00	MSFT	Stock	287.66	288.5499	287.59	288.51	765295.0
2021-07-26 12:00:00	MSFT	Stock	288.5285	289.36	288.52	288.77	1212231.0
2021-07-26 12:30:00	MSFT	Stock	288.775	288.8099	288.13	288.43	728180.0

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

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