PREVIEW / stock_30min / 2020-12-08

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-12-08.parquet
  size:    2.1 MB
  rows:    108,600
  symbols: 2,657

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-08 04:00:00	AAPL	Stock	123.65	123.88	123.56	123.59	4770.0
2020-12-08 04:30:00	AAPL	Stock	123.58	123.59	123.45	123.49	5542.0
2020-12-08 05:00:00	AAPL	Stock	123.51	123.54	123.3	123.33	10485.0
2020-12-08 05:30:00	AAPL	Stock	123.4	123.59	123.4	123.54	3755.0
2020-12-08 06:00:00	AAPL	Stock	123.58	123.6	123.28	123.58	6147.0
2020-12-08 06:30:00	AAPL	Stock	123.6	123.6	123.0	123.0	13422.0
2020-12-08 07:00:00	AAPL	Stock	122.99	123.39	122.99	123.33	45505.0
2020-12-08 07:30:00	AAPL	Stock	123.32	123.4	123.2	123.4	37080.0
2020-12-08 08:00:00	AAPL	Stock	123.339	123.57	123.0	123.47	151157.0
2020-12-08 08:30:00	AAPL	Stock	123.5	124.96	123.47	124.56	942143.0
2020-12-08 09:00:00	AAPL	Stock	124.56	124.69	124.23	124.35	305546.0
2020-12-08 09:30:00	AAPL	Stock	124.37	124.57	123.45	123.89	11053313.0
2020-12-08 10:00:00	AAPL	Stock	123.89	124.22	123.231	123.326	7344098.0
2020-12-08 10:30:00	AAPL	Stock	123.34	123.46	123.09	123.339	4007444.0
2020-12-08 11:00:00	AAPL	Stock	123.335	123.54	123.17	123.485	3376562.0
2020-12-08 11:30:00	AAPL	Stock	123.49	123.92	123.445	123.89	3322570.0
2020-12-08 12:00:00	AAPL	Stock	123.885	124.15	123.855	124.068	3443529.0
2020-12-08 12:30:00	AAPL	Stock	124.06	124.405	124.035	124.296	3103804.0
2020-12-08 13:00:00	AAPL	Stock	124.295	124.83	124.23	124.7	4709538.0
2020-12-08 13:30:00	AAPL	Stock	124.705	124.87	124.45	124.76	4037730.0
2020-12-08 14:00:00	AAPL	Stock	124.761	124.85	124.39	124.78	4195129.0
2020-12-08 14:30:00	AAPL	Stock	124.778	124.96	124.67	124.95	3758256.0
2020-12-08 15:00:00	AAPL	Stock	124.96	124.98	124.7	124.83	3441021.0
2020-12-08 15:30:00	AAPL	Stock	124.835	124.9	124.325	124.33	6433598.0
2020-12-08 16:00:00	AAPL	Stock	124.37	124.4	124.23	124.23	6573434.0
2020-12-08 16:30:00	AAPL	Stock	124.23	124.4	124.21	124.33	66214.0
2020-12-08 17:00:00	AAPL	Stock	124.3	124.33	124.29	124.3	19111.0
2020-12-08 17:30:00	AAPL	Stock	124.32	124.33	124.21	124.32	49978.0
2020-12-08 18:00:00	AAPL	Stock	124.33	124.56	124.31	124.38	58438.0
2020-12-08 18:30:00	AAPL	Stock	124.35	124.35	124.16	124.2	64094.0
2020-12-08 19:00:00	AAPL	Stock	124.19	124.5	124.19	124.34	50599.0
2020-12-08 19:30:00	AAPL	Stock	124.35	124.48	124.2	124.28	78130.0
2020-12-08 04:00:00	MSFT	Stock	214.5	214.5	214.3	214.3	5742.0
2020-12-08 04:30:00	MSFT	Stock	214.3	214.3	214.04	214.18	400.0
2020-12-08 05:00:00	MSFT	Stock	214.15	214.15	214.15	214.15	200.0
2020-12-08 05:30:00	MSFT	Stock	214.3	214.36	214.3	214.36	483.0
2020-12-08 06:00:00	MSFT	Stock	214.11	214.24	214.0	214.0	1379.0
2020-12-08 06:30:00	MSFT	Stock	214.14	214.2	213.78	213.78	4889.0
2020-12-08 07:00:00	MSFT	Stock	213.78	213.78	213.58	213.68	2540.0
2020-12-08 07:30:00	MSFT	Stock	213.64	213.75	213.34	213.47	3964.0
2020-12-08 08:00:00	MSFT	Stock	213.567	213.78	213.41	213.61	16725.0
2020-12-08 08:30:00	MSFT	Stock	213.61	213.75	213.5	213.62	17548.0
2020-12-08 09:00:00	MSFT	Stock	213.654	214.21	213.52	214.07	26934.0
2020-12-08 09:30:00	MSFT	Stock	214.11	214.99	212.89	213.53	2319009.0
2020-12-08 10:00:00	MSFT	Stock	213.51	214.48	213.26	213.822	1440328.0
2020-12-08 10:30:00	MSFT	Stock	213.802	214.965	213.67	214.82	1184028.0
2020-12-08 11:00:00	MSFT	Stock	214.814	215.15	214.48	214.88	1155382.0
2020-12-08 11:30:00	MSFT	Stock	214.9	216.03	214.83	215.96	1224320.0
2020-12-08 12:00:00	MSFT	Stock	215.97	216.36	215.8	216.25	1020293.0
2020-12-08 12:30:00	MSFT	Stock	216.27	216.3	215.86	216.18	692873.0

> showing 50 of 108,600 rows — these rows as CSV

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