PREVIEW / stock_30min / 2020-06-09

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-09.parquet
  size:    2.0 MB
  rows:    100,656
  symbols: 2,415

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-09 04:00:00	AAPL	Stock	82.9	82.9	82.5	82.5025	15636.0
2020-06-09 04:30:00	AAPL	Stock	82.52	82.65	82.25	82.6	31796.0
2020-06-09 05:00:00	AAPL	Stock	82.625	82.675	82.625	82.675	5800.0
2020-06-09 05:30:00	AAPL	Stock	82.6875	82.7125	82.625	82.7125	7876.0
2020-06-09 06:00:00	AAPL	Stock	82.715	82.825	82.6175	82.6175	6240.0
2020-06-09 06:30:00	AAPL	Stock	82.7225	82.825	82.7225	82.825	7056.0
2020-06-09 07:00:00	AAPL	Stock	82.785	82.96	82.7725	82.8725	51004.0
2020-06-09 07:30:00	AAPL	Stock	82.8025	82.875	82.7125	82.855	59472.0
2020-06-09 08:00:00	AAPL	Stock	82.7505	83.365	82.7275	82.9425	101520.0
2020-06-09 08:30:00	AAPL	Stock	82.9725	83.0475	82.84	83.025	84808.0
2020-06-09 09:00:00	AAPL	Stock	83.0125	83.1	82.99	83.035	102648.0
2020-06-09 09:30:00	AAPL	Stock	83.025	84.275	83.0025	83.995	14911240.0
2020-06-09 10:00:00	AAPL	Stock	83.9875	84.5175	83.8875	84.395	8753152.0
2020-06-09 10:30:00	AAPL	Stock	84.4025	84.905	84.3925	84.88	8213676.0
2020-06-09 11:00:00	AAPL	Stock	84.87	85.435	84.8425	85.385	12318752.0
2020-06-09 11:30:00	AAPL	Stock	85.39	85.5548	85.1875	85.2838	7216568.0
2020-06-09 12:00:00	AAPL	Stock	85.2825	85.95	85.268	85.8988	9186136.0
2020-06-09 12:30:00	AAPL	Stock	85.8975	86.22	85.765	86.0975	6749344.0
2020-06-09 13:00:00	AAPL	Stock	86.09	86.1725	85.915	86.11	5038600.0
2020-06-09 13:30:00	AAPL	Stock	86.11	86.355	86.0775	86.3125	5490968.0
2020-06-09 14:00:00	AAPL	Stock	86.3088	86.4025	85.9275	85.97	6784588.0
2020-06-09 14:30:00	AAPL	Stock	85.97	86.11	85.6725	85.9595	6334516.0
2020-06-09 15:00:00	AAPL	Stock	85.9562	86.27	85.91	86.0875	6339672.0
2020-06-09 15:30:00	AAPL	Stock	86.09	86.2725	85.9075	85.955	9708776.0
2020-06-09 16:00:00	AAPL	Stock	85.9975	85.9975	85.2812	85.7775	7128928.0
2020-06-09 16:30:00	AAPL	Stock	85.8125	85.8875	85.8	85.8475	40908.0
2020-06-09 17:00:00	AAPL	Stock	85.8875	86.01	85.8875	86.01	42876.0
2020-06-09 17:30:00	AAPL	Stock	86.1	86.185	86.005	86.125	45392.0
2020-06-09 18:00:00	AAPL	Stock	86.125	86.25	86.0625	86.2475	68900.0
2020-06-09 18:30:00	AAPL	Stock	86.2475	86.365	86.2	86.34	37568.0
2020-06-09 19:00:00	AAPL	Stock	86.34	86.3925	86.25	86.35	32408.0
2020-06-09 19:30:00	AAPL	Stock	86.3225	86.375	86.3	86.35	39552.0
2020-06-09 04:00:00	MSFT	Stock	187.3	187.4	186.51	186.51	1579.0
2020-06-09 04:30:00	MSFT	Stock	186.8	186.99	186.5	186.5	12595.0
2020-06-09 05:00:00	MSFT	Stock	186.86	187.0	186.86	187.0	4829.0
2020-06-09 05:30:00	MSFT	Stock	186.85	187.0	186.82	187.0	1000.0
2020-06-09 06:00:00	MSFT	Stock	187.25	187.25	186.7	186.7	6278.0
2020-06-09 06:30:00	MSFT	Stock	187.1	187.35	186.76	186.76	2249.0
2020-06-09 07:00:00	MSFT	Stock	186.97	187.3	186.97	187.01	9366.0
2020-06-09 07:30:00	MSFT	Stock	187.0	187.38	187.0	187.32	3797.0
2020-06-09 08:00:00	MSFT	Stock	187.0	188.83	187.0	187.34	23868.0
2020-06-09 08:30:00	MSFT	Stock	187.5	187.73	187.341	187.58	25499.0
2020-06-09 09:00:00	MSFT	Stock	187.5	188.03	187.26	188.03	37421.0
2020-06-09 09:30:00	MSFT	Stock	188.02	188.87	187.61	187.715	3251899.0
2020-06-09 10:00:00	MSFT	Stock	187.72	188.35	187.26	188.21	1866869.0
2020-06-09 10:30:00	MSFT	Stock	188.23	189.62	188.12	189.58	2307337.0
2020-06-09 11:00:00	MSFT	Stock	189.56	189.71	188.813	189.22	1712629.0
2020-06-09 11:30:00	MSFT	Stock	189.23	189.33	188.55	188.72	1335921.0
2020-06-09 12:00:00	MSFT	Stock	188.72	189.25	188.72	189.17	1051785.0
2020-06-09 12:30:00	MSFT	Stock	189.16	189.61	188.955	189.44	1146456.0

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

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