PREVIEW / stock_30min / 2021-07-30

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-30.parquet
  size:    2.2 MB
  rows:    108,165
  symbols: 2,824

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-30 04:00:00	AAPL	Stock	144.1	144.7	144.0	144.22	23940.0
2021-07-30 04:30:00	AAPL	Stock	144.17	144.65	144.11	144.4	10618.0
2021-07-30 05:00:00	AAPL	Stock	144.32	144.32	144.11	144.21	12501.0
2021-07-30 05:30:00	AAPL	Stock	144.28	144.5	144.1	144.4	37650.0
2021-07-30 06:00:00	AAPL	Stock	144.45	144.74	144.4	144.61	14977.0
2021-07-30 06:30:00	AAPL	Stock	144.61	144.9	144.61	144.8	8335.0
2021-07-30 07:00:00	AAPL	Stock	144.83	144.93	144.54	144.62	57678.0
2021-07-30 07:30:00	AAPL	Stock	144.57	144.62	144.33	144.52	53511.0
2021-07-30 08:00:00	AAPL	Stock	144.7701	145.276	144.21	144.44	198557.0
2021-07-30 08:30:00	AAPL	Stock	144.44	144.7	144.25	144.48	125859.0
2021-07-30 09:00:00	AAPL	Stock	144.51	144.55	144.27	144.43	254997.0
2021-07-30 09:30:00	AAPL	Stock	144.43	145.33	144.11	145.1	10139901.0
2021-07-30 10:00:00	AAPL	Stock	145.12	145.3	144.525	144.75	5422071.0
2021-07-30 10:30:00	AAPL	Stock	144.75	145.0	144.55	144.8	3561658.0
2021-07-30 11:00:00	AAPL	Stock	144.79	145.08	144.665	145.035	3212547.0
2021-07-30 11:30:00	AAPL	Stock	145.03	145.18	144.83	145.12	2377436.0
2021-07-30 12:00:00	AAPL	Stock	145.11	145.32	144.95	145.2386	2491773.0
2021-07-30 12:30:00	AAPL	Stock	145.24	145.5	145.14	145.4776	2239518.0
2021-07-30 13:00:00	AAPL	Stock	145.4793	145.75	145.35	145.66	2246980.0
2021-07-30 13:30:00	AAPL	Stock	145.66	145.905	145.655	145.748	2337952.0
2021-07-30 14:00:00	AAPL	Stock	145.745	146.29	145.66	146.185	3131414.0
2021-07-30 14:30:00	AAPL	Stock	146.185	146.32	146.07	146.21	3002144.0
2021-07-30 15:00:00	AAPL	Stock	146.21	146.33	145.81	145.935	3294998.0
2021-07-30 15:30:00	AAPL	Stock	145.945	146.16	145.775	145.86	6611720.0
2021-07-30 16:00:00	AAPL	Stock	145.86	145.95	145.75	145.85	7498561.0
2021-07-30 16:30:00	AAPL	Stock	145.85	145.93	145.82	145.88	42535.0
2021-07-30 17:00:00	AAPL	Stock	145.9128	145.93	145.5336	145.87	14824.0
2021-07-30 17:30:00	AAPL	Stock	145.87	145.89	145.82	145.88	16206.0
2021-07-30 18:00:00	AAPL	Stock	145.85	145.88	145.84	145.86	5719.0
2021-07-30 18:30:00	AAPL	Stock	145.86	145.86	145.81	145.83	7050.0
2021-07-30 19:00:00	AAPL	Stock	145.83	145.88	145.81	145.88	10839.0
2021-07-30 19:30:00	AAPL	Stock	145.85	146.0	145.85	145.95	29225.0
2021-07-30 04:00:00	MSFT	Stock	284.5	284.7	284.21	284.61	3929.0
2021-07-30 04:30:00	MSFT	Stock	284.55	284.78	284.27	284.3	2165.0
2021-07-30 05:00:00	MSFT	Stock	284.6	284.6	284.41	284.44	761.0
2021-07-30 05:30:00	MSFT	Stock	284.5	284.5	284.36	284.36	4244.0
2021-07-30 06:00:00	MSFT	Stock	284.5	284.5	284.43	284.5	757.0
2021-07-30 06:30:00	MSFT	Stock	284.7	285.0	284.7	285.0	1125.0
2021-07-30 07:00:00	MSFT	Stock	285.0	285.44	284.92	284.94	10141.0
2021-07-30 07:30:00	MSFT	Stock	285.01	285.01	284.76	284.76	2298.0
2021-07-30 08:00:00	MSFT	Stock	284.61	285.18	284.35	284.43	11692.0
2021-07-30 08:30:00	MSFT	Stock	284.35	284.8	284.26	284.45	8247.0
2021-07-30 09:00:00	MSFT	Stock	284.48	285.56	284.0	285.2	39632.0
2021-07-30 09:30:00	MSFT	Stock	285.17	286.66	284.6	284.8	2017436.0
2021-07-30 10:00:00	MSFT	Stock	284.805	285.77	284.8	285.16	1052587.0
2021-07-30 10:30:00	MSFT	Stock	285.16	285.72	284.59	285.38	894313.0
2021-07-30 11:00:00	MSFT	Stock	285.37	285.6	284.94	285.4	670180.0
2021-07-30 11:30:00	MSFT	Stock	285.38	285.57	284.46	284.74	774675.0
2021-07-30 12:00:00	MSFT	Stock	284.73	285.48	284.68	285.035	638908.0
2021-07-30 12:30:00	MSFT	Stock	285.04	285.2799	284.87	285.105	412868.0

> showing 50 of 108,165 rows — these rows as CSV

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