PREVIEW / stock_30min / 2020-07-23

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-23.parquet
  size:    1.9 MB
  rows:    96,685
  symbols: 2,447

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-23 04:00:00	AAPL	Stock	97.7375	97.895	97.725	97.895	11120.0
2020-07-23 04:30:00	AAPL	Stock	97.875	97.875	97.7025	97.7025	5808.0
2020-07-23 05:00:00	AAPL	Stock	97.7025	97.75	97.6425	97.675	7600.0
2020-07-23 05:30:00	AAPL	Stock	97.675	97.685	97.64	97.685	5592.0
2020-07-23 06:00:00	AAPL	Stock	97.64	97.9	97.64	97.7675	16788.0
2020-07-23 06:30:00	AAPL	Stock	97.7775	97.7775	97.725	97.73	1964.0
2020-07-23 07:00:00	AAPL	Stock	97.75	97.895	97.35	97.365	185316.0
2020-07-23 07:30:00	AAPL	Stock	97.375	97.4975	97.335	97.4975	63052.0
2020-07-23 08:00:00	AAPL	Stock	97.3775	97.8952	97.25	97.4695	156736.0
2020-07-23 08:30:00	AAPL	Stock	97.4375	97.469	97.055	97.0875	181044.0
2020-07-23 09:00:00	AAPL	Stock	97.075	97.2125	96.885	96.9975	183704.0
2020-07-23 09:30:00	AAPL	Stock	96.9975	97.0775	96.4725	96.675	9035228.0
2020-07-23 10:00:00	AAPL	Stock	96.675	96.7875	95.915	96.2718	8395296.0
2020-07-23 10:30:00	AAPL	Stock	96.2662	96.4475	95.7225	95.7875	6674816.0
2020-07-23 11:00:00	AAPL	Stock	95.7852	96.0375	95.5875	95.9375	5833928.0
2020-07-23 11:30:00	AAPL	Stock	95.95	96.0	95.5875	95.71	5054024.0
2020-07-23 12:00:00	AAPL	Stock	95.7025	95.7025	94.7975	94.9025	10960128.0
2020-07-23 12:30:00	AAPL	Stock	94.89	95.002	94.1625	94.5975	9157620.0
2020-07-23 13:00:00	AAPL	Stock	94.5975	94.9675	94.3	94.5965	6439592.0
2020-07-23 13:30:00	AAPL	Stock	94.585	94.6975	93.25	93.485	13104740.0
2020-07-23 14:00:00	AAPL	Stock	93.4788	93.5175	92.0825	92.8838	19555052.0
2020-07-23 14:30:00	AAPL	Stock	92.875	93.3125	92.6	93.127	11601788.0
2020-07-23 15:00:00	AAPL	Stock	93.1275	93.185	92.0098	92.465	14120276.0
2020-07-23 15:30:00	AAPL	Stock	92.453	92.955	92.163	92.89	16841360.0
2020-07-23 16:00:00	AAPL	Stock	92.865	93.0	92.605	92.6625	9942464.0
2020-07-23 16:30:00	AAPL	Stock	92.695	92.725	92.5125	92.7025	144668.0
2020-07-23 17:00:00	AAPL	Stock	92.725	92.75	92.655	92.7125	53492.0
2020-07-23 17:30:00	AAPL	Stock	92.725	92.8075	92.6875	92.7125	57256.0
2020-07-23 18:00:00	AAPL	Stock	92.775	93.175	92.775	93.0	138580.0
2020-07-23 18:30:00	AAPL	Stock	93.0225	93.205	93.0175	93.135	55128.0
2020-07-23 19:00:00	AAPL	Stock	93.1625	93.1625	92.9775	93.0	62804.0
2020-07-23 19:30:00	AAPL	Stock	93.0375	93.12	92.895	93.1125	83224.0
2020-07-23 04:00:00	MSFT	Stock	208.75	208.75	207.9	208.7	26102.0
2020-07-23 04:30:00	MSFT	Stock	208.7	208.7	207.83	207.83	15558.0
2020-07-23 05:00:00	MSFT	Stock	207.8	207.8	207.48	207.65	10513.0
2020-07-23 05:30:00	MSFT	Stock	207.6	208.8	207.6	207.9	29233.0
2020-07-23 06:00:00	MSFT	Stock	207.9	208.8	207.4	208.4	38173.0
2020-07-23 06:30:00	MSFT	Stock	208.4	208.42	206.6	206.99	39152.0
2020-07-23 07:00:00	MSFT	Stock	207.19	208.3	206.75	207.72	121636.0
2020-07-23 07:30:00	MSFT	Stock	207.72	208.89	207.61	208.36	125535.0
2020-07-23 08:00:00	MSFT	Stock	208.35	208.9	206.8	208.53	240577.0
2020-07-23 08:30:00	MSFT	Stock	208.57	208.69	207.57	207.95	184199.0
2020-07-23 09:00:00	MSFT	Stock	207.86	208.65	207.0	207.11	263416.0
2020-07-23 09:30:00	MSFT	Stock	207.11	210.92	206.91	209.653	9135496.0
2020-07-23 10:00:00	MSFT	Stock	209.63	209.67	207.15	208.653	4642044.0
2020-07-23 10:30:00	MSFT	Stock	208.65	208.84	207.327	207.81	2325743.0
2020-07-23 11:00:00	MSFT	Stock	207.82	208.27	207.27	207.41	1974948.0
2020-07-23 11:30:00	MSFT	Stock	207.43	208.07	206.97	207.64	2674005.0
2020-07-23 12:00:00	MSFT	Stock	207.654	207.654	205.35	205.59	3658036.0
2020-07-23 12:30:00	MSFT	Stock	205.58	205.82	204.42	205.605	3710279.0

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

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