PREVIEW / stock_30min / 2021-07-01

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-07-01.parquet
  size:    2.2 MB
  rows:    112,795
  symbols: 2,949

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-01 04:00:00	AAPL	Stock	137.27	137.35	136.98	137.04	15075.0
2021-07-01 04:30:00	AAPL	Stock	137.0	137.13	137.0	137.06	2023.0
2021-07-01 05:00:00	AAPL	Stock	136.98	136.98	136.82	136.82	1878.0
2021-07-01 05:30:00	AAPL	Stock	136.84	136.86	136.76	136.76	7075.0
2021-07-01 06:00:00	AAPL	Stock	136.81	136.85	136.64	136.64	12589.0
2021-07-01 06:30:00	AAPL	Stock	136.66	136.69	136.48	136.51	10917.0
2021-07-01 07:00:00	AAPL	Stock	136.59	136.75	136.51	136.74	35242.0
2021-07-01 07:30:00	AAPL	Stock	136.74	136.96	136.74	136.94	43485.0
2021-07-01 08:00:00	AAPL	Stock	136.95	137.05	136.61	136.8	195741.0
2021-07-01 08:30:00	AAPL	Stock	136.83	136.96	136.71	136.79	86142.0
2021-07-01 09:00:00	AAPL	Stock	136.79	136.88	136.41	136.57	133873.0
2021-07-01 09:30:00	AAPL	Stock	136.6	137.19	136.41	136.937	7441756.0
2021-07-01 10:00:00	AAPL	Stock	136.935	136.935	136.2698	136.5611	4394370.0
2021-07-01 10:30:00	AAPL	Stock	136.5601	136.58	136.26	136.44	3217042.0
2021-07-01 11:00:00	AAPL	Stock	136.4472	136.475	135.76	136.015	4523686.0
2021-07-01 11:30:00	AAPL	Stock	136.01	136.42	135.97	136.3183	2330249.0
2021-07-01 12:00:00	AAPL	Stock	136.315	136.53	136.3	136.4	1918162.0
2021-07-01 12:30:00	AAPL	Stock	136.395	136.43	136.04	136.0958	1936715.0
2021-07-01 13:00:00	AAPL	Stock	136.095	136.35	136.03	136.2701	1449279.0
2021-07-01 13:30:00	AAPL	Stock	136.27	136.62	136.25	136.52	2214327.0
2021-07-01 14:00:00	AAPL	Stock	136.5299	136.87	136.4701	136.75	2074531.0
2021-07-01 14:30:00	AAPL	Stock	136.755	137.0	136.74	136.985	2043538.0
2021-07-01 15:00:00	AAPL	Stock	136.985	137.07	136.88	136.9426	2462635.0
2021-07-01 15:30:00	AAPL	Stock	136.95	137.33	136.95	137.27	5395369.0
2021-07-01 16:00:00	AAPL	Stock	137.27	137.32	137.23	137.28	4640939.0
2021-07-01 16:30:00	AAPL	Stock	137.28	137.41	134.78	137.27	60594.0
2021-07-01 17:00:00	AAPL	Stock	137.27	137.29	137.22	137.22	16718.0
2021-07-01 17:30:00	AAPL	Stock	137.22	137.24	137.18	137.24	15036.0
2021-07-01 18:00:00	AAPL	Stock	137.21	137.26	137.15	137.16	14782.0
2021-07-01 18:30:00	AAPL	Stock	137.17	137.24	137.15	137.22	6074.0
2021-07-01 19:00:00	AAPL	Stock	137.21	137.25	137.19	137.19	4105.0
2021-07-01 19:30:00	AAPL	Stock	137.18	137.2	137.11	137.11	22089.0
2021-07-01 04:00:00	MSFT	Stock	271.54	271.65	271.27	271.3	2414.0
2021-07-01 04:30:00	MSFT	Stock	271.2	271.2	271.2	271.2	200.0
2021-07-01 05:00:00	MSFT	Stock	271.0	271.0	270.7	270.7	686.0
2021-07-01 05:30:00	MSFT	Stock	270.8	270.8	270.75	270.75	2035.0
2021-07-01 06:00:00	MSFT	Stock	270.8	270.8	270.4	270.4	2992.0
2021-07-01 06:30:00	MSFT	Stock	270.68	270.69	270.13	270.13	1957.0
2021-07-01 07:00:00	MSFT	Stock	270.28	270.46	270.18	270.45	2918.0
2021-07-01 07:30:00	MSFT	Stock	270.55	270.58	270.5	270.58	2149.0
2021-07-01 08:00:00	MSFT	Stock	270.38	270.69	270.38	270.5	6232.0
2021-07-01 08:30:00	MSFT	Stock	270.52	270.75	270.3	270.38	7726.0
2021-07-01 09:00:00	MSFT	Stock	270.39	270.9	269.51	269.67	26276.0
2021-07-01 09:30:00	MSFT	Stock	269.66	270.87	269.59	270.83	1763263.0
2021-07-01 10:00:00	MSFT	Stock	270.8692	271.01	270.21	270.6687	1096309.0
2021-07-01 10:30:00	MSFT	Stock	270.7	271.14	270.39	270.52	811652.0
2021-07-01 11:00:00	MSFT	Stock	270.54	270.58	269.95	270.1901	729444.0
2021-07-01 11:30:00	MSFT	Stock	270.18	270.5672	270.14	270.54	386012.0
2021-07-01 12:00:00	MSFT	Stock	270.53	270.67	270.375	270.525	347926.0
2021-07-01 12:30:00	MSFT	Stock	270.505	270.515	270.1599	270.35	470074.0

> showing 50 of 112,795 rows — these rows as CSV

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