PREVIEW / stock_30min / 2020-07-07

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-07.parquet
  size:    1.9 MB
  rows:    95,982
  symbols: 2,424

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-07-07 04:00:00	AAPL	Stock	93.25	93.305	93.0825	93.0825	20888.0
2020-07-07 04:30:00	AAPL	Stock	93.1275	93.175	93.035	93.1125	3064.0
2020-07-07 05:00:00	AAPL	Stock	93.0125	93.15	92.925	93.0	16988.0
2020-07-07 05:30:00	AAPL	Stock	93.0025	93.0225	93.0	93.0225	8944.0
2020-07-07 06:00:00	AAPL	Stock	93.0225	93.025	93.0225	93.025	4232.0
2020-07-07 06:30:00	AAPL	Stock	93.0275	93.075	93.0275	93.075	3640.0
2020-07-07 07:00:00	AAPL	Stock	93.1225	93.305	93.06	93.3	91964.0
2020-07-07 07:30:00	AAPL	Stock	93.3175	93.5825	93.2425	93.5475	71516.0
2020-07-07 08:00:00	AAPL	Stock	93.266	93.7125	93.075	93.6	228188.0
2020-07-07 08:30:00	AAPL	Stock	93.6	93.6675	93.463	93.645	189424.0
2020-07-07 09:00:00	AAPL	Stock	93.6375	93.9025	93.625	93.9025	332924.0
2020-07-07 09:30:00	AAPL	Stock	93.8675	94.225	93.5	93.9762	13248736.0
2020-07-07 10:00:00	AAPL	Stock	93.9575	94.655	93.8075	94.6225	9589628.0
2020-07-07 10:30:00	AAPL	Stock	94.625	94.625	94.1725	94.52	6934652.0
2020-07-07 11:00:00	AAPL	Stock	94.5188	94.625	94.4	94.5175	4176500.0
2020-07-07 11:30:00	AAPL	Stock	94.5175	94.6125	94.25	94.4075	4141216.0
2020-07-07 12:00:00	AAPL	Stock	94.42	94.4675	93.8575	94.22	5749628.0
2020-07-07 12:30:00	AAPL	Stock	94.22	94.265	93.8925	94.1525	3583712.0
2020-07-07 13:00:00	AAPL	Stock	94.145	94.215	93.7975	94.0425	3699468.0
2020-07-07 13:30:00	AAPL	Stock	94.0412	94.19	93.8775	93.96	2986068.0
2020-07-07 14:00:00	AAPL	Stock	93.955	94.0025	93.7725	93.865	4006932.0
2020-07-07 14:30:00	AAPL	Stock	93.8575	93.8938	93.7125	93.8675	4333996.0
2020-07-07 15:00:00	AAPL	Stock	93.865	93.87	93.6025	93.7375	5011536.0
2020-07-07 15:30:00	AAPL	Stock	93.745	93.9375	93.0575	93.16	10385108.0
2020-07-07 16:00:00	AAPL	Stock	93.1725	93.3625	93.1125	93.3125	9974832.0
2020-07-07 16:30:00	AAPL	Stock	93.275	93.3475	93.2625	93.3225	36764.0
2020-07-07 17:00:00	AAPL	Stock	93.3375	93.345	93.2125	93.3125	62316.0
2020-07-07 17:30:00	AAPL	Stock	93.3125	93.3625	93.3125	93.325	13144.0
2020-07-07 18:00:00	AAPL	Stock	93.3925	93.61	93.3875	93.55	31916.0
2020-07-07 18:30:00	AAPL	Stock	93.575	93.575	93.5125	93.525	19128.0
2020-07-07 19:00:00	AAPL	Stock	93.55	93.61	93.54	93.6	20764.0
2020-07-07 19:30:00	AAPL	Stock	93.5825	93.75	93.575	93.7275	71232.0
2020-07-07 04:00:00	MSFT	Stock	210.74	210.74	210.0	210.0	2094.0
2020-07-07 04:30:00	MSFT	Stock	209.55	209.55	209.51	209.51	780.0
2020-07-07 05:00:00	MSFT	Stock	210.0	210.0	209.61	209.65	3118.0
2020-07-07 05:30:00	MSFT	Stock	209.65	209.84	209.57	209.65	5153.0
2020-07-07 06:00:00	MSFT	Stock	209.69	209.73	209.65	209.65	1155.0
2020-07-07 06:30:00	MSFT	Stock	209.89	210.02	209.83	209.83	1082.0
2020-07-07 07:00:00	MSFT	Stock	210.0	210.3	209.92	210.15	14801.0
2020-07-07 07:30:00	MSFT	Stock	210.22	210.35	209.93	210.27	20688.0
2020-07-07 08:00:00	MSFT	Stock	210.0	211.22	209.92	210.1	28275.0
2020-07-07 08:30:00	MSFT	Stock	210.101	210.438	210.01	210.36	23636.0
2020-07-07 09:00:00	MSFT	Stock	210.4	210.7	210.2	210.65	46511.0
2020-07-07 09:30:00	MSFT	Stock	210.65	212.33	210.3	211.9	2981741.0
2020-07-07 10:00:00	MSFT	Stock	211.9	214.31	211.61	213.96	2733522.0
2020-07-07 10:30:00	MSFT	Stock	213.96	214.67	213.6	214.17	2069168.0
2020-07-07 11:00:00	MSFT	Stock	214.17	214.395	213.8	213.86	1030511.0
2020-07-07 11:30:00	MSFT	Stock	213.865	213.98	212.85	212.98	1239186.0
2020-07-07 12:00:00	MSFT	Stock	213.0	213.23	211.83	212.315	1140260.0
2020-07-07 12:30:00	MSFT	Stock	212.31	213.2	212.15	212.975	1177943.0

> showing 50 of 95,982 rows — these rows as CSV

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