PREVIEW / stock_30min / 2020-12-04

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-12-04.parquet
  size:    2.1 MB
  rows:    106,828
  symbols: 2,643

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-04 04:00:00	AAPL	Stock	123.3	123.31	123.18	123.2	8668.0
2020-12-04 04:30:00	AAPL	Stock	123.2	123.24	123.15	123.2	1000.0
2020-12-04 05:00:00	AAPL	Stock	123.23	123.23	123.14	123.2	11897.0
2020-12-04 05:30:00	AAPL	Stock	123.2	123.2	123.12	123.18	3037.0
2020-12-04 06:00:00	AAPL	Stock	123.2	123.28	123.16	123.28	3259.0
2020-12-04 06:30:00	AAPL	Stock	123.28	123.3	123.27	123.27	2470.0
2020-12-04 07:00:00	AAPL	Stock	123.25	123.28	123.13	123.22	47246.0
2020-12-04 07:30:00	AAPL	Stock	123.22	123.25	122.9	122.9	49526.0
2020-12-04 08:00:00	AAPL	Stock	123.268	123.28	122.896	123.06	127601.0
2020-12-04 08:30:00	AAPL	Stock	123.05	123.24	122.67	122.74	150407.0
2020-12-04 09:00:00	AAPL	Stock	122.75	122.79	122.55	122.55	150595.0
2020-12-04 09:30:00	AAPL	Stock	122.55	122.861	121.54	122.07	11230211.0
2020-12-04 10:00:00	AAPL	Stock	122.06	122.15	121.52	121.536	5395670.0
2020-12-04 10:30:00	AAPL	Stock	121.535	122.18	121.535	121.79	5166020.0
2020-12-04 11:00:00	AAPL	Stock	121.788	122.29	121.62	122.272	4083388.0
2020-12-04 11:30:00	AAPL	Stock	122.28	122.665	122.251	122.373	3989464.0
2020-12-04 12:00:00	AAPL	Stock	122.38	122.4	121.825	121.885	3820757.0
2020-12-04 12:30:00	AAPL	Stock	121.882	122.18	121.861	122.153	2504703.0
2020-12-04 13:00:00	AAPL	Stock	122.155	122.21	121.89	121.96	2198008.0
2020-12-04 13:30:00	AAPL	Stock	121.953	122.075	121.81	121.835	2122254.0
2020-12-04 14:00:00	AAPL	Stock	121.835	121.95	121.67	121.72	2895627.0
2020-12-04 14:30:00	AAPL	Stock	121.725	122.18	121.69	122.075	2930126.0
2020-12-04 15:00:00	AAPL	Stock	122.08	122.21	121.95	122.014	3399199.0
2020-12-04 15:30:00	AAPL	Stock	122.01	122.3	121.88	122.24	7175930.0
2020-12-04 16:00:00	AAPL	Stock	122.25	122.3	122.05	122.05	8580701.0
2020-12-04 16:30:00	AAPL	Stock	122.03	122.25	122.01	122.03	56174.0
2020-12-04 17:00:00	AAPL	Stock	122.02	122.25	122.0	122.02	79072.0
2020-12-04 17:30:00	AAPL	Stock	122.03	122.1	122.01	122.02	32823.0
2020-12-04 18:00:00	AAPL	Stock	122.05	122.07	122.02	122.02	25226.0
2020-12-04 18:30:00	AAPL	Stock	122.03	122.03	122.0	122.01	16865.0
2020-12-04 19:00:00	AAPL	Stock	122.01	122.1	122.0	122.1	24487.0
2020-12-04 19:30:00	AAPL	Stock	122.07	122.14	122.06	122.14	24336.0
2020-12-04 04:00:00	MSFT	Stock	214.7	215.19	214.7	215.19	759.0
2020-12-04 05:00:00	MSFT	Stock	215.08	215.13	215.0	215.0	1040.0
2020-12-04 05:30:00	MSFT	Stock	215.0	215.0	214.87	214.87	333.0
2020-12-04 07:00:00	MSFT	Stock	214.71	214.75	214.5	214.51	5423.0
2020-12-04 07:30:00	MSFT	Stock	214.55	214.6	214.41	214.41	4030.0
2020-12-04 08:00:00	MSFT	Stock	214.6	214.8	213.71	214.39	14101.0
2020-12-04 08:30:00	MSFT	Stock	214.36	214.6	214.0	214.38	19061.0
2020-12-04 09:00:00	MSFT	Stock	214.41	214.79	214.02	214.25	43790.0
2020-12-04 09:30:00	MSFT	Stock	214.22	215.31	213.92	214.795	1938818.0
2020-12-04 10:00:00	MSFT	Stock	214.78	215.38	214.11	214.19	1269806.0
2020-12-04 10:30:00	MSFT	Stock	214.19	215.075	214.08	214.89	1084821.0
2020-12-04 11:00:00	MSFT	Stock	214.89	215.01	214.12	214.27	957033.0
2020-12-04 11:30:00	MSFT	Stock	214.26	214.54	213.99	214.08	942050.0
2020-12-04 12:00:00	MSFT	Stock	214.09	214.26	213.92	214.08	955935.0
2020-12-04 12:30:00	MSFT	Stock	214.09	214.38	214.0	214.146	889267.0
2020-12-04 13:00:00	MSFT	Stock	214.142	214.29	213.88	213.975	760660.0
2020-12-04 13:30:00	MSFT	Stock	213.972	214.19	213.51	213.51	842993.0
2020-12-04 14:00:00	MSFT	Stock	213.51	213.59	213.18	213.27	1062424.0

> showing 50 of 106,828 rows — these rows as CSV

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