PREVIEW / stock_30min / 2019-07-01

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-01.parquet
  size:    1.8 MB
  rows:    89,066
  symbols: 2,604

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-07-01 04:00:00	AAPL	Stock	50.37	50.9225	50.37	50.875	86364.0
2019-07-01 04:30:00	AAPL	Stock	50.8825	50.8825	50.7825	50.7825	28836.0
2019-07-01 05:00:00	AAPL	Stock	50.83	50.8425	50.785	50.7925	10248.0
2019-07-01 05:30:00	AAPL	Stock	50.7875	50.8475	50.7875	50.805	25640.0
2019-07-01 06:00:00	AAPL	Stock	50.78	50.9375	50.755	50.9375	27356.0
2019-07-01 06:30:00	AAPL	Stock	50.9375	50.9375	50.8125	50.87	34636.0
2019-07-01 07:00:00	AAPL	Stock	50.8475	50.865	50.6025	50.775	298660.0
2019-07-01 07:30:00	AAPL	Stock	50.78	50.875	50.73	50.8375	271448.0
2019-07-01 08:00:00	AAPL	Stock	50.7925	50.8875	50.593	50.775	740064.0
2019-07-01 08:30:00	AAPL	Stock	50.7775	50.7775	50.6875	50.755	206672.0
2019-07-01 09:00:00	AAPL	Stock	50.77	50.9025	50.7625	50.7925	379948.0
2019-07-01 09:30:00	AAPL	Stock	50.82	51.1225	50.675	50.8625	20425192.0
2019-07-01 10:00:00	AAPL	Stock	50.8625	51.0	50.5935	50.6605	9392508.0
2019-07-01 10:30:00	AAPL	Stock	50.6625	50.755	50.6325	50.7355	5438668.0
2019-07-01 11:00:00	AAPL	Stock	50.7375	50.7825	50.575	50.585	3930232.0
2019-07-01 11:30:00	AAPL	Stock	50.5875	50.6775	50.525	50.5575	3724224.0
2019-07-01 12:00:00	AAPL	Stock	50.555	50.575	50.415	50.4605	3560684.0
2019-07-01 12:30:00	AAPL	Stock	50.46	50.5	50.235	50.28	3788692.0
2019-07-01 13:00:00	AAPL	Stock	50.28	50.38	50.2112	50.3775	4247832.0
2019-07-01 13:30:00	AAPL	Stock	50.375	50.4425	50.3308	50.3725	3586860.0
2019-07-01 14:00:00	AAPL	Stock	50.3738	50.38	50.2025	50.2025	3012920.0
2019-07-01 14:30:00	AAPL	Stock	50.205	50.2775	50.1625	50.1815	4005652.0
2019-07-01 15:00:00	AAPL	Stock	50.1818	50.385	50.1675	50.3675	4006484.0
2019-07-01 15:30:00	AAPL	Stock	50.37	50.4825	50.3	50.42	9233156.0
2019-07-01 16:00:00	AAPL	Stock	50.4025	50.4025	50.21	50.3875	7577108.0
2019-07-01 16:30:00	AAPL	Stock	50.35	50.3625	50.3325	50.3425	54228.0
2019-07-01 17:00:00	AAPL	Stock	50.3375	50.3475	50.2875	50.3375	53508.0
2019-07-01 17:30:00	AAPL	Stock	50.335	50.3475	50.3125	50.3475	11672.0
2019-07-01 18:00:00	AAPL	Stock	50.3475	50.365	50.2875	50.2875	44048.0
2019-07-01 18:30:00	AAPL	Stock	50.34	50.345	50.305	50.305	102480.0
2019-07-01 19:00:00	AAPL	Stock	50.3	50.3125	50.29	50.3125	9516.0
2019-07-01 19:30:00	AAPL	Stock	50.3125	50.3325	50.2925	50.3125	38932.0
2019-07-01 04:00:00	MSFT	Stock	135.5	136.5	135.5	136.38	5133.0
2019-07-01 04:30:00	MSFT	Stock	136.38	136.49	136.38	136.38	2844.0
2019-07-01 05:00:00	MSFT	Stock	136.3	136.3	136.24	136.24	740.0
2019-07-01 05:30:00	MSFT	Stock	136.34	136.35	136.34	136.35	8980.0
2019-07-01 06:00:00	MSFT	Stock	136.28	136.35	136.28	136.35	2752.0
2019-07-01 06:30:00	MSFT	Stock	136.35	136.35	135.36	136.28	2835.0
2019-07-01 07:00:00	MSFT	Stock	136.2	136.2	135.95	135.95	7444.0
2019-07-01 07:30:00	MSFT	Stock	136.06	136.18	135.99	136.02	10593.0
2019-07-01 08:00:00	MSFT	Stock	136.25	136.3	134.29	135.9	59864.0
2019-07-01 08:30:00	MSFT	Stock	135.81	135.9	133.96	135.89	29077.0
2019-07-01 09:00:00	MSFT	Stock	135.88	136.77	135.72	136.41	99226.0
2019-07-01 09:30:00	MSFT	Stock	136.63	136.7	135.7	136.0	3110954.0
2019-07-01 10:00:00	MSFT	Stock	136.0	136.34	135.87	135.9	1487482.0
2019-07-01 10:30:00	MSFT	Stock	135.91	136.075	135.72	135.89	1079557.0
2019-07-01 11:00:00	MSFT	Stock	135.89	136.13	135.75	135.855	1036339.0
2019-07-01 11:30:00	MSFT	Stock	135.86	136.19	135.86	135.98	729304.0
2019-07-01 12:00:00	MSFT	Stock	135.985	136.11	135.55	135.71	800302.0
2019-07-01 12:30:00	MSFT	Stock	135.71	135.72	135.24	135.29	718922.0

> showing 50 of 89,066 rows — these rows as CSV

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