PREVIEW / stock_30min / 2019-03-06

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-03-06.parquet
  size:    1.7 MB
  rows:    84,995
  symbols: 2,642

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-03-06 04:30:00	AAPL	Stock	43.8175	43.825	43.8175	43.825	800.0
2019-03-06 06:30:00	AAPL	Stock	43.8	43.8	43.8	43.8	2000.0
2019-03-06 07:00:00	AAPL	Stock	43.8	43.815	43.7775	43.7775	20296.0
2019-03-06 07:30:00	AAPL	Stock	43.7625	43.7625	43.65	43.675	143548.0
2019-03-06 08:00:00	AAPL	Stock	43.6725	43.81	43.63	43.685	107780.0
2019-03-06 08:30:00	AAPL	Stock	43.6775	43.8	43.645	43.75	144152.0
2019-03-06 09:00:00	AAPL	Stock	43.7375	43.7625	43.65	43.6925	123796.0
2019-03-06 09:30:00	AAPL	Stock	43.6675	43.7575	43.485	43.7225	12698252.0
2019-03-06 10:00:00	AAPL	Stock	43.7238	43.8725	43.7025	43.7325	7408016.0
2019-03-06 10:30:00	AAPL	Stock	43.7275	43.8075	43.6675	43.7988	4034932.0
2019-03-06 11:00:00	AAPL	Stock	43.8025	43.8675	43.7125	43.735	4049464.0
2019-03-06 11:30:00	AAPL	Stock	43.735	43.765	43.6425	43.73	4518780.0
2019-03-06 12:00:00	AAPL	Stock	43.73	43.8	43.6775	43.7075	3388672.0
2019-03-06 12:30:00	AAPL	Stock	43.7075	43.77	43.655	43.6885	2692236.0
2019-03-06 13:00:00	AAPL	Stock	43.69	43.7125	43.62	43.6325	2803628.0
2019-03-06 13:30:00	AAPL	Stock	43.6325	43.7125	43.6225	43.6888	2790256.0
2019-03-06 14:00:00	AAPL	Stock	43.69	43.73	43.6725	43.6925	2467416.0
2019-03-06 14:30:00	AAPL	Stock	43.6932	43.7088	43.6375	43.67	3037244.0
2019-03-06 15:00:00	AAPL	Stock	43.6675	43.7075	43.59	43.635	4038536.0
2019-03-06 15:30:00	AAPL	Stock	43.635	43.7175	43.6125	43.6275	6959304.0
2019-03-06 16:00:00	AAPL	Stock	43.63	43.6625	43.59	43.63	11836780.0
2019-03-06 16:30:00	AAPL	Stock	43.635	43.635	43.59	43.625	11652.0
2019-03-06 17:00:00	AAPL	Stock	43.6225	43.6225	43.5875	43.59	17116.0
2019-03-06 17:30:00	AAPL	Stock	43.59	43.6225	43.59	43.6125	5932.0
2019-03-06 18:00:00	AAPL	Stock	43.6125	43.6125	43.5825	43.5825	11364.0
2019-03-06 18:30:00	AAPL	Stock	43.58	43.615	43.58	43.58	37720.0
2019-03-06 19:00:00	AAPL	Stock	43.59	43.59	43.555	43.5875	8768.0
2019-03-06 19:30:00	AAPL	Stock	43.565	43.5725	43.53	43.5625	12160.0
2019-03-06 04:00:00	MSFT	Stock	111.7	111.7	111.7	111.7	800.0
2019-03-06 06:00:00	MSFT	Stock	111.7	111.7	111.7	111.7	1008.0
2019-03-06 06:30:00	MSFT	Stock	111.8	111.8	111.8	111.8	2096.0
2019-03-06 07:00:00	MSFT	Stock	111.85	111.85	111.8	111.8	6599.0
2019-03-06 07:30:00	MSFT	Stock	111.73	111.75	111.65	111.66	24268.0
2019-03-06 08:00:00	MSFT	Stock	111.8	111.84	111.62	111.83	16410.0
2019-03-06 08:30:00	MSFT	Stock	111.7	112.0	111.7	111.86	17506.0
2019-03-06 09:00:00	MSFT	Stock	111.88	112.05	111.82	111.87	19494.0
2019-03-06 09:30:00	MSFT	Stock	111.87	112.61	111.8	112.54	2316094.0
2019-03-06 10:00:00	MSFT	Stock	112.545	112.66	112.035	112.05	1528655.0
2019-03-06 10:30:00	MSFT	Stock	112.055	112.12	111.765	112.02	988717.0
2019-03-06 11:00:00	MSFT	Stock	112.01	112.21	111.7	111.753	946620.0
2019-03-06 11:30:00	MSFT	Stock	111.755	111.81	111.43	111.74	853533.0
2019-03-06 12:00:00	MSFT	Stock	111.74	111.97	111.64	111.74	700030.0
2019-03-06 12:30:00	MSFT	Stock	111.74	111.96	111.63	111.75	624467.0
2019-03-06 13:00:00	MSFT	Stock	111.76	111.92	111.61	111.66	595180.0
2019-03-06 13:30:00	MSFT	Stock	111.66	111.96	111.65	111.846	570289.0
2019-03-06 14:00:00	MSFT	Stock	111.85	111.95	111.69	111.7	616295.0
2019-03-06 14:30:00	MSFT	Stock	111.703	111.89	111.58	111.83	662519.0
2019-03-06 15:00:00	MSFT	Stock	111.82	111.92	111.54	111.665	824308.0
2019-03-06 15:30:00	MSFT	Stock	111.66	112.0	111.621	111.74	2197688.0
2019-03-06 16:00:00	MSFT	Stock	111.75	111.88	111.67	111.75	1730687.0

> showing 50 of 84,995 rows — these rows as CSV

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