PREVIEW / stock_30min / 2019-12-23

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-23.parquet
  size:    1.8 MB
  rows:    86,451
  symbols: 2,463

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-23 04:00:00	AAPL	Stock	69.955	70.075	69.955	70.075	5604.0
2019-12-23 04:30:00	AAPL	Stock	70.075	70.075	70.0625	70.0625	800.0
2019-12-23 05:00:00	AAPL	Stock	70.0625	70.065	70.0625	70.0625	4112.0
2019-12-23 05:30:00	AAPL	Stock	70.0625	70.07	70.0625	70.0625	5600.0
2019-12-23 06:00:00	AAPL	Stock	70.06	70.1325	70.06	70.125	13648.0
2019-12-23 06:30:00	AAPL	Stock	70.06	70.0675	70.06	70.0625	9592.0
2019-12-23 07:00:00	AAPL	Stock	70.0675	70.15	70.03	70.1125	122696.0
2019-12-23 07:30:00	AAPL	Stock	70.11	70.1125	70.0625	70.075	49836.0
2019-12-23 08:00:00	AAPL	Stock	70.05	70.15	70.025	70.1125	211744.0
2019-12-23 08:30:00	AAPL	Stock	70.1175	70.2425	70.0875	70.1725	335644.0
2019-12-23 09:00:00	AAPL	Stock	70.1725	70.2375	69.86	70.16	376224.0
2019-12-23 09:30:00	AAPL	Stock	70.145	70.605	70.0935	70.5025	14593264.0
2019-12-23 10:00:00	AAPL	Stock	70.5075	70.6575	70.45	70.5968	6360740.0
2019-12-23 10:30:00	AAPL	Stock	70.5962	70.7395	70.57	70.6725	5450008.0
2019-12-23 11:00:00	AAPL	Stock	70.6725	70.94	70.6725	70.855	6675280.0
2019-12-23 11:30:00	AAPL	Stock	70.8575	70.91	70.8025	70.87	3624284.0
2019-12-23 12:00:00	AAPL	Stock	70.8712	71.015	70.845	70.9225	4357540.0
2019-12-23 12:30:00	AAPL	Stock	70.923	70.9675	70.8525	70.8875	2879028.0
2019-12-23 13:00:00	AAPL	Stock	70.8842	70.985	70.8625	70.965	2253532.0
2019-12-23 13:30:00	AAPL	Stock	70.9638	70.9925	70.895	70.9175	1887232.0
2019-12-23 14:00:00	AAPL	Stock	70.9205	71.055	70.9025	71.007	2979156.0
2019-12-23 14:30:00	AAPL	Stock	71.005	71.0325	70.9875	71.02	1832272.0
2019-12-23 15:00:00	AAPL	Stock	71.02	71.0625	70.9725	70.9925	3064680.0
2019-12-23 15:30:00	AAPL	Stock	70.9932	71.0375	70.8875	70.9925	6734596.0
2019-12-23 16:00:00	AAPL	Stock	71.0	71.05	70.995	71.0225	18617848.0
2019-12-23 16:30:00	AAPL	Stock	71.035	71.05	71.0	71.05	173184.0
2019-12-23 17:00:00	AAPL	Stock	71.0475	71.1125	71.0375	71.1125	74060.0
2019-12-23 17:30:00	AAPL	Stock	71.1125	71.1525	71.09	71.14	113076.0
2019-12-23 18:00:00	AAPL	Stock	71.1375	71.1675	71.12	71.12	43992.0
2019-12-23 18:30:00	AAPL	Stock	71.1125	71.125	71.0975	71.1125	12836.0
2019-12-23 19:00:00	AAPL	Stock	71.1025	71.14	71.1025	71.11	25820.0
2019-12-23 19:30:00	AAPL	Stock	71.11	71.14	71.105	71.14	55808.0
2019-12-23 04:00:00	MSFT	Stock	157.79	157.79	157.79	157.79	200.0
2019-12-23 04:30:00	MSFT	Stock	157.98	157.98	157.92	157.92	814.0
2019-12-23 05:00:00	MSFT	Stock	157.92	158.0	157.92	157.95	1792.0
2019-12-23 05:30:00	MSFT	Stock	157.92	158.0	157.92	157.96	1858.0
2019-12-23 06:30:00	MSFT	Stock	158.0	158.0	157.89	157.95	1400.0
2019-12-23 07:00:00	MSFT	Stock	157.95	158.07	157.89	157.96	5086.0
2019-12-23 07:30:00	MSFT	Stock	158.05	158.11	158.01	158.05	6483.0
2019-12-23 08:00:00	MSFT	Stock	157.96	158.11	157.41	158.02	54182.0
2019-12-23 08:30:00	MSFT	Stock	158.04	158.09	157.95	157.95	17925.0
2019-12-23 09:00:00	MSFT	Stock	158.0	158.02	157.41	157.85	25233.0
2019-12-23 09:30:00	MSFT	Stock	158.0	158.12	157.54	157.66	1802287.0
2019-12-23 10:00:00	MSFT	Stock	157.67	157.7	157.32	157.32	956105.0
2019-12-23 10:30:00	MSFT	Stock	157.32	157.8	157.32	157.8	814244.0
2019-12-23 11:00:00	MSFT	Stock	157.792	157.81	157.47	157.48	614538.0
2019-12-23 11:30:00	MSFT	Stock	157.48	157.695	157.48	157.65	538494.0
2019-12-23 12:00:00	MSFT	Stock	157.66	157.68	157.525	157.55	598787.0
2019-12-23 12:30:00	MSFT	Stock	157.545	157.61	157.485	157.505	540432.0
2019-12-23 13:00:00	MSFT	Stock	157.5	157.64	157.46	157.525	394943.0

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

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