PREVIEW / stock_30min / 2019-12-19

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-19.parquet
  size:    1.8 MB
  rows:    86,233
  symbols: 2,501

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
2019-12-19 04:00:00	AAPL	Stock	69.9	69.9	69.845	69.845	1284.0
2019-12-19 04:30:00	AAPL	Stock	69.875	69.875	69.875	69.875	2000.0
2019-12-19 05:30:00	AAPL	Stock	69.895	69.895	69.895	69.895	400.0
2019-12-19 06:00:00	AAPL	Stock	69.9175	69.9175	69.75	69.75	32972.0
2019-12-19 06:30:00	AAPL	Stock	69.7725	69.82	69.7375	69.8075	14576.0
2019-12-19 07:00:00	AAPL	Stock	69.79	69.8875	69.7875	69.8375	73248.0
2019-12-19 07:30:00	AAPL	Stock	69.8575	69.8625	69.7625	69.7875	88712.0
2019-12-19 08:00:00	AAPL	Stock	69.8225	69.8875	69.7722	69.85	99748.0
2019-12-19 08:30:00	AAPL	Stock	69.84	69.8725	69.7375	69.8475	182092.0
2019-12-19 09:00:00	AAPL	Stock	69.8475	69.9	69.825	69.8325	128412.0
2019-12-19 09:30:00	AAPL	Stock	69.8775	70.295	69.865	70.115	10704956.0
2019-12-19 10:00:00	AAPL	Stock	70.11	70.137	69.8925	70.075	6107140.0
2019-12-19 10:30:00	AAPL	Stock	70.075	70.0805	69.865	69.872	4598044.0
2019-12-19 11:00:00	AAPL	Stock	69.8725	70.0225	69.8725	69.9948	4186728.0
2019-12-19 11:30:00	AAPL	Stock	69.9945	70.0675	69.9305	69.9565	3076420.0
2019-12-19 12:00:00	AAPL	Stock	69.955	69.9875	69.885	69.895	2410076.0
2019-12-19 12:30:00	AAPL	Stock	69.8925	69.895	69.745	69.8688	3702480.0
2019-12-19 13:00:00	AAPL	Stock	69.87	69.9455	69.7938	69.828	2830628.0
2019-12-19 13:30:00	AAPL	Stock	69.8275	69.9025	69.765	69.7738	3053384.0
2019-12-19 14:00:00	AAPL	Stock	69.774	69.935	69.7375	69.9215	3511956.0
2019-12-19 14:30:00	AAPL	Stock	69.9215	70.02	69.855	69.92	4249568.0
2019-12-19 15:00:00	AAPL	Stock	69.9225	69.9555	69.825	69.8825	2938676.0
2019-12-19 15:30:00	AAPL	Stock	69.8775	70.025	69.8625	70.0075	8309024.0
2019-12-19 16:00:00	AAPL	Stock	70.005	70.0625	69.9035	70.025	18932872.0
2019-12-19 16:30:00	AAPL	Stock	70.0225	70.0575	70.005	70.045	45576.0
2019-12-19 17:00:00	AAPL	Stock	70.045	70.045	70.005	70.0275	373600.0
2019-12-19 17:30:00	AAPL	Stock	70.045	70.045	70.0325	70.0425	9340.0
2019-12-19 18:00:00	AAPL	Stock	70.0375	70.0475	70.0275	70.045	12000.0
2019-12-19 18:30:00	AAPL	Stock	70.045	70.045	70.025	70.04	81536.0
2019-12-19 19:00:00	AAPL	Stock	70.0275	70.045	70.0275	70.045	12244.0
2019-12-19 19:30:00	AAPL	Stock	70.045	70.0625	70.04	70.06	27416.0
2019-12-19 04:00:00	MSFT	Stock	154.5	154.5	154.5	154.5	150.0
2019-12-19 05:30:00	MSFT	Stock	154.6	154.6	154.6	154.6	462.0
2019-12-19 06:00:00	MSFT	Stock	154.55	154.55	154.5	154.5	601.0
2019-12-19 07:00:00	MSFT	Stock	154.55	154.55	154.42	154.53	7894.0
2019-12-19 07:30:00	MSFT	Stock	154.5	154.56	154.18	154.4	17322.0
2019-12-19 08:00:00	MSFT	Stock	154.44	154.75	154.39	154.44	4945.0
2019-12-19 08:30:00	MSFT	Stock	154.4	154.4	154.2	154.32	5683.0
2019-12-19 09:00:00	MSFT	Stock	154.5	154.5	153.8	154.25	35269.0
2019-12-19 09:30:00	MSFT	Stock	154.22	154.78	153.75	154.505	1530494.0
2019-12-19 10:00:00	MSFT	Stock	154.51	154.694	154.34	154.62	874935.0
2019-12-19 10:30:00	MSFT	Stock	154.64	154.655	154.31	154.47	668746.0
2019-12-19 11:00:00	MSFT	Stock	154.47	154.815	154.38	154.773	715976.0
2019-12-19 11:30:00	MSFT	Stock	154.77	154.96	154.64	154.93	814367.0
2019-12-19 12:00:00	MSFT	Stock	154.925	155.14	154.92	155.082	748837.0
2019-12-19 12:30:00	MSFT	Stock	155.08	155.08	154.95	154.99	465592.0
2019-12-19 13:00:00	MSFT	Stock	154.98	155.21	154.9	155.195	707421.0
2019-12-19 13:30:00	MSFT	Stock	155.195	155.338	155.14	155.3	872001.0
2019-12-19 14:00:00	MSFT	Stock	155.3	155.53	155.28	155.505	1077168.0
2019-12-19 14:30:00	MSFT	Stock	155.5	155.75	155.48	155.63	1553716.0

> showing 50 of 86,233 rows — these rows as CSV

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