PREVIEW / stock_30min / 2020-12-15

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-12-15.parquet
  size:    2.2 MB
  rows:    108,732
  symbols: 2,687

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-15 04:00:00	AAPL	Stock	122.65	123.0	122.0	122.54	24045.0
2020-12-15 04:30:00	AAPL	Stock	122.54	123.09	122.54	123.01	9826.0
2020-12-15 05:00:00	AAPL	Stock	123.0	123.0	122.4	122.4	9235.0
2020-12-15 05:30:00	AAPL	Stock	122.4	123.18	122.16	123.18	34343.0
2020-12-15 06:00:00	AAPL	Stock	123.12	123.35	123.0	123.27	23807.0
2020-12-15 06:30:00	AAPL	Stock	123.22	123.22	122.4	123.03	60496.0
2020-12-15 07:00:00	AAPL	Stock	123.01	123.45	122.87	123.42	288124.0
2020-12-15 07:30:00	AAPL	Stock	123.42	124.2	123.25	123.91	320764.0
2020-12-15 08:00:00	AAPL	Stock	123.14	124.2	122.88	124.024	513688.0
2020-12-15 08:30:00	AAPL	Stock	124.01	124.2	123.86	123.98	392026.0
2020-12-15 09:00:00	AAPL	Stock	123.99	124.5	123.8	124.42	587655.0
2020-12-15 09:30:00	AAPL	Stock	124.43	126.96	124.13	126.49	28542084.0
2020-12-15 10:00:00	AAPL	Stock	126.485	126.58	125.45	125.74	10747160.0
2020-12-15 10:30:00	AAPL	Stock	125.74	126.14	125.27	125.945	8062213.0
2020-12-15 11:00:00	AAPL	Stock	125.93	125.947	125.13	125.833	6340804.0
2020-12-15 11:30:00	AAPL	Stock	125.83	126.24	125.57	125.955	5765788.0
2020-12-15 12:00:00	AAPL	Stock	125.955	126.42	125.9	126.37	6930426.0
2020-12-15 12:30:00	AAPL	Stock	126.372	126.8	126.24	126.55	9407478.0
2020-12-15 13:00:00	AAPL	Stock	126.55	126.95	126.3	126.851	6426544.0
2020-12-15 13:30:00	AAPL	Stock	126.859	126.98	126.5	126.72	5071510.0
2020-12-15 14:00:00	AAPL	Stock	126.72	127.3	126.481	127.172	8279413.0
2020-12-15 14:30:00	AAPL	Stock	127.16	127.5	127.16	127.23	7227529.0
2020-12-15 15:00:00	AAPL	Stock	127.225	127.64	127.03	127.61	7297542.0
2020-12-15 15:30:00	AAPL	Stock	127.608	127.9	127.26	127.89	11564821.0
2020-12-15 16:00:00	AAPL	Stock	127.88	128.0	127.7	127.8	12261473.0
2020-12-15 16:30:00	AAPL	Stock	127.8	127.85	127.66	127.7	101312.0
2020-12-15 17:00:00	AAPL	Stock	127.68	127.95	127.62	127.7	112501.0
2020-12-15 17:30:00	AAPL	Stock	127.7	127.7	127.31	127.64	137433.0
2020-12-15 18:00:00	AAPL	Stock	127.66	127.93	127.65	127.85	142722.0
2020-12-15 18:30:00	AAPL	Stock	127.87	127.87	127.77	127.85	63734.0
2020-12-15 19:00:00	AAPL	Stock	127.86	127.97	127.7	127.75	71408.0
2020-12-15 19:30:00	AAPL	Stock	127.72	127.8	127.57	127.57	70466.0
2020-12-15 04:00:00	MSFT	Stock	215.0	215.2	214.9	215.2	300.0
2020-12-15 04:30:00	MSFT	Stock	215.3	215.3	214.8	214.8	477.0
2020-12-15 05:30:00	MSFT	Stock	215.18	215.18	215.18	215.18	1000.0
2020-12-15 06:30:00	MSFT	Stock	214.33	214.49	213.52	214.16	4424.0
2020-12-15 07:00:00	MSFT	Stock	214.35	214.88	214.16	214.88	13697.0
2020-12-15 07:30:00	MSFT	Stock	214.9	215.13	214.41	214.7	16036.0
2020-12-15 08:00:00	MSFT	Stock	214.214	215.033	213.67	214.81	18157.0
2020-12-15 08:30:00	MSFT	Stock	214.794	214.99	214.72	214.99	9257.0
2020-12-15 09:00:00	MSFT	Stock	215.0	215.36	214.99	215.36	13439.0
2020-12-15 09:30:00	MSFT	Stock	215.17	215.42	213.58	213.635	2218484.0
2020-12-15 10:00:00	MSFT	Stock	213.655	214.2	213.41	213.67	1386520.0
2020-12-15 10:30:00	MSFT	Stock	213.677	213.68	212.76	212.89	1805876.0
2020-12-15 11:00:00	MSFT	Stock	212.882	213.03	212.24	212.99	1434697.0
2020-12-15 11:30:00	MSFT	Stock	212.98	212.99	212.4	212.8	819815.0
2020-12-15 12:00:00	MSFT	Stock	212.81	213.26	212.69	212.97	921734.0
2020-12-15 12:30:00	MSFT	Stock	212.975	213.46	212.895	213.4	842041.0
2020-12-15 13:00:00	MSFT	Stock	213.39	213.77	213.14	213.195	789111.0
2020-12-15 13:30:00	MSFT	Stock	213.2	213.33	212.91	213.113	1511755.0

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

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