PREVIEW / stock_30min / 2020-07-10

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-10.parquet
  size:    1.9 MB
  rows:    96,721
  symbols: 2,448

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-10 04:00:00	AAPL	Stock	95.22	95.5	95.22	95.35	17072.0
2020-07-10 04:30:00	AAPL	Stock	95.25	95.305	95.18	95.195	9856.0
2020-07-10 05:00:00	AAPL	Stock	95.2425	95.2525	95.075	95.155	47184.0
2020-07-10 05:30:00	AAPL	Stock	95.35	95.4675	95.35	95.4	4368.0
2020-07-10 06:00:00	AAPL	Stock	95.4525	95.4525	95.3	95.3	7104.0
2020-07-10 07:00:00	AAPL	Stock	95.485	95.5425	95.4025	95.405	115064.0
2020-07-10 07:30:00	AAPL	Stock	95.39	95.4025	95.25	95.2975	80256.0
2020-07-10 08:00:00	AAPL	Stock	95.4625	95.92	95.0625	95.2475	174396.0
2020-07-10 08:30:00	AAPL	Stock	95.25	95.5725	95.25	95.475	189624.0
2020-07-10 09:00:00	AAPL	Stock	95.4968	95.8125	95.225	95.235	436944.0
2020-07-10 09:30:00	AAPL	Stock	95.235	95.785	94.8625	94.9775	13155480.0
2020-07-10 10:00:00	AAPL	Stock	94.9875	95.5	94.7053	95.4588	8494936.0
2020-07-10 10:30:00	AAPL	Stock	95.4575	95.5125	95.1975	95.3175	4433020.0
2020-07-10 11:00:00	AAPL	Stock	95.3125	95.455	95.12	95.4238	3302288.0
2020-07-10 11:30:00	AAPL	Stock	95.4225	95.6325	95.336	95.505	3628016.0
2020-07-10 12:00:00	AAPL	Stock	95.5225	95.5562	95.225	95.254	3330032.0
2020-07-10 12:30:00	AAPL	Stock	95.2575	95.3125	95.1075	95.2175	3010640.0
2020-07-10 13:00:00	AAPL	Stock	95.2225	95.495	95.175	95.4588	2843196.0
2020-07-10 13:30:00	AAPL	Stock	95.4625	95.4725	95.2475	95.3525	3003364.0
2020-07-10 14:00:00	AAPL	Stock	95.3575	95.425	95.2775	95.3725	2413972.0
2020-07-10 14:30:00	AAPL	Stock	95.3725	95.8445	95.335	95.84	4092208.0
2020-07-10 15:00:00	AAPL	Stock	95.835	95.8475	95.6875	95.7925	3765848.0
2020-07-10 15:30:00	AAPL	Stock	95.79	95.98	95.72	95.88	7343196.0
2020-07-10 16:00:00	AAPL	Stock	95.92	95.9575	95.6825	95.9125	6755888.0
2020-07-10 16:30:00	AAPL	Stock	95.9475	96.0475	95.92	95.96	47320.0
2020-07-10 17:00:00	AAPL	Stock	95.9875	95.9875	95.915	95.975	22152.0
2020-07-10 17:30:00	AAPL	Stock	95.975	95.985	95.93	95.945	9016.0
2020-07-10 18:00:00	AAPL	Stock	95.9875	95.9975	95.93	95.975	17552.0
2020-07-10 18:30:00	AAPL	Stock	95.955	95.955	95.8925	95.895	18432.0
2020-07-10 19:00:00	AAPL	Stock	95.895	95.98	95.895	95.965	15360.0
2020-07-10 19:30:00	AAPL	Stock	95.9725	95.9725	95.88	95.925	42188.0
2020-07-10 04:00:00	MSFT	Stock	213.8	213.8	213.48	213.71	3370.0
2020-07-10 04:30:00	MSFT	Stock	213.6	213.6	213.04	213.04	3097.0
2020-07-10 05:00:00	MSFT	Stock	213.2	213.57	213.2	213.57	1802.0
2020-07-10 05:30:00	MSFT	Stock	213.6	213.6	213.6	213.6	842.0
2020-07-10 06:00:00	MSFT	Stock	213.6	213.6	213.51	213.51	1906.0
2020-07-10 06:30:00	MSFT	Stock	213.51	213.85	213.51	213.6	6481.0
2020-07-10 07:00:00	MSFT	Stock	213.7	213.9	213.32	213.72	25837.0
2020-07-10 07:30:00	MSFT	Stock	213.6	213.69	212.5	212.8	18010.0
2020-07-10 08:00:00	MSFT	Stock	213.989	213.989	212.5	212.97	30561.0
2020-07-10 08:30:00	MSFT	Stock	213.0	213.92	212.82	213.75	29837.0
2020-07-10 09:00:00	MSFT	Stock	213.89	214.32	213.5	213.5	66453.0
2020-07-10 09:30:00	MSFT	Stock	213.5	214.08	211.19	212.17	3898431.0
2020-07-10 10:00:00	MSFT	Stock	212.15	212.95	211.08	212.582	2100592.0
2020-07-10 10:30:00	MSFT	Stock	212.56	212.75	211.77	212.59	1422206.0
2020-07-10 11:00:00	MSFT	Stock	212.59	213.03	211.99	212.68	1294643.0
2020-07-10 11:30:00	MSFT	Stock	212.66	213.49	212.58	212.92	1161323.0
2020-07-10 12:00:00	MSFT	Stock	212.91	213.34	212.44	212.65	999478.0
2020-07-10 12:30:00	MSFT	Stock	212.65	213.01	212.34	213.01	885522.0
2020-07-10 13:00:00	MSFT	Stock	213.02	213.441	212.91	213.14	789928.0

> showing 50 of 96,721 rows — these rows as CSV

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