PREVIEW / stock_30min / 2020-06-15

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-15.parquet
  size:    2.0 MB
  rows:    100,422
  symbols: 2,402

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-06-15 04:00:00	AAPL	Stock	82.625	82.875	82.625	82.875	53684.0
2020-06-15 04:30:00	AAPL	Stock	83.005	83.1	82.9375	83.0	7556.0
2020-06-15 05:00:00	AAPL	Stock	83.0675	83.12	82.925	83.12	14668.0
2020-06-15 05:30:00	AAPL	Stock	83.025	83.445	83.0025	83.3325	15872.0
2020-06-15 06:00:00	AAPL	Stock	83.3375	83.73	83.325	83.325	8088.0
2020-06-15 06:30:00	AAPL	Stock	83.0375	83.325	82.975	82.975	27408.0
2020-06-15 07:00:00	AAPL	Stock	83.0	83.375	82.905	83.3575	130208.0
2020-06-15 07:30:00	AAPL	Stock	83.3375	83.6875	83.25	83.4725	117916.0
2020-06-15 08:00:00	AAPL	Stock	83.295	83.6825	82.9295	83.39	350436.0
2020-06-15 08:30:00	AAPL	Stock	83.465	83.5625	83.3	83.405	241212.0
2020-06-15 09:00:00	AAPL	Stock	83.3875	83.6475	83.255	83.2875	256412.0
2020-06-15 09:30:00	AAPL	Stock	83.2875	84.2	83.145	84.04	14995508.0
2020-06-15 10:00:00	AAPL	Stock	84.0275	84.4112	83.8425	83.88	8495348.0
2020-06-15 10:30:00	AAPL	Stock	83.875	84.1725	83.6	83.8975	6958284.0
2020-06-15 11:00:00	AAPL	Stock	83.8925	84.45	83.86	84.305	7698388.0
2020-06-15 11:30:00	AAPL	Stock	84.2925	84.4775	84.155	84.395	5902356.0
2020-06-15 12:00:00	AAPL	Stock	84.3918	84.9762	84.34	84.845	7131876.0
2020-06-15 12:30:00	AAPL	Stock	84.845	85.0748	84.7125	84.957	4982052.0
2020-06-15 13:00:00	AAPL	Stock	84.965	85.1525	84.75	84.9	4624896.0
2020-06-15 13:30:00	AAPL	Stock	84.8925	85.27	84.8725	85.22	4394848.0
2020-06-15 14:00:00	AAPL	Stock	85.23	86.17	85.2225	86.0525	10429832.0
2020-06-15 14:30:00	AAPL	Stock	86.0525	86.2	85.79	86.04	6910656.0
2020-06-15 15:00:00	AAPL	Stock	86.035	86.195	85.555	85.6375	6044540.0
2020-06-15 15:30:00	AAPL	Stock	85.643	86.42	85.2975	85.7475	13539604.0
2020-06-15 16:00:00	AAPL	Stock	85.7675	85.875	85.5	85.83	10426132.0
2020-06-15 16:30:00	AAPL	Stock	85.825	86.0	85.825	85.9625	70920.0
2020-06-15 17:00:00	AAPL	Stock	85.9625	86.06	85.9125	85.965	42484.0
2020-06-15 17:30:00	AAPL	Stock	85.95	86.0125	85.95	85.9975	12884.0
2020-06-15 18:00:00	AAPL	Stock	86.01	86.22	85.925	86.1125	48668.0
2020-06-15 18:30:00	AAPL	Stock	86.05	86.125	85.98	86.075	19056.0
2020-06-15 19:00:00	AAPL	Stock	86.1125	86.15	85.99	86.15	27908.0
2020-06-15 19:30:00	AAPL	Stock	86.15	86.4475	86.1	86.4475	91232.0
2020-06-15 04:00:00	MSFT	Stock	183.6	183.85	183.19	183.85	6205.0
2020-06-15 04:30:00	MSFT	Stock	183.91	184.2	183.9	184.2	3618.0
2020-06-15 05:00:00	MSFT	Stock	184.53	184.55	184.22	184.55	3856.0
2020-06-15 05:30:00	MSFT	Stock	184.31	185.0	184.2	185.0	3173.0
2020-06-15 06:00:00	MSFT	Stock	185.2	185.39	184.82	184.82	5199.0
2020-06-15 06:30:00	MSFT	Stock	184.82	184.82	183.7	184.0	5549.0
2020-06-15 07:00:00	MSFT	Stock	184.0	185.0	183.5	184.6	39519.0
2020-06-15 07:30:00	MSFT	Stock	184.56	185.27	184.39	184.57	11426.0
2020-06-15 08:00:00	MSFT	Stock	184.0	185.27	183.98	184.9	53347.0
2020-06-15 08:30:00	MSFT	Stock	185.22	185.52	185.07	185.3	19650.0
2020-06-15 09:00:00	MSFT	Stock	185.25	185.4	184.52	184.52	49517.0
2020-06-15 09:30:00	MSFT	Stock	184.65	187.21	184.01	187.16	3898182.0
2020-06-15 10:00:00	MSFT	Stock	187.13	187.89	186.742	187.24	2021397.0
2020-06-15 10:30:00	MSFT	Stock	187.23	187.48	186.37	186.66	1619610.0
2020-06-15 11:00:00	MSFT	Stock	186.68	187.61	186.44	187.18	1268114.0
2020-06-15 11:30:00	MSFT	Stock	187.12	187.57	186.79	187.21	1176702.0
2020-06-15 12:00:00	MSFT	Stock	187.2	187.93	187.08	187.6	1116918.0
2020-06-15 12:30:00	MSFT	Stock	187.6	187.97	187.24	187.8	935618.0

> showing 50 of 100,422 rows — these rows as CSV

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