PREVIEW / stock_30min / 2021-06-17

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-17.parquet
  size:    2.2 MB
  rows:    111,144
  symbols: 2,953

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-06-17 04:00:00	AAPL	Stock	129.1	129.25	128.98	129.04	26102.0
2021-06-17 04:30:00	AAPL	Stock	129.11	129.12	128.9	128.96	6613.0
2021-06-17 05:00:00	AAPL	Stock	128.92	129.24	128.92	129.24	3634.0
2021-06-17 05:30:00	AAPL	Stock	129.35	129.4	129.26	129.34	6474.0
2021-06-17 06:00:00	AAPL	Stock	129.37	129.5	129.33	129.34	4944.0
2021-06-17 06:30:00	AAPL	Stock	129.3	129.3	129.15	129.29	4274.0
2021-06-17 07:00:00	AAPL	Stock	129.26	129.75	129.1	129.6	108810.0
2021-06-17 07:30:00	AAPL	Stock	129.6	129.7	129.33	129.37	67575.0
2021-06-17 08:00:00	AAPL	Stock	129.3701	129.74	129.24	129.32	187126.0
2021-06-17 08:30:00	AAPL	Stock	129.34	129.64	129.34	129.5	130497.0
2021-06-17 09:00:00	AAPL	Stock	129.5	129.92	129.43	129.81	229190.0
2021-06-17 09:30:00	AAPL	Stock	129.8	130.87	129.65	130.79	9104597.0
2021-06-17 10:00:00	AAPL	Stock	130.8	131.768	130.63	131.735	7887096.0
2021-06-17 10:30:00	AAPL	Stock	131.74	131.915	131.31	131.49	7238402.0
2021-06-17 11:00:00	AAPL	Stock	131.48	132.04	131.4	131.9999	6181477.0
2021-06-17 11:30:00	AAPL	Stock	131.995	132.55	131.87	131.9382	6685766.0
2021-06-17 12:00:00	AAPL	Stock	131.94	131.99	130.95	131.11	6688183.0
2021-06-17 12:30:00	AAPL	Stock	131.11	131.66	130.95	131.2631	5365043.0
2021-06-17 13:00:00	AAPL	Stock	131.265	131.91	131.245	131.9	3441169.0
2021-06-17 13:30:00	AAPL	Stock	131.9	132.13	131.7	131.715	3682162.0
2021-06-17 14:00:00	AAPL	Stock	131.72	132.11	131.6	132.0901	3236298.0
2021-06-17 14:30:00	AAPL	Stock	132.095	132.15	131.81	131.96	2922506.0
2021-06-17 15:00:00	AAPL	Stock	131.96	132.255	131.86	132.145	3714439.0
2021-06-17 15:30:00	AAPL	Stock	132.14	132.21	131.74	131.78	8103735.0
2021-06-17 16:00:00	AAPL	Stock	131.79	131.87	130.8	131.75	11009322.0
2021-06-17 16:30:00	AAPL	Stock	131.75	131.95	131.67	131.9	58924.0
2021-06-17 17:00:00	AAPL	Stock	131.88	131.9	131.8	131.83	12463.0
2021-06-17 17:30:00	AAPL	Stock	131.87	131.87	131.81	131.86	7304.0
2021-06-17 18:00:00	AAPL	Stock	131.87	131.95	131.82	131.905	24851.0
2021-06-17 18:30:00	AAPL	Stock	131.9299	132.01	131.9001	132.01	13880.0
2021-06-17 19:00:00	AAPL	Stock	132.075	132.075	131.88	131.94	14626.0
2021-06-17 19:30:00	AAPL	Stock	131.98	132.09	131.96	132.04	30227.0
2021-06-17 04:00:00	MSFT	Stock	255.0	256.0	255.0	255.63	2089.0
2021-06-17 04:30:00	MSFT	Stock	255.68	255.68	255.32	255.32	843.0
2021-06-17 05:00:00	MSFT	Stock	255.21	255.52	255.21	255.52	1200.0
2021-06-17 05:30:00	MSFT	Stock	255.5	255.5	255.41	255.41	625.0
2021-06-17 06:00:00	MSFT	Stock	255.84	256.2	255.84	256.2	1170.0
2021-06-17 06:30:00	MSFT	Stock	256.08	256.08	255.85	255.85	904.0
2021-06-17 07:00:00	MSFT	Stock	255.8	256.7	255.8	256.48	10599.0
2021-06-17 07:30:00	MSFT	Stock	256.59	256.59	255.89	255.89	6721.0
2021-06-17 08:00:00	MSFT	Stock	256.5101	256.737	255.47	255.61	27181.0
2021-06-17 08:30:00	MSFT	Stock	255.86	256.23	255.86	256.0	10353.0
2021-06-17 09:00:00	MSFT	Stock	256.19	256.8	255.64	256.11	28648.0
2021-06-17 09:30:00	MSFT	Stock	256.15	257.97	256.01	257.805	1796960.0
2021-06-17 10:00:00	MSFT	Stock	257.82	258.5	257.52	258.4	1482067.0
2021-06-17 10:30:00	MSFT	Stock	258.43	259.17	258.14	258.27	1386887.0
2021-06-17 11:00:00	MSFT	Stock	258.3	260.14	258.23	260.03	1426878.0
2021-06-17 11:30:00	MSFT	Stock	260.03	260.62	259.89	260.51	1389684.0
2021-06-17 12:00:00	MSFT	Stock	260.52	260.6	259.42	259.65	1182285.0
2021-06-17 12:30:00	MSFT	Stock	259.64	260.38	259.36	260.22	866807.0

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

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