PREVIEW / stock_30min / 2020-12-09

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-12-09.parquet
  size:    2.2 MB
  rows:    108,895
  symbols: 2,669

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-09 04:00:00	AAPL	Stock	124.8	124.8	124.01	124.17	10159.0
2020-12-09 04:30:00	AAPL	Stock	124.1	124.21	124.07	124.12	3812.0
2020-12-09 05:00:00	AAPL	Stock	124.14	124.37	124.01	124.15	11075.0
2020-12-09 05:30:00	AAPL	Stock	124.17	124.3	124.15	124.3	4223.0
2020-12-09 06:00:00	AAPL	Stock	124.33	124.33	124.21	124.25	5453.0
2020-12-09 06:30:00	AAPL	Stock	124.25	124.28	124.13	124.16	6642.0
2020-12-09 07:00:00	AAPL	Stock	124.21	124.47	124.14	124.39	78537.0
2020-12-09 07:30:00	AAPL	Stock	124.4	124.84	124.4	124.83	199035.0
2020-12-09 08:00:00	AAPL	Stock	124.34	124.92	124.17	124.91	248151.0
2020-12-09 08:30:00	AAPL	Stock	124.91	124.93	124.75	124.85	183829.0
2020-12-09 09:00:00	AAPL	Stock	124.84	124.89	124.5	124.53	238654.0
2020-12-09 09:30:00	AAPL	Stock	124.51	125.95	123.86	125.86	15415614.0
2020-12-09 10:00:00	AAPL	Stock	125.865	125.9	124.59	125.09	8210043.0
2020-12-09 10:30:00	AAPL	Stock	125.1	125.47	124.8	125.41	4849106.0
2020-12-09 11:00:00	AAPL	Stock	125.4	125.44	124.84	125.23	4343663.0
2020-12-09 11:30:00	AAPL	Stock	125.23	125.29	124.67	124.895	3339210.0
2020-12-09 12:00:00	AAPL	Stock	124.891	124.92	124.11	124.375	4058037.0
2020-12-09 12:30:00	AAPL	Stock	124.375	124.379	122.83	123.648	6957348.0
2020-12-09 13:00:00	AAPL	Stock	123.64	123.71	122.63	122.79	5635452.0
2020-12-09 13:30:00	AAPL	Stock	122.781	122.79	121.61	121.64	7917269.0
2020-12-09 14:00:00	AAPL	Stock	121.66	122.23	121.66	122.21	5167246.0
2020-12-09 14:30:00	AAPL	Stock	122.21	122.25	121.0	121.63	5731469.0
2020-12-09 15:00:00	AAPL	Stock	121.62	122.01	121.07	121.26	5896040.0
2020-12-09 15:30:00	AAPL	Stock	121.25	122.21	121.21	121.67	10049729.0
2020-12-09 16:00:00	AAPL	Stock	121.78	122.799	121.51	121.62	13200374.0
2020-12-09 16:30:00	AAPL	Stock	121.62	121.78	121.36	121.49	141767.0
2020-12-09 17:00:00	AAPL	Stock	121.49	121.52	121.31	121.35	37055.0
2020-12-09 17:30:00	AAPL	Stock	121.35	121.41	120.9	120.93	164137.0
2020-12-09 18:00:00	AAPL	Stock	120.93	121.44	120.92	121.37	67704.0
2020-12-09 18:30:00	AAPL	Stock	121.36	121.49	121.31	121.39	77837.0
2020-12-09 19:00:00	AAPL	Stock	121.36	121.5	121.36	121.47	44886.0
2020-12-09 19:30:00	AAPL	Stock	121.44	121.47	121.15	121.16	89960.0
2020-12-09 04:00:00	MSFT	Stock	216.48	216.69	215.54	215.69	3715.0
2020-12-09 04:30:00	MSFT	Stock	215.68	215.76	215.68	215.76	262.0
2020-12-09 05:00:00	MSFT	Stock	215.85	215.91	215.42	215.42	2264.0
2020-12-09 05:30:00	MSFT	Stock	215.42	215.42	215.4	215.4	974.0
2020-12-09 07:00:00	MSFT	Stock	215.76	215.76	215.4	215.4	5525.0
2020-12-09 07:30:00	MSFT	Stock	215.41	215.51	215.27	215.3	8829.0
2020-12-09 08:00:00	MSFT	Stock	215.78	215.78	215.24	215.35	19827.0
2020-12-09 08:30:00	MSFT	Stock	215.34	215.442	215.25	215.43	13334.0
2020-12-09 09:00:00	MSFT	Stock	215.45	215.79	215.15	215.22	29287.0
2020-12-09 09:30:00	MSFT	Stock	215.22	215.225	214.09	214.21	2950325.0
2020-12-09 10:00:00	MSFT	Stock	214.19	214.23	213.18	213.95	2429400.0
2020-12-09 10:30:00	MSFT	Stock	213.97	214.69	213.68	214.58	1317540.0
2020-12-09 11:00:00	MSFT	Stock	214.59	214.7	213.93	214.66	1008104.0
2020-12-09 11:30:00	MSFT	Stock	214.66	214.7	213.97	214.267	687208.0
2020-12-09 12:00:00	MSFT	Stock	214.26	214.265	213.62	213.99	789299.0
2020-12-09 12:30:00	MSFT	Stock	213.991	213.991	213.06	213.39	1201554.0
2020-12-09 13:00:00	MSFT	Stock	213.35	213.64	212.58	212.75	1285280.0
2020-12-09 13:30:00	MSFT	Stock	212.74	213.0	212.185	212.29	1213904.0

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

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