PREVIEW / stock_30min / 2020-10-01

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-01.parquet
  size:    1.9 MB
  rows:    97,670
  symbols: 2,497

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
2020-10-01 04:00:00	AAPL	Stock	116.71	117.19	116.71	116.8	26887.0
2020-10-01 04:30:00	AAPL	Stock	116.76	116.79	116.51	116.71	18031.0
2020-10-01 05:00:00	AAPL	Stock	116.81	117.1	116.77	117.1	8087.0
2020-10-01 05:30:00	AAPL	Stock	117.1	117.48	116.93	117.47	43650.0
2020-10-01 06:00:00	AAPL	Stock	117.38	117.6	117.14	117.6	25498.0
2020-10-01 06:30:00	AAPL	Stock	117.47	117.6	117.22	117.49	11759.0
2020-10-01 07:00:00	AAPL	Stock	117.35	117.7	117.16	117.451	168381.0
2020-10-01 07:30:00	AAPL	Stock	117.48	117.54	117.38	117.54	85589.0
2020-10-01 08:00:00	AAPL	Stock	117.53	117.66	117.2	117.66	441171.0
2020-10-01 08:30:00	AAPL	Stock	117.65	118.1	117.46	117.7	525480.0
2020-10-01 09:00:00	AAPL	Stock	117.7	117.8	117.4	117.7	400873.0
2020-10-01 09:30:00	AAPL	Stock	117.7	117.72	116.16	116.42	15687105.0
2020-10-01 10:00:00	AAPL	Stock	116.41	116.98	116.28	116.65	9184651.0
2020-10-01 10:30:00	AAPL	Stock	116.655	117.02	116.49	116.765	6619136.0
2020-10-01 11:00:00	AAPL	Stock	116.765	116.9	116.14	116.65	6140275.0
2020-10-01 11:30:00	AAPL	Stock	116.66	116.88	116.24	116.315	4719439.0
2020-10-01 12:00:00	AAPL	Stock	116.315	116.43	115.83	116.251	6992515.0
2020-10-01 12:30:00	AAPL	Stock	116.25	116.45	116.01	116.33	4387601.0
2020-10-01 13:00:00	AAPL	Stock	116.33	116.55	116.22	116.382	3995707.0
2020-10-01 13:30:00	AAPL	Stock	116.392	116.92	116.25	116.43	4775395.0
2020-10-01 14:00:00	AAPL	Stock	116.46	116.79	115.91	116.419	7536206.0
2020-10-01 14:30:00	AAPL	Stock	116.41	116.93	116.4	116.75	5908285.0
2020-10-01 15:00:00	AAPL	Stock	116.75	117.03	116.29	116.385	6164898.0
2020-10-01 15:30:00	AAPL	Stock	116.38	117.0	116.12	116.8	9964862.0
2020-10-01 16:00:00	AAPL	Stock	116.79	117.0	116.71	116.76	11167080.0
2020-10-01 16:30:00	AAPL	Stock	116.8	116.9	116.7	116.77	54140.0
2020-10-01 17:00:00	AAPL	Stock	116.76	116.8	116.67	116.7	40448.0
2020-10-01 17:30:00	AAPL	Stock	116.7	116.84	116.66	116.84	50044.0
2020-10-01 18:00:00	AAPL	Stock	116.85	117.1	116.71	116.84	129318.0
2020-10-01 18:30:00	AAPL	Stock	116.82	117.03	116.64	116.93	96605.0
2020-10-01 19:00:00	AAPL	Stock	116.93	117.0	116.83	116.83	39816.0
2020-10-01 19:30:00	AAPL	Stock	116.83	116.89	116.7	116.8	79126.0
2020-10-01 04:00:00	MSFT	Stock	211.88	211.99	211.67	211.99	1185.0
2020-10-01 04:30:00	MSFT	Stock	211.5	211.5	211.11	211.4	1150.0
2020-10-01 05:00:00	MSFT	Stock	211.54	211.8	211.54	211.8	1075.0
2020-10-01 05:30:00	MSFT	Stock	212.49	212.8	212.49	212.79	3865.0
2020-10-01 06:00:00	MSFT	Stock	212.8	213.45	212.62	213.45	5434.0
2020-10-01 06:30:00	MSFT	Stock	213.1	213.1	212.5	212.92	9849.0
2020-10-01 07:00:00	MSFT	Stock	212.95	213.08	212.42	212.86	18646.0
2020-10-01 07:30:00	MSFT	Stock	212.88	213.2	212.81	213.2	16216.0
2020-10-01 08:00:00	MSFT	Stock	213.19	213.2	209.81	212.85	52267.0
2020-10-01 08:30:00	MSFT	Stock	212.94	213.65	212.72	212.9	69483.0
2020-10-01 09:00:00	MSFT	Stock	213.0	213.6	212.83	213.53	55217.0
2020-10-01 09:30:00	MSFT	Stock	213.26	213.99	211.995	212.514	3125623.0
2020-10-01 10:00:00	MSFT	Stock	212.51	212.95	211.96	212.39	1468410.0
2020-10-01 10:30:00	MSFT	Stock	212.39	212.99	211.81	212.19	1029634.0
2020-10-01 11:00:00	MSFT	Stock	212.19	212.68	211.32	212.59	1409970.0
2020-10-01 11:30:00	MSFT	Stock	212.6	213.12	212.22	212.38	861296.0
2020-10-01 12:00:00	MSFT	Stock	212.38	212.62	211.83	211.99	960736.0
2020-10-01 12:30:00	MSFT	Stock	211.99	212.35	211.73	212.35	728152.0

> showing 50 of 97,670 rows — these rows as CSV

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