PREVIEW / stock_30min / 2019-12-10

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-12-10.parquet
  size:    1.7 MB
  rows:    85,362
  symbols: 2,490

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-10 04:00:00	AAPL	Stock	66.4375	66.4375	66.3	66.3175	8880.0
2019-12-10 04:30:00	AAPL	Stock	66.3125	66.3625	66.1775	66.2825	25740.0
2019-12-10 05:00:00	AAPL	Stock	66.3225	66.375	66.26	66.375	8660.0
2019-12-10 05:30:00	AAPL	Stock	66.3425	66.3425	66.2625	66.295	7892.0
2019-12-10 06:00:00	AAPL	Stock	66.2975	66.3075	66.0625	66.0625	15572.0
2019-12-10 06:30:00	AAPL	Stock	66.025	66.27	66.02	66.225	24684.0
2019-12-10 07:00:00	AAPL	Stock	66.2475	66.2675	66.125	66.2225	143736.0
2019-12-10 07:30:00	AAPL	Stock	66.2175	66.2175	66.1	66.16	64076.0
2019-12-10 08:00:00	AAPL	Stock	66.1632	66.45	66.0925	66.4125	320776.0
2019-12-10 08:30:00	AAPL	Stock	66.425	67.31	66.33	67.1625	1933288.0
2019-12-10 09:00:00	AAPL	Stock	67.1725	67.2075	67.0525	67.15	396420.0
2019-12-10 09:30:00	AAPL	Stock	67.15	67.1675	66.465	66.71	10709240.0
2019-12-10 10:00:00	AAPL	Stock	66.7162	67.4438	66.71	67.4325	10987744.0
2019-12-10 10:30:00	AAPL	Stock	67.435	67.485	67.275	67.4525	7099856.0
2019-12-10 11:00:00	AAPL	Stock	67.4575	67.5175	67.2125	67.3375	8003480.0
2019-12-10 11:30:00	AAPL	Stock	67.3375	67.425	67.25	67.2765	3709228.0
2019-12-10 12:00:00	AAPL	Stock	67.2775	67.305	67.14	67.1625	3192720.0
2019-12-10 12:30:00	AAPL	Stock	67.1625	67.2825	67.1475	67.2628	2730468.0
2019-12-10 13:00:00	AAPL	Stock	67.2625	67.425	67.2538	67.34	3039840.0
2019-12-10 13:30:00	AAPL	Stock	67.345	67.3525	67.2375	67.2625	2059292.0
2019-12-10 14:00:00	AAPL	Stock	67.265	67.365	67.265	67.3475	2592592.0
2019-12-10 14:30:00	AAPL	Stock	67.345	67.3925	67.2725	67.3358	2416608.0
2019-12-10 15:00:00	AAPL	Stock	67.3375	67.4375	67.295	67.3238	3111892.0
2019-12-10 15:30:00	AAPL	Stock	67.3225	67.3325	66.9325	67.155	10432068.0
2019-12-10 16:00:00	AAPL	Stock	67.12	67.1875	67.1025	67.1625	4914980.0
2019-12-10 16:30:00	AAPL	Stock	67.1625	67.1875	67.12	67.1875	69572.0
2019-12-10 17:00:00	AAPL	Stock	67.185	67.2	67.12	67.1875	16972.0
2019-12-10 17:30:00	AAPL	Stock	67.2025	67.2025	67.17	67.2	15812.0
2019-12-10 18:00:00	AAPL	Stock	67.2	67.2	67.17	67.175	29972.0
2019-12-10 18:30:00	AAPL	Stock	67.175	67.215	67.1625	67.1875	33352.0
2019-12-10 19:00:00	AAPL	Stock	67.1625	67.2	67.1625	67.1875	7808.0
2019-12-10 19:30:00	AAPL	Stock	67.175	67.19	67.04	67.125	40064.0
2019-12-10 04:00:00	MSFT	Stock	150.92	150.92	150.62	150.62	1200.0
2019-12-10 04:30:00	MSFT	Stock	150.72	150.72	150.72	150.72	112.0
2019-12-10 05:00:00	MSFT	Stock	150.7	150.75	150.7	150.75	600.0
2019-12-10 06:00:00	MSFT	Stock	150.8	150.8	150.5	150.5	2359.0
2019-12-10 06:30:00	MSFT	Stock	150.49	150.71	150.49	150.7	3592.0
2019-12-10 07:00:00	MSFT	Stock	150.71	150.85	150.5	150.67	8807.0
2019-12-10 07:30:00	MSFT	Stock	150.63	150.65	150.6	150.65	1469.0
2019-12-10 08:00:00	MSFT	Stock	150.604	151.09	150.5	151.0	24203.0
2019-12-10 08:30:00	MSFT	Stock	150.7	151.72	150.7	151.301	42891.0
2019-12-10 09:00:00	MSFT	Stock	151.4	151.5	151.0	151.0	19760.0
2019-12-10 09:30:00	MSFT	Stock	151.15	151.48	150.89	151.27	1842227.0
2019-12-10 10:00:00	MSFT	Stock	151.27	151.82	151.195	151.775	1033232.0
2019-12-10 10:30:00	MSFT	Stock	151.78	151.89	151.526	151.657	925523.0
2019-12-10 11:00:00	MSFT	Stock	151.66	151.87	151.13	151.69	1208051.0
2019-12-10 11:30:00	MSFT	Stock	151.695	151.795	151.61	151.715	602912.0
2019-12-10 12:00:00	MSFT	Stock	151.718	151.718	151.35	151.41	658056.0
2019-12-10 12:30:00	MSFT	Stock	151.4	151.51	151.275	151.43	536552.0
2019-12-10 13:00:00	MSFT	Stock	151.425	151.6	151.4	151.47	448349.0

> showing 50 of 85,362 rows — these rows as CSV

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