PREVIEW / stock_30min / 2020-05-29

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-05-29.parquet
  size:    1.9 MB
  rows:    95,161
  symbols: 2,383

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
2020-05-29 04:00:00	AAPL	Stock	79.5225	79.5225	79.315	79.3825	8020.0
2020-05-29 04:30:00	AAPL	Stock	79.375	79.63	79.375	79.525	6416.0
2020-05-29 05:00:00	AAPL	Stock	79.5475	79.5475	79.545	79.545	1200.0
2020-05-29 05:30:00	AAPL	Stock	79.6275	79.75	79.625	79.75	14908.0
2020-05-29 06:00:00	AAPL	Stock	79.7675	79.77	79.76	79.76	3348.0
2020-05-29 06:30:00	AAPL	Stock	79.825	79.925	79.825	79.925	15752.0
2020-05-29 07:00:00	AAPL	Stock	79.815	80.0	79.7275	79.965	87172.0
2020-05-29 07:30:00	AAPL	Stock	79.9625	80.2225	79.8125	80.175	103752.0
2020-05-29 08:00:00	AAPL	Stock	79.7875	80.3125	79.7262	80.065	214212.0
2020-05-29 08:30:00	AAPL	Stock	80.065	80.0875	79.8375	79.8752	145008.0
2020-05-29 09:00:00	AAPL	Stock	79.86	79.96	79.6725	79.875	297496.0
2020-05-29 09:30:00	AAPL	Stock	79.8475	80.0	79.5	79.595	11348228.0
2020-05-29 10:00:00	AAPL	Stock	79.585	79.6642	79.1175	79.485	8819116.0
2020-05-29 10:30:00	AAPL	Stock	79.485	79.695	79.3025	79.5188	5242012.0
2020-05-29 11:00:00	AAPL	Stock	79.52	79.6575	79.2425	79.58	5027144.0
2020-05-29 11:30:00	AAPL	Stock	79.5725	79.7905	79.4475	79.76	4886496.0
2020-05-29 12:00:00	AAPL	Stock	79.765	79.8875	79.5252	79.7125	5318608.0
2020-05-29 12:30:00	AAPL	Stock	79.7125	79.8775	79.2675	79.7725	5571736.0
2020-05-29 13:00:00	AAPL	Stock	79.765	79.895	79.6725	79.7415	3606572.0
2020-05-29 13:30:00	AAPL	Stock	79.745	79.79	79.5675	79.7125	2688896.0
2020-05-29 14:00:00	AAPL	Stock	79.7025	80.065	79.655	79.9822	7108480.0
2020-05-29 14:30:00	AAPL	Stock	79.9875	80.0	79.135	79.9415	9730520.0
2020-05-29 15:00:00	AAPL	Stock	79.9575	80.2875	79.9	80.135	11149620.0
2020-05-29 15:30:00	AAPL	Stock	80.13	80.2175	79.365	79.48	16356756.0
2020-05-29 16:00:00	AAPL	Stock	79.4775	79.7925	79.43	79.72	29109036.0
2020-05-29 16:30:00	AAPL	Stock	79.725	79.825	79.485	79.825	98652.0
2020-05-29 17:00:00	AAPL	Stock	79.825	79.87	79.78	79.79	59260.0
2020-05-29 17:30:00	AAPL	Stock	79.79	79.8	79.7725	79.7725	88520.0
2020-05-29 18:00:00	AAPL	Stock	79.755	79.755	79.715	79.725	47528.0
2020-05-29 18:30:00	AAPL	Stock	79.725	79.7375	79.725	79.725	13704.0
2020-05-29 19:00:00	AAPL	Stock	79.73	79.7625	79.715	79.7625	5960.0
2020-05-29 19:30:00	AAPL	Stock	79.755	79.775	79.725	79.75	17176.0
2020-05-29 04:00:00	MSFT	Stock	180.35	181.18	180.35	180.81	3859.0
2020-05-29 04:30:00	MSFT	Stock	180.75	180.97	180.72	180.97	1432.0
2020-05-29 05:00:00	MSFT	Stock	180.8	181.2	180.8	180.92	3944.0
2020-05-29 05:30:00	MSFT	Stock	181.2	181.2	181.2	181.2	103.0
2020-05-29 06:00:00	MSFT	Stock	181.62	181.65	181.62	181.65	308.0
2020-05-29 07:00:00	MSFT	Stock	181.35	182.18	181.35	182.18	7007.0
2020-05-29 07:30:00	MSFT	Stock	182.18	182.75	182.05	182.75	11444.0
2020-05-29 08:00:00	MSFT	Stock	182.0	183.26	181.52	182.7	24395.0
2020-05-29 08:30:00	MSFT	Stock	182.7	182.7	182.15	182.2	22105.0
2020-05-29 09:00:00	MSFT	Stock	182.2	183.0	182.12	182.89	29289.0
2020-05-29 09:30:00	MSFT	Stock	182.74	183.58	181.87	183.08	2917211.0
2020-05-29 10:00:00	MSFT	Stock	183.07	183.105	180.77	181.38	2264227.0
2020-05-29 10:30:00	MSFT	Stock	181.4	182.12	180.83	181.19	2132406.0
2020-05-29 11:00:00	MSFT	Stock	181.2	181.35	180.41	180.95	1843807.0
2020-05-29 11:30:00	MSFT	Stock	180.95	181.94	180.45	181.87	1553835.0
2020-05-29 12:00:00	MSFT	Stock	181.88	182.0	180.93	181.39	939518.0
2020-05-29 12:30:00	MSFT	Stock	181.38	182.43	180.43	182.07	1471087.0
2020-05-29 13:00:00	MSFT	Stock	182.12	182.36	181.67	181.95	970493.0

> showing 50 of 95,161 rows — these rows as CSV

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