PREVIEW / stock_30min / 2020-07-21

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-21.parquet
  size:    2.0 MB
  rows:    98,894
  symbols: 2,454

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-07-21 04:00:00	AAPL	Stock	99.25	99.5	99.25	99.375	19480.0
2020-07-21 04:30:00	AAPL	Stock	99.4075	99.4075	99.2775	99.2775	18640.0
2020-07-21 05:00:00	AAPL	Stock	99.295	99.295	99.2475	99.2475	2380.0
2020-07-21 05:30:00	AAPL	Stock	99.2425	99.3225	99.2425	99.3225	3936.0
2020-07-21 06:00:00	AAPL	Stock	99.27	99.31	99.15	99.15	6144.0
2020-07-21 06:30:00	AAPL	Stock	99.15	99.2475	99.0875	99.225	24764.0
2020-07-21 07:00:00	AAPL	Stock	99.0775	99.2425	98.9475	99.075	190032.0
2020-07-21 07:30:00	AAPL	Stock	99.1375	99.1775	99.055	99.1375	103576.0
2020-07-21 08:00:00	AAPL	Stock	98.9875	99.2288	98.9338	99.0825	203480.0
2020-07-21 08:30:00	AAPL	Stock	99.0825	99.0972	98.91	98.9895	192016.0
2020-07-21 09:00:00	AAPL	Stock	98.95	99.2975	98.735	99.1975	517572.0
2020-07-21 09:30:00	AAPL	Stock	99.1725	99.25	98.1175	98.6125	13800244.0
2020-07-21 10:00:00	AAPL	Stock	98.6125	98.67	98.0375	98.1625	6350240.0
2020-07-21 10:30:00	AAPL	Stock	98.18	98.315	97.835	98.0952	5828440.0
2020-07-21 11:00:00	AAPL	Stock	98.0875	98.1555	97.6175	97.835	4428056.0
2020-07-21 11:30:00	AAPL	Stock	97.8388	97.98	97.3825	97.5725	4379328.0
2020-07-21 12:00:00	AAPL	Stock	97.5625	97.6525	97.345	97.62	5129592.0
2020-07-21 12:30:00	AAPL	Stock	97.6112	97.7125	97.3125	97.5775	3611652.0
2020-07-21 13:00:00	AAPL	Stock	97.573	97.6012	97.2775	97.5788	2851996.0
2020-07-21 13:30:00	AAPL	Stock	97.565	98.035	97.5525	97.9075	3686224.0
2020-07-21 14:00:00	AAPL	Stock	97.92	98.21	97.895	98.025	3629252.0
2020-07-21 14:30:00	AAPL	Stock	98.04	98.0488	97.7875	97.8925	2960844.0
2020-07-21 15:00:00	AAPL	Stock	97.8975	97.9275	97.2075	97.2875	5368684.0
2020-07-21 15:30:00	AAPL	Stock	97.3225	97.44	96.7425	97.0	10626060.0
2020-07-21 16:00:00	AAPL	Stock	97.0	97.125	97.0	97.0175	7773140.0
2020-07-21 16:30:00	AAPL	Stock	97.0625	97.1325	97.0	97.09	86280.0
2020-07-21 17:00:00	AAPL	Stock	97.115	97.1225	97.0	97.0625	67176.0
2020-07-21 17:30:00	AAPL	Stock	97.05	97.13	97.0	97.035	29368.0
2020-07-21 18:00:00	AAPL	Stock	97.05	97.14	97.0125	97.14	36476.0
2020-07-21 18:30:00	AAPL	Stock	97.13	97.25	97.125	97.225	65980.0
2020-07-21 19:00:00	AAPL	Stock	97.21	97.2425	97.1375	97.1625	22864.0
2020-07-21 19:30:00	AAPL	Stock	97.1625	97.25	97.15	97.175	39428.0
2020-07-21 04:00:00	MSFT	Stock	213.8	214.55	213.8	214.39	5484.0
2020-07-21 04:30:00	MSFT	Stock	214.44	214.5	214.2	214.22	5155.0
2020-07-21 05:00:00	MSFT	Stock	214.28	214.38	214.28	214.38	741.0
2020-07-21 05:30:00	MSFT	Stock	214.33	214.6	214.33	214.59	9759.0
2020-07-21 06:00:00	MSFT	Stock	214.5	214.72	214.5	214.7	6432.0
2020-07-21 06:30:00	MSFT	Stock	214.65	214.75	214.15	214.17	9575.0
2020-07-21 07:00:00	MSFT	Stock	214.37	214.55	213.6	213.78	78327.0
2020-07-21 07:30:00	MSFT	Stock	213.85	214.19	213.78	214.0	51397.0
2020-07-21 08:00:00	MSFT	Stock	214.2	214.46	212.12	213.85	104325.0
2020-07-21 08:30:00	MSFT	Stock	213.85	213.98	213.33	213.5	99285.0
2020-07-21 09:00:00	MSFT	Stock	213.375	213.99	212.17	213.99	231149.0
2020-07-21 09:30:00	MSFT	Stock	213.85	213.94	210.06	211.87	6176093.0
2020-07-21 10:00:00	MSFT	Stock	211.84	212.49	210.9	211.53	2297883.0
2020-07-21 10:30:00	MSFT	Stock	211.55	211.93	210.38	210.69	1808049.0
2020-07-21 11:00:00	MSFT	Stock	210.69	210.99	209.8	210.385	1662954.0
2020-07-21 11:30:00	MSFT	Stock	210.4	210.7	208.8	209.33	1761511.0
2020-07-21 12:00:00	MSFT	Stock	209.337	209.81	208.47	209.76	1408019.0
2020-07-21 12:30:00	MSFT	Stock	209.73	210.12	209.2	210.073	1104329.0

> showing 50 of 98,894 rows — these rows as CSV

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