PREVIEW / stock_30min / 2020-12-07

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-12-07.parquet
  size:    2.2 MB
  rows:    110,221
  symbols: 2,653

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-12-07 04:00:00	AAPL	Stock	122.0	122.0	121.2	121.5	28721.0
2020-12-07 04:30:00	AAPL	Stock	121.5	121.69	121.5	121.56	4548.0
2020-12-07 05:00:00	AAPL	Stock	121.51	121.88	121.51	121.82	11875.0
2020-12-07 05:30:00	AAPL	Stock	121.71	121.85	121.63	121.84	3145.0
2020-12-07 06:00:00	AAPL	Stock	121.84	122.4	121.84	122.26	24783.0
2020-12-07 06:30:00	AAPL	Stock	122.2	122.3	122.04	122.3	8070.0
2020-12-07 07:00:00	AAPL	Stock	122.2	122.47	122.05	122.12	44687.0
2020-12-07 07:30:00	AAPL	Stock	122.11	122.2	121.98	122.16	51197.0
2020-12-07 08:00:00	AAPL	Stock	122.13	122.42	121.966	122.25	179178.0
2020-12-07 08:30:00	AAPL	Stock	122.22	122.52	122.18	122.52	101835.0
2020-12-07 09:00:00	AAPL	Stock	122.55	123.0	122.25	122.38	363743.0
2020-12-07 09:30:00	AAPL	Stock	122.38	124.53	122.22	124.45	15626027.0
2020-12-07 10:00:00	AAPL	Stock	124.44	124.57	123.697	123.84	8088351.0
2020-12-07 10:30:00	AAPL	Stock	123.85	124.24	123.7	124.035	4697379.0
2020-12-07 11:00:00	AAPL	Stock	124.03	124.35	123.73	124.14	4491832.0
2020-12-07 11:30:00	AAPL	Stock	124.125	124.36	123.995	124.09	2992203.0
2020-12-07 12:00:00	AAPL	Stock	124.09	124.205	123.79	124.169	3663768.0
2020-12-07 12:30:00	AAPL	Stock	124.165	124.27	124.07	124.075	2743996.0
2020-12-07 13:00:00	AAPL	Stock	124.077	124.09	123.8	123.87	3209819.0
2020-12-07 13:30:00	AAPL	Stock	123.86	123.98	123.41	123.905	4048737.0
2020-12-07 14:00:00	AAPL	Stock	123.91	124.21	123.77	124.12	3225774.0
2020-12-07 14:30:00	AAPL	Stock	124.126	124.29	123.95	124.01	2726941.0
2020-12-07 15:00:00	AAPL	Stock	124.028	124.05	123.595	123.825	3584326.0
2020-12-07 15:30:00	AAPL	Stock	123.828	123.9	123.3	123.8	5812269.0
2020-12-07 16:00:00	AAPL	Stock	123.75	123.84	123.57	123.77	9885505.0
2020-12-07 16:30:00	AAPL	Stock	123.77	123.8	123.51	123.57	72590.0
2020-12-07 17:00:00	AAPL	Stock	123.6	123.67	123.55	123.56	29855.0
2020-12-07 17:30:00	AAPL	Stock	123.56	123.71	123.55	123.6	33430.0
2020-12-07 18:00:00	AAPL	Stock	123.64	123.66	123.56	123.6	31600.0
2020-12-07 18:30:00	AAPL	Stock	123.62	123.65	123.56	123.6	14069.0
2020-12-07 19:00:00	AAPL	Stock	123.61	123.63	123.51	123.54	28309.0
2020-12-07 19:30:00	AAPL	Stock	123.55	123.66	123.5	123.52	43916.0
2020-12-07 04:00:00	MSFT	Stock	214.1	214.62	214.01	214.6	9110.0
2020-12-07 04:30:00	MSFT	Stock	214.61	215.2	214.61	215.02	2807.0
2020-12-07 05:00:00	MSFT	Stock	214.98	216.25	214.98	216.25	13944.0
2020-12-07 05:30:00	MSFT	Stock	216.4	216.4	216.13	216.2	6807.0
2020-12-07 06:00:00	MSFT	Stock	216.13	216.13	216.0	216.05	3151.0
2020-12-07 06:30:00	MSFT	Stock	216.0	216.15	216.0	216.0	1847.0
2020-12-07 07:00:00	MSFT	Stock	215.65	215.74	215.04	215.06	35992.0
2020-12-07 07:30:00	MSFT	Stock	215.09	215.09	214.8	214.95	9023.0
2020-12-07 08:00:00	MSFT	Stock	214.95	215.2	214.63	214.78	17884.0
2020-12-07 08:30:00	MSFT	Stock	214.651	214.8	214.54	214.8	12889.0
2020-12-07 09:00:00	MSFT	Stock	214.67	214.78	214.41	214.41	21558.0
2020-12-07 09:30:00	MSFT	Stock	214.41	215.54	214.12	215.08	2246527.0
2020-12-07 10:00:00	MSFT	Stock	215.08	215.29	213.8	214.43	1557411.0
2020-12-07 10:30:00	MSFT	Stock	214.42	214.69	213.77	213.795	1127753.0
2020-12-07 11:00:00	MSFT	Stock	213.79	214.285	213.72	214.09	757023.0
2020-12-07 11:30:00	MSFT	Stock	214.09	214.12	213.75	213.83	824819.0
2020-12-07 12:00:00	MSFT	Stock	213.82	213.88	213.4	213.86	821323.0
2020-12-07 12:30:00	MSFT	Stock	213.86	214.08	213.623	213.685	727240.0

> showing 50 of 110,221 rows — these rows as CSV

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