PREVIEW / stock_30min / 2019-12-12

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-12.parquet
  size:    1.8 MB
  rows:    86,843
  symbols: 2,506

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-12 04:00:00	AAPL	Stock	67.8525	67.8725	67.7275	67.7275	20456.0
2019-12-12 04:30:00	AAPL	Stock	67.7425	67.7425	67.6725	67.725	27312.0
2019-12-12 05:00:00	AAPL	Stock	67.6625	67.72	67.535	67.57	41456.0
2019-12-12 05:30:00	AAPL	Stock	67.5925	67.5925	67.4375	67.4375	23060.0
2019-12-12 06:00:00	AAPL	Stock	67.4375	67.6	67.4375	67.5625	38028.0
2019-12-12 06:30:00	AAPL	Stock	67.53	67.535	67.445	67.535	38964.0
2019-12-12 07:00:00	AAPL	Stock	67.545	67.5675	67.375	67.4375	165056.0
2019-12-12 07:30:00	AAPL	Stock	67.45	67.495	67.0625	67.105	290552.0
2019-12-12 08:00:00	AAPL	Stock	67.1625	67.55	66.925	67.085	728308.0
2019-12-12 08:30:00	AAPL	Stock	67.075	67.115	66.9175	66.9525	505184.0
2019-12-12 09:00:00	AAPL	Stock	66.9625	66.975	66.75	66.955	791120.0
2019-12-12 09:30:00	AAPL	Stock	66.955	67.7825	66.8303	67.675	22311400.0
2019-12-12 10:00:00	AAPL	Stock	67.685	68.14	67.6825	67.89	13620748.0
2019-12-12 10:30:00	AAPL	Stock	67.8962	67.9625	67.525	67.76	8223644.0
2019-12-12 11:00:00	AAPL	Stock	67.75	67.78	67.265	67.2775	6752076.0
2019-12-12 11:30:00	AAPL	Stock	67.275	67.4	67.0025	67.0875	9012824.0
2019-12-12 12:00:00	AAPL	Stock	67.075	67.1	66.855	67.03	7271464.0
2019-12-12 12:30:00	AAPL	Stock	67.035	67.41	67.03	67.335	5582592.0
2019-12-12 13:00:00	AAPL	Stock	67.33	67.5902	67.32	67.5158	4507024.0
2019-12-12 13:30:00	AAPL	Stock	67.5155	67.5475	67.385	67.5325	3065936.0
2019-12-12 14:00:00	AAPL	Stock	67.5335	67.54	67.31	67.4125	3114228.0
2019-12-12 14:30:00	AAPL	Stock	67.42	67.7812	67.375	67.5492	7430100.0
2019-12-12 15:00:00	AAPL	Stock	67.555	67.7315	67.4975	67.7075	4378336.0
2019-12-12 15:30:00	AAPL	Stock	67.7075	67.925	67.6825	67.865	12529908.0
2019-12-12 16:00:00	AAPL	Stock	67.865	67.865	67.7875	67.85	9993464.0
2019-12-12 16:30:00	AAPL	Stock	67.8525	67.9875	67.85	67.9225	99532.0
2019-12-12 17:00:00	AAPL	Stock	67.9175	68.0625	67.9175	68.025	97600.0
2019-12-12 17:30:00	AAPL	Stock	68.025	68.035	68.005	68.0125	42144.0
2019-12-12 18:00:00	AAPL	Stock	68.01	68.125	68.01	68.1125	96636.0
2019-12-12 18:30:00	AAPL	Stock	68.1	68.235	68.1	68.235	118776.0
2019-12-12 19:00:00	AAPL	Stock	68.215	68.2375	68.125	68.2125	98024.0
2019-12-12 19:30:00	AAPL	Stock	68.205	68.25	68.17	68.24	108828.0
2019-12-12 04:00:00	MSFT	Stock	151.9	152.14	151.9	152.07	500.0
2019-12-12 05:00:00	MSFT	Stock	152.21	152.21	152.02	152.02	600.0
2019-12-12 05:30:00	MSFT	Stock	151.99	152.19	151.92	151.92	896.0
2019-12-12 06:00:00	MSFT	Stock	151.99	151.99	151.99	151.99	475.0
2019-12-12 06:30:00	MSFT	Stock	152.0	152.0	152.0	152.0	600.0
2019-12-12 07:00:00	MSFT	Stock	152.0	152.13	151.87	151.99	6156.0
2019-12-12 07:30:00	MSFT	Stock	152.0	152.0	151.85	151.95	15828.0
2019-12-12 08:00:00	MSFT	Stock	151.86	152.1	151.54	151.81	26022.0
2019-12-12 08:30:00	MSFT	Stock	151.67	151.91	151.39	151.88	22527.0
2019-12-12 09:00:00	MSFT	Stock	151.88	151.91	151.6	151.68	20216.0
2019-12-12 09:30:00	MSFT	Stock	151.75	152.94	151.02	152.87	2970413.0
2019-12-12 10:00:00	MSFT	Stock	152.87	153.42	152.67	153.34	2101570.0
2019-12-12 10:30:00	MSFT	Stock	153.35	153.38	152.77	153.095	1298673.0
2019-12-12 11:00:00	MSFT	Stock	153.1	153.14	152.055	152.08	1069479.0
2019-12-12 11:30:00	MSFT	Stock	152.09	152.426	151.88	152.17	895244.0
2019-12-12 12:00:00	MSFT	Stock	152.14	152.185	151.47	151.61	888552.0
2019-12-12 12:30:00	MSFT	Stock	151.62	152.05	151.6	151.74	856796.0
2019-12-12 13:00:00	MSFT	Stock	151.74	152.21	151.71	152.08	711859.0

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

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