PREVIEW / stock_30min / 2021-12-28

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-12-28.parquet
  size:    2.2 MB
  rows:    109,343
  symbols: 2,642

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-12-28 04:00:00	AAPL	Stock	180.25	181.16	180.24	181.03	22880.0
2021-12-28 04:30:00	AAPL	Stock	180.94	181.12	180.7	181.12	12128.0
2021-12-28 05:00:00	AAPL	Stock	181.1	181.25	181.03	181.16	8619.0
2021-12-28 05:30:00	AAPL	Stock	181.11	181.2	181.0	181.2	5401.0
2021-12-28 06:00:00	AAPL	Stock	181.07	181.13	181.0	181.07	2024.0
2021-12-28 06:30:00	AAPL	Stock	181.07	181.07	180.75	180.85	15220.0
2021-12-28 07:00:00	AAPL	Stock	180.77	181.0	180.65	180.93	60723.0
2021-12-28 07:30:00	AAPL	Stock	180.94	181.07	180.89	180.89	54588.0
2021-12-28 08:00:00	AAPL	Stock	180.8399	181.03	180.57	180.69	259211.0
2021-12-28 08:30:00	AAPL	Stock	180.7	180.71	180.19	180.21	195204.0
2021-12-28 09:00:00	AAPL	Stock	180.23	180.34	180.0	180.14	213955.0
2021-12-28 09:30:00	AAPL	Stock	180.16	180.43	178.9	179.98	9549266.0
2021-12-28 10:00:00	AAPL	Stock	179.99	180.16	178.53	179.2098	6668448.0
2021-12-28 10:30:00	AAPL	Stock	179.205	180.02	179.04	179.9	4440668.0
2021-12-28 11:00:00	AAPL	Stock	179.89	181.33	179.85	179.98	8451890.0
2021-12-28 11:30:00	AAPL	Stock	179.99	180.62	179.6901	180.52	4798221.0
2021-12-28 12:00:00	AAPL	Stock	180.52	180.66	179.71	179.76	3737338.0
2021-12-28 12:30:00	AAPL	Stock	179.7674	179.92	179.28	179.49	4440145.0
2021-12-28 13:00:00	AAPL	Stock	179.48	179.99	179.28	179.9477	3160121.0
2021-12-28 13:30:00	AAPL	Stock	179.94	180.03	179.391	179.7556	2743031.0
2021-12-28 14:00:00	AAPL	Stock	179.74	179.75	179.07	179.39	3644445.0
2021-12-28 14:30:00	AAPL	Stock	179.39	179.645	179.16	179.5	2582374.0
2021-12-28 15:00:00	AAPL	Stock	179.5	179.63	179.2632	179.305	2885415.0
2021-12-28 15:30:00	AAPL	Stock	179.3	179.82	179.14	179.39	7211292.0
2021-12-28 16:00:00	AAPL	Stock	179.29	179.69	179.2	179.29	3826584.0
2021-12-28 16:30:00	AAPL	Stock	179.53	179.58	179.29	179.54	343386.0
2021-12-28 17:00:00	AAPL	Stock	179.55	179.6	179.55	179.59	11214.0
2021-12-28 17:30:00	AAPL	Stock	179.6	179.6	179.45	179.45	14584.0
2021-12-28 18:00:00	AAPL	Stock	179.49	179.7	179.48	179.64	21401.0
2021-12-28 18:30:00	AAPL	Stock	179.64	179.82	179.64	179.77	36988.0
2021-12-28 19:00:00	AAPL	Stock	179.78	179.85	179.63	179.75	12261.0
2021-12-28 19:30:00	AAPL	Stock	179.74	179.85	179.68	179.85	35798.0
2021-12-28 04:00:00	MSFT	Stock	343.0	343.77	343.0	343.75	1186.0
2021-12-28 04:30:00	MSFT	Stock	343.55	343.6	343.55	343.6	390.0
2021-12-28 05:00:00	MSFT	Stock	343.55	344.0	343.55	343.9	1477.0
2021-12-28 05:30:00	MSFT	Stock	343.9	343.97	343.8	343.97	468.0
2021-12-28 06:00:00	MSFT	Stock	343.75	343.8	343.75	343.8	539.0
2021-12-28 06:30:00	MSFT	Stock	343.62	343.62	343.03	343.1	3023.0
2021-12-28 07:00:00	MSFT	Stock	343.68	343.95	343.55	343.89	5910.0
2021-12-28 07:30:00	MSFT	Stock	343.9	344.32	343.8	344.2	16039.0
2021-12-28 08:00:00	MSFT	Stock	343.8962	344.4	343.1	344.01	29440.0
2021-12-28 08:30:00	MSFT	Stock	344.09	344.09	343.3	343.3	15131.0
2021-12-28 09:00:00	MSFT	Stock	343.26	343.35	342.21	343.08	26447.0
2021-12-28 09:30:00	MSFT	Stock	343.09	343.81	340.32	343.0	1785959.0
2021-12-28 10:00:00	MSFT	Stock	343.0	343.1272	340.93	341.92	832047.0
2021-12-28 10:30:00	MSFT	Stock	341.9	342.95	341.57	342.37	650141.0
2021-12-28 11:00:00	MSFT	Stock	342.38	343.11	341.34	341.79	624836.0
2021-12-28 11:30:00	MSFT	Stock	341.81	342.83	341.02	342.71	557714.0
2021-12-28 12:00:00	MSFT	Stock	342.7	343.01	341.54	341.6	474743.0
2021-12-28 12:30:00	MSFT	Stock	341.58	341.87	340.77	341.5	458857.0

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

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