PREVIEW / stock_30min / 2021-10-14

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-10-14.parquet
  size:    2.2 MB
  rows:    109,416
  symbols: 2,685

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-10-14 04:00:00	AAPL	Stock	141.71	142.0	141.7	141.82	17584.0
2021-10-14 04:30:00	AAPL	Stock	141.84	142.06	141.84	142.06	7826.0
2021-10-14 05:00:00	AAPL	Stock	141.94	142.09	141.9	142.05	3150.0
2021-10-14 05:30:00	AAPL	Stock	142.04	142.04	141.89	141.92	5229.0
2021-10-14 06:00:00	AAPL	Stock	141.95	141.96	141.8	141.96	3184.0
2021-10-14 06:30:00	AAPL	Stock	141.97	142.02	141.77	141.77	6478.0
2021-10-14 07:00:00	AAPL	Stock	141.79	142.03	141.72	141.92	89865.0
2021-10-14 07:30:00	AAPL	Stock	141.95	142.22	141.95	142.13	66249.0
2021-10-14 08:00:00	AAPL	Stock	142.13	142.36	141.74	142.28	329877.0
2021-10-14 08:30:00	AAPL	Stock	142.25	142.5	142.2	142.27	214214.0
2021-10-14 09:00:00	AAPL	Stock	142.27	142.48	142.0	142.11	184995.0
2021-10-14 09:30:00	AAPL	Stock	142.09	142.87	141.51	142.7798	9629469.0
2021-10-14 10:00:00	AAPL	Stock	142.7718	143.29	142.7	142.97	5833052.0
2021-10-14 10:30:00	AAPL	Stock	142.97	143.1	142.7	142.86	3970184.0
2021-10-14 11:00:00	AAPL	Stock	142.86	142.97	142.64	142.8878	3292669.0
2021-10-14 11:30:00	AAPL	Stock	142.885	143.22	142.87	143.19	3343749.0
2021-10-14 12:00:00	AAPL	Stock	143.19	143.61	143.17	143.285	3397155.0
2021-10-14 12:30:00	AAPL	Stock	143.285	143.53	143.245	143.52	2233807.0
2021-10-14 13:00:00	AAPL	Stock	143.52	143.64	143.33	143.475	2523969.0
2021-10-14 13:30:00	AAPL	Stock	143.475	143.62	143.475	143.5953	1792821.0
2021-10-14 14:00:00	AAPL	Stock	143.59	143.74	143.445	143.73	2168397.0
2021-10-14 14:30:00	AAPL	Stock	143.72	143.88	143.63	143.85	2380537.0
2021-10-14 15:00:00	AAPL	Stock	143.85	143.86	143.57	143.62	3078068.0
2021-10-14 15:30:00	AAPL	Stock	143.63	143.83	143.34	143.7554	6795002.0
2021-10-14 16:00:00	AAPL	Stock	143.75	144.0	143.2167	143.89	9559025.0
2021-10-14 16:30:00	AAPL	Stock	143.93	143.93	143.76	143.79	102650.0
2021-10-14 17:00:00	AAPL	Stock	143.78	143.85	143.78	143.83	19990.0
2021-10-14 17:30:00	AAPL	Stock	143.83	143.86	143.78	143.8	13220.0
2021-10-14 18:00:00	AAPL	Stock	143.79	143.89	143.76	143.84	15304.0
2021-10-14 18:30:00	AAPL	Stock	143.86	143.86	143.82	143.85	6515.0
2021-10-14 19:00:00	AAPL	Stock	143.84	143.95	143.83	143.95	18392.0
2021-10-14 19:30:00	AAPL	Stock	143.92	143.99	143.89	143.94	21699.0
2021-10-14 04:00:00	MSFT	Stock	298.0	298.7	298.0	298.5	1607.0
2021-10-14 04:30:00	MSFT	Stock	298.5	298.65	298.5	298.65	834.0
2021-10-14 05:00:00	MSFT	Stock	298.58	298.64	298.48	298.48	2829.0
2021-10-14 06:00:00	MSFT	Stock	298.57	298.7	298.36	298.66	3510.0
2021-10-14 06:30:00	MSFT	Stock	298.53	298.53	298.53	298.53	102.0
2021-10-14 07:00:00	MSFT	Stock	298.43	298.8	298.05	298.8	10970.0
2021-10-14 07:30:00	MSFT	Stock	298.78	299.34	298.7	299.19	11175.0
2021-10-14 08:00:00	MSFT	Stock	299.1	299.95	297.05	299.7	35547.0
2021-10-14 08:30:00	MSFT	Stock	299.6	300.29	299.33	299.41	20235.0
2021-10-14 09:00:00	MSFT	Stock	299.41	299.76	299.06	299.06	25757.0
2021-10-14 09:30:00	MSFT	Stock	299.1	300.3195	297.83	299.84	3281076.0
2021-10-14 10:00:00	MSFT	Stock	299.86	301.08	299.68	300.36	1817468.0
2021-10-14 10:30:00	MSFT	Stock	300.37	300.7	300.05	300.2	978261.0
2021-10-14 11:00:00	MSFT	Stock	300.21	300.68	299.85	300.62	867228.0
2021-10-14 11:30:00	MSFT	Stock	300.62	301.057	300.25	301.02	882211.0
2021-10-14 12:00:00	MSFT	Stock	301.02	302.0	300.95	301.61	888274.0
2021-10-14 12:30:00	MSFT	Stock	301.61	301.79	301.41	301.66	700979.0
2021-10-14 13:00:00	MSFT	Stock	301.66	301.84	301.32	301.5	563369.0

> showing 50 of 109,416 rows — these rows as CSV

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