PREVIEW / stock_30min / 2021-12-17

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-12-17.parquet
  size:    2.2 MB
  rows:    111,674
  symbols: 2,646

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
2021-12-17 04:00:00	AAPL	Stock	171.66	171.66	170.03	170.92	45242.0
2021-12-17 04:30:00	AAPL	Stock	170.9	171.0	170.3	170.98	16024.0
2021-12-17 05:00:00	AAPL	Stock	170.96	170.97	170.33	170.4	10864.0
2021-12-17 05:30:00	AAPL	Stock	170.49	170.74	170.2	170.25	20432.0
2021-12-17 06:00:00	AAPL	Stock	170.3	171.0	170.3	170.92	18578.0
2021-12-17 06:30:00	AAPL	Stock	170.95	171.0	170.8	170.95	10081.0
2021-12-17 07:00:00	AAPL	Stock	171.0	171.0	169.67	169.67	195182.0
2021-12-17 07:30:00	AAPL	Stock	169.69	169.8	169.14	169.4	198605.0
2021-12-17 08:00:00	AAPL	Stock	170.6906	171.0	169.13	169.85	668455.0
2021-12-17 08:30:00	AAPL	Stock	169.85	170.44	169.67	170.39	275480.0
2021-12-17 09:00:00	AAPL	Stock	170.39	170.93	169.55	169.96	359550.0
2021-12-17 09:30:00	AAPL	Stock	169.93	173.07	169.69	171.9401	26246989.0
2021-12-17 10:00:00	AAPL	Stock	171.9401	171.96	169.76	170.36	9772058.0
2021-12-17 10:30:00	AAPL	Stock	170.34	172.81	170.06	172.52	9627235.0
2021-12-17 11:00:00	AAPL	Stock	172.51	173.47	171.91	173.135	6875073.0
2021-12-17 11:30:00	AAPL	Stock	173.12	173.24	170.3551	171.03	9178144.0
2021-12-17 12:00:00	AAPL	Stock	171.0	171.09	169.86	170.7458	6482611.0
2021-12-17 12:30:00	AAPL	Stock	170.73	171.32	170.2799	170.81	5671416.0
2021-12-17 13:00:00	AAPL	Stock	170.81	171.97	170.47	171.9	5692972.0
2021-12-17 13:30:00	AAPL	Stock	171.9082	172.47	171.15	172.4516	5600051.0
2021-12-17 14:00:00	AAPL	Stock	172.45	172.73	171.66	171.85	5548520.0
2021-12-17 14:30:00	AAPL	Stock	171.8428	173.09	171.75	172.33	5515006.0
2021-12-17 15:00:00	AAPL	Stock	172.32	172.8	171.585	171.735	5950053.0
2021-12-17 15:30:00	AAPL	Stock	171.73	171.84	170.5	170.97	12242593.0
2021-12-17 16:00:00	AAPL	Stock	171.14	171.54	171.1	171.35	51556789.0
2021-12-17 16:30:00	AAPL	Stock	171.39	171.5	171.14	171.49	47729.0
2021-12-17 17:00:00	AAPL	Stock	171.5	171.56	171.35	171.4	23362.0
2021-12-17 17:30:00	AAPL	Stock	171.39	171.5	171.35	171.37	21556.0
2021-12-17 18:00:00	AAPL	Stock	171.39	171.45	171.14	171.39	218014.0
2021-12-17 18:30:00	AAPL	Stock	171.37	171.55	171.14	171.46	62236.0
2021-12-17 19:00:00	AAPL	Stock	171.5	171.9	171.46	171.84	18632.0
2021-12-17 19:30:00	AAPL	Stock	171.8	172.26	171.7	171.89	151815.0
2021-12-17 04:00:00	MSFT	Stock	323.89	324.83	321.85	322.77	8928.0
2021-12-17 04:30:00	MSFT	Stock	322.39	322.86	322.14	322.86	1129.0
2021-12-17 05:00:00	MSFT	Stock	323.25	323.26	322.42	322.42	1225.0
2021-12-17 05:30:00	MSFT	Stock	322.53	322.53	321.7	321.71	6167.0
2021-12-17 06:00:00	MSFT	Stock	322.19	323.3	322.19	323.3	1487.0
2021-12-17 06:30:00	MSFT	Stock	323.47	323.75	323.08	323.08	1084.0
2021-12-17 07:00:00	MSFT	Stock	322.72	323.11	322.55	322.55	8459.0
2021-12-17 07:30:00	MSFT	Stock	322.39	322.39	320.81	321.62	13297.0
2021-12-17 08:00:00	MSFT	Stock	323.005	325.712	320.8	321.86	59778.0
2021-12-17 08:30:00	MSFT	Stock	321.92	322.25	321.1201	322.25	19935.0
2021-12-17 09:00:00	MSFT	Stock	322.35	322.47	320.49	320.85	70546.0
2021-12-17 09:30:00	MSFT	Stock	320.86	323.7042	319.06	321.34	7912088.0
2021-12-17 10:00:00	MSFT	Stock	321.31	321.31	317.25	319.07	1960657.0
2021-12-17 10:30:00	MSFT	Stock	319.06	322.63	318.67	322.44	1629021.0
2021-12-17 11:00:00	MSFT	Stock	322.47	323.815	321.7	323.085	1247144.0
2021-12-17 11:30:00	MSFT	Stock	323.07	323.38	319.93	320.895	1166736.0
2021-12-17 12:00:00	MSFT	Stock	320.87	321.98	319.62	321.75	881527.0
2021-12-17 12:30:00	MSFT	Stock	321.73	323.08	321.07	321.6413	975042.0

> showing 50 of 111,674 rows — these rows as CSV

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