PREVIEW / stock_30min / 2021-03-17

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-03-17.parquet
  size:    2.3 MB
  rows:    117,706
  symbols: 2,904

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-03-17 04:00:00	AAPL	Stock	125.0	125.53	124.84	124.9	9554.0
2021-03-17 04:30:00	AAPL	Stock	124.98	125.19	124.98	125.12	7951.0
2021-03-17 05:00:00	AAPL	Stock	125.05	125.12	125.01	125.12	5782.0
2021-03-17 05:30:00	AAPL	Stock	125.12	125.12	124.63	124.63	8820.0
2021-03-17 06:00:00	AAPL	Stock	124.75	124.91	124.6	124.7	13471.0
2021-03-17 06:30:00	AAPL	Stock	124.68	124.92	124.62	124.62	5986.0
2021-03-17 07:00:00	AAPL	Stock	124.66	124.84	124.05	124.13	153132.0
2021-03-17 07:30:00	AAPL	Stock	124.15	124.15	123.52	123.8	213236.0
2021-03-17 08:00:00	AAPL	Stock	124.6201	125.883	123.54	123.846	357425.0
2021-03-17 08:30:00	AAPL	Stock	123.86	124.15	123.6	124.15	197684.0
2021-03-17 09:00:00	AAPL	Stock	124.15	125.6265	123.83	124.06	208964.0
2021-03-17 09:30:00	AAPL	Stock	124.07	124.21	122.82	123.2793	13709357.0
2021-03-17 10:00:00	AAPL	Stock	123.28	123.6299	122.79	123.46	7146950.0
2021-03-17 10:30:00	AAPL	Stock	123.45	123.5798	122.835	123.04	5003660.0
2021-03-17 11:00:00	AAPL	Stock	123.04	123.058	122.585	122.903	5791961.0
2021-03-17 11:30:00	AAPL	Stock	122.905	122.97	122.47	122.66	5069539.0
2021-03-17 12:00:00	AAPL	Stock	122.665	122.9	122.39	122.815	4181388.0
2021-03-17 12:30:00	AAPL	Stock	122.8199	122.82	122.44	122.4708	3371261.0
2021-03-17 13:00:00	AAPL	Stock	122.47	122.93	122.336	122.74	3541265.0
2021-03-17 13:30:00	AAPL	Stock	122.7499	122.85	122.58	122.8264	2635198.0
2021-03-17 14:00:00	AAPL	Stock	122.83	124.49	122.83	123.8782	11131285.0
2021-03-17 14:30:00	AAPL	Stock	123.88	125.39	123.5835	125.365	9641912.0
2021-03-17 15:00:00	AAPL	Stock	125.36	125.8599	124.915	125.0801	7601574.0
2021-03-17 15:30:00	AAPL	Stock	125.09	125.41	124.29	124.8	9317612.0
2021-03-17 16:00:00	AAPL	Stock	124.78	124.81	124.57	124.74	8103536.0
2021-03-17 16:30:00	AAPL	Stock	124.74	124.74	124.47	124.5	57906.0
2021-03-17 17:00:00	AAPL	Stock	124.5	124.68	124.48	124.66	39901.0
2021-03-17 17:30:00	AAPL	Stock	124.6601	124.75	124.6	124.73	43896.0
2021-03-17 18:00:00	AAPL	Stock	124.73	124.85	124.73	124.81	79754.0
2021-03-17 18:30:00	AAPL	Stock	124.8	124.86	124.65	124.72	44764.0
2021-03-17 19:00:00	AAPL	Stock	124.72	124.78	124.67	124.78	25609.0
2021-03-17 19:30:00	AAPL	Stock	124.8	124.95	124.8	124.95	79813.0
2021-03-17 04:00:00	MSFT	Stock	237.69	237.71	237.4	237.4	947.0
2021-03-17 05:00:00	MSFT	Stock	237.46	237.46	237.46	237.46	108.0
2021-03-17 05:30:00	MSFT	Stock	237.3	237.3	237.24	237.3	3261.0
2021-03-17 06:30:00	MSFT	Stock	237.0	237.1	237.0	237.1	241.0
2021-03-17 07:00:00	MSFT	Stock	237.38	237.4	236.43	236.5	18311.0
2021-03-17 07:30:00	MSFT	Stock	236.49	236.49	235.67	236.16	17031.0
2021-03-17 08:00:00	MSFT	Stock	236.85	237.5	235.61	236.07	19695.0
2021-03-17 08:30:00	MSFT	Stock	236.06	236.3	235.59	236.3	12076.0
2021-03-17 09:00:00	MSFT	Stock	236.3	237.603	235.91	236.34	5481.0
2021-03-17 09:30:00	MSFT	Stock	236.19	236.49	234.17	236.15	2104939.0
2021-03-17 10:00:00	MSFT	Stock	236.165	236.59	235.64	235.87	889988.0
2021-03-17 10:30:00	MSFT	Stock	235.85	236.34	234.82	234.99	1121651.0
2021-03-17 11:00:00	MSFT	Stock	234.98	235.03	234.39	234.75	911369.0
2021-03-17 11:30:00	MSFT	Stock	234.73	234.73	233.74	233.825	957588.0
2021-03-17 12:00:00	MSFT	Stock	233.81	234.6	233.23	234.56	1145006.0
2021-03-17 12:30:00	MSFT	Stock	234.55	234.55	233.73	233.79	787277.0
2021-03-17 13:00:00	MSFT	Stock	233.77	234.7279	233.62	234.59	901053.0
2021-03-17 13:30:00	MSFT	Stock	234.6	234.77	234.25	234.4573	776551.0

> showing 50 of 117,706 rows — these rows as CSV

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