PREVIEW / stock_30min / 2019-02-22

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-22.parquet
  size:    1.7 MB
  rows:    85,792
  symbols: 2,654

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-02-22 04:00:00	AAPL	Stock	42.9225	42.9225	42.9225	42.9225	400.0
2019-02-22 04:30:00	AAPL	Stock	42.9	42.9	42.9	42.9	3648.0
2019-02-22 05:00:00	AAPL	Stock	42.9	42.9	42.9	42.9	1596.0
2019-02-22 05:30:00	AAPL	Stock	42.9	42.925	42.88	42.925	1808.0
2019-02-22 06:00:00	AAPL	Stock	42.96	42.96	42.96	42.96	800.0
2019-02-22 06:30:00	AAPL	Stock	42.8925	43.0	42.8925	43.0	25144.0
2019-02-22 07:00:00	AAPL	Stock	42.975	43.0325	42.9725	43.0	14948.0
2019-02-22 07:30:00	AAPL	Stock	43.0	43.0	42.9425	42.9425	39084.0
2019-02-22 08:00:00	AAPL	Stock	43.0	43.0	42.875	42.9675	83460.0
2019-02-22 08:30:00	AAPL	Stock	42.955	42.9725	42.82	42.8525	124272.0
2019-02-22 09:00:00	AAPL	Stock	42.85	42.93	42.8375	42.8975	104148.0
2019-02-22 09:30:00	AAPL	Stock	42.9	43.085	42.845	43.0462	9063964.0
2019-02-22 10:00:00	AAPL	Stock	43.0462	43.0975	42.9198	42.9652	5696436.0
2019-02-22 10:30:00	AAPL	Stock	42.9675	43.155	42.9575	43.1525	4357720.0
2019-02-22 11:00:00	AAPL	Stock	43.1512	43.17	43.0975	43.1525	3746992.0
2019-02-22 11:30:00	AAPL	Stock	43.1538	43.155	43.0175	43.0612	3334052.0
2019-02-22 12:00:00	AAPL	Stock	43.06	43.095	43.0175	43.04	1991192.0
2019-02-22 12:30:00	AAPL	Stock	43.04	43.0775	43.01	43.055	1986196.0
2019-02-22 13:00:00	AAPL	Stock	43.0575	43.07	43.01	43.0675	2179316.0
2019-02-22 13:30:00	AAPL	Stock	43.0688	43.1125	43.0675	43.1125	2330532.0
2019-02-22 14:00:00	AAPL	Stock	43.1108	43.145	43.08	43.1025	2319260.0
2019-02-22 14:30:00	AAPL	Stock	43.105	43.134	42.9625	42.995	4583324.0
2019-02-22 15:00:00	AAPL	Stock	42.9925	43.1075	42.9725	43.09	2941796.0
2019-02-22 15:30:00	AAPL	Stock	43.0968	43.25	43.0575	43.2425	8760356.0
2019-02-22 16:00:00	AAPL	Stock	43.2475	43.27	43.0845	43.1875	11956868.0
2019-02-22 16:30:00	AAPL	Stock	43.1875	43.2425	43.1675	43.185	475620.0
2019-02-22 17:00:00	AAPL	Stock	43.185	43.2125	43.175	43.2125	63976.0
2019-02-22 17:30:00	AAPL	Stock	43.22	43.22	43.1875	43.1875	6492.0
2019-02-22 18:00:00	AAPL	Stock	43.2175	43.2175	43.19	43.21	15600.0
2019-02-22 18:30:00	AAPL	Stock	43.1925	43.205	43.1925	43.205	2000.0
2019-02-22 19:00:00	AAPL	Stock	43.205	43.205	43.19	43.2025	14620.0
2019-02-22 19:30:00	AAPL	Stock	43.2075	43.23	43.19	43.19	39832.0
2019-02-22 04:00:00	MSFT	Stock	109.41	109.68	109.41	109.68	4075.0
2019-02-22 04:30:00	MSFT	Stock	109.7	109.7	109.42	109.42	2800.0
2019-02-22 05:30:00	MSFT	Stock	109.55	109.66	109.5	109.66	1898.0
2019-02-22 06:00:00	MSFT	Stock	109.6	109.8	109.6	109.8	3341.0
2019-02-22 06:30:00	MSFT	Stock	109.79	109.93	109.79	109.93	2383.0
2019-02-22 07:00:00	MSFT	Stock	109.76	109.99	109.73	109.99	9611.0
2019-02-22 07:30:00	MSFT	Stock	109.88	109.99	109.77	109.9	7881.0
2019-02-22 08:00:00	MSFT	Stock	109.91	109.99	109.7	109.86	21132.0
2019-02-22 08:30:00	MSFT	Stock	109.83	109.898	109.63	109.73	12887.0
2019-02-22 09:00:00	MSFT	Stock	109.746	110.1	109.6	110.1	40251.0
2019-02-22 09:30:00	MSFT	Stock	110.05	110.82	109.82	110.82	3441926.0
2019-02-22 10:00:00	MSFT	Stock	110.82	110.93	110.48	110.74	2428317.0
2019-02-22 10:30:00	MSFT	Stock	110.74	111.1	110.605	110.86	1805471.0
2019-02-22 11:00:00	MSFT	Stock	110.855	111.18	110.67	111.11	1735022.0
2019-02-22 11:30:00	MSFT	Stock	111.11	111.2	110.985	111.06	1324452.0
2019-02-22 12:00:00	MSFT	Stock	111.06	111.07	110.79	110.82	778627.0
2019-02-22 12:30:00	MSFT	Stock	110.82	110.98	110.73	110.91	852823.0
2019-02-22 13:00:00	MSFT	Stock	110.91	110.93	110.74	110.835	843722.0

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

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