PREVIEW / stock_30min / 2019-12-31

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-31.parquet
  size:    1.8 MB
  rows:    86,291
  symbols: 2,494

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-31 04:00:00	AAPL	Stock	72.85	72.85	72.85	72.85	800.0
2019-12-31 04:30:00	AAPL	Stock	72.75	72.75	72.75	72.75	400.0
2019-12-31 05:00:00	AAPL	Stock	72.8225	72.8225	72.8225	72.8225	2000.0
2019-12-31 05:30:00	AAPL	Stock	72.8225	72.85	72.8225	72.85	1200.0
2019-12-31 06:00:00	AAPL	Stock	72.825	72.825	72.825	72.825	400.0
2019-12-31 06:30:00	AAPL	Stock	72.75	72.75	72.75	72.75	800.0
2019-12-31 07:00:00	AAPL	Stock	72.8125	72.825	72.625	72.6775	61576.0
2019-12-31 07:30:00	AAPL	Stock	72.7	72.745	72.6375	72.675	53512.0
2019-12-31 08:00:00	AAPL	Stock	72.8	72.8125	72.6275	72.6975	125332.0
2019-12-31 08:30:00	AAPL	Stock	72.7125	72.7175	72.52	72.575	122104.0
2019-12-31 09:00:00	AAPL	Stock	72.575	72.6125	72.4125	72.485	341948.0
2019-12-31 09:30:00	AAPL	Stock	72.4825	73.22	72.38	73.04	13295776.0
2019-12-31 10:00:00	AAPL	Stock	73.045	73.075	72.67	72.7975	7948120.0
2019-12-31 10:30:00	AAPL	Stock	72.805	72.94	72.695	72.7675	5232988.0
2019-12-31 11:00:00	AAPL	Stock	72.7662	73.065	72.745	72.9625	5745748.0
2019-12-31 11:30:00	AAPL	Stock	72.9625	73.0575	72.85	73.01	3967000.0
2019-12-31 12:00:00	AAPL	Stock	73.0125	73.0675	72.9325	73.065	2991484.0
2019-12-31 12:30:00	AAPL	Stock	73.07	73.1175	73.0125	73.015	3230728.0
2019-12-31 13:00:00	AAPL	Stock	73.01	73.075	72.97	73.0225	2816300.0
2019-12-31 13:30:00	AAPL	Stock	73.0225	73.0675	72.9975	73.0515	2151700.0
2019-12-31 14:00:00	AAPL	Stock	73.0525	73.075	72.9975	73.0675	2600340.0
2019-12-31 14:30:00	AAPL	Stock	73.0665	73.1175	73.0325	73.09	3282944.0
2019-12-31 15:00:00	AAPL	Stock	73.0875	73.315	73.065	73.2925	7702988.0
2019-12-31 15:30:00	AAPL	Stock	73.295	73.42	73.23	73.3425	13154264.0
2019-12-31 16:00:00	AAPL	Stock	73.3	73.4725	73.3	73.455	11352300.0
2019-12-31 16:30:00	AAPL	Stock	73.4475	73.46	73.425	73.455	122220.0
2019-12-31 17:00:00	AAPL	Stock	73.4425	73.46	73.44	73.44	43596.0
2019-12-31 17:30:00	AAPL	Stock	73.44	73.445	73.425	73.425	75648.0
2019-12-31 18:00:00	AAPL	Stock	73.425	73.45	73.425	73.45	25196.0
2019-12-31 18:30:00	AAPL	Stock	73.45	73.46	73.45	73.4525	30928.0
2019-12-31 19:00:00	AAPL	Stock	73.44	73.4575	73.275	73.4375	71056.0
2019-12-31 19:30:00	AAPL	Stock	73.4275	73.4475	73.41	73.42	57460.0
2019-12-31 07:00:00	MSFT	Stock	157.5	157.5	157.25	157.25	500.0
2019-12-31 07:30:00	MSFT	Stock	157.27	157.34	157.27	157.34	400.0
2019-12-31 08:00:00	MSFT	Stock	157.27	157.7	157.21	157.26	3315.0
2019-12-31 08:30:00	MSFT	Stock	157.28	157.34	156.9	156.9	16640.0
2019-12-31 09:00:00	MSFT	Stock	157.0	157.1	156.83	156.83	17698.0
2019-12-31 09:30:00	MSFT	Stock	156.85	157.63	156.49	157.25	1440058.0
2019-12-31 10:00:00	MSFT	Stock	157.25	157.36	156.875	156.88	763122.0
2019-12-31 10:30:00	MSFT	Stock	156.885	156.99	156.68	156.85	653395.0
2019-12-31 11:00:00	MSFT	Stock	156.85	157.02	156.57	156.578	639801.0
2019-12-31 11:30:00	MSFT	Stock	156.575	157.02	156.45	156.883	888721.0
2019-12-31 12:00:00	MSFT	Stock	156.89	157.0	156.68	156.86	477721.0
2019-12-31 12:30:00	MSFT	Stock	156.865	156.95	156.84	156.9	306980.0
2019-12-31 13:00:00	MSFT	Stock	156.905	156.96	156.821	156.877	305396.0
2019-12-31 13:30:00	MSFT	Stock	156.88	157.02	156.85	156.993	348141.0
2019-12-31 14:00:00	MSFT	Stock	156.995	157.09	156.76	157.09	456193.0
2019-12-31 14:30:00	MSFT	Stock	157.095	157.32	157.05	157.284	496262.0
2019-12-31 15:00:00	MSFT	Stock	157.28	157.405	157.18	157.255	825869.0
2019-12-31 15:30:00	MSFT	Stock	157.265	157.77	157.22	157.49	2646202.0

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

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