PREVIEW / stock_30min / 2020-09-24

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-24.parquet
  size:    1.9 MB
  rows:    97,810
  symbols: 2,496

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-09-24 04:00:00	AAPL	Stock	106.5	106.85	105.82	106.49	40170.0
2020-09-24 04:30:00	AAPL	Stock	106.44	106.6	106.04	106.31	17887.0
2020-09-24 05:00:00	AAPL	Stock	106.25	106.28	105.9	106.25	13765.0
2020-09-24 05:30:00	AAPL	Stock	106.23	106.3	105.93	106.09	9687.0
2020-09-24 06:00:00	AAPL	Stock	106.19	106.79	106.19	106.54	20213.0
2020-09-24 06:30:00	AAPL	Stock	106.54	107.01	106.36	106.55	26030.0
2020-09-24 07:00:00	AAPL	Stock	106.53	106.68	106.2	106.49	136576.0
2020-09-24 07:30:00	AAPL	Stock	106.52	106.63	105.83	105.91	184476.0
2020-09-24 08:00:00	AAPL	Stock	106.431	106.6	105.53	105.739	557065.0
2020-09-24 08:30:00	AAPL	Stock	105.74	105.75	105.0	105.31	670420.0
2020-09-24 09:00:00	AAPL	Stock	105.31	105.72	104.8	105.18	767053.0
2020-09-24 09:30:00	AAPL	Stock	105.19	108.97	105.0	108.71	23058394.0
2020-09-24 10:00:00	AAPL	Stock	108.72	109.3	108.1	108.22	14509215.0
2020-09-24 10:30:00	AAPL	Stock	108.21	109.25	107.61	109.16	12129549.0
2020-09-24 11:00:00	AAPL	Stock	109.16	109.59	108.22	109.34	9826999.0
2020-09-24 11:30:00	AAPL	Stock	109.345	110.05	109.21	109.57	9052161.0
2020-09-24 12:00:00	AAPL	Stock	109.57	110.25	109.16	109.58	8564578.0
2020-09-24 12:30:00	AAPL	Stock	109.595	109.62	108.67	109.57	7491900.0
2020-09-24 13:00:00	AAPL	Stock	109.56	109.89	109.35	109.761	6277255.0
2020-09-24 13:30:00	AAPL	Stock	109.77	110.2	109.38	109.48	7831808.0
2020-09-24 14:00:00	AAPL	Stock	109.48	109.72	108.78	108.931	7519431.0
2020-09-24 14:30:00	AAPL	Stock	108.938	109.375	108.07	108.11	7997419.0
2020-09-24 15:00:00	AAPL	Stock	108.11	108.88	107.59	107.926	10396099.0
2020-09-24 15:30:00	AAPL	Stock	107.93	108.99	107.53	108.202	13617865.0
2020-09-24 16:00:00	AAPL	Stock	108.2	109.4	108.0	108.35	8705783.0
2020-09-24 16:30:00	AAPL	Stock	108.36	108.77	108.22	108.68	200863.0
2020-09-24 17:00:00	AAPL	Stock	108.69	108.82	108.22	108.81	112076.0
2020-09-24 17:30:00	AAPL	Stock	108.8	109.0	108.75	108.98	99645.0
2020-09-24 18:00:00	AAPL	Stock	109.0	109.28	108.81	108.85	121828.0
2020-09-24 18:30:00	AAPL	Stock	108.91	109.0	108.82	108.97	51793.0
2020-09-24 19:00:00	AAPL	Stock	108.98	109.18	108.89	109.16	85952.0
2020-09-24 19:30:00	AAPL	Stock	109.19	109.25	108.8	109.0	197089.0
2020-09-24 04:00:00	MSFT	Stock	200.51	200.51	199.88	199.88	5296.0
2020-09-24 04:30:00	MSFT	Stock	200.3	200.3	200.02	200.02	300.0
2020-09-24 05:00:00	MSFT	Stock	199.87	200.38	199.61	200.38	1767.0
2020-09-24 05:30:00	MSFT	Stock	199.99	200.13	199.9	200.13	1414.0
2020-09-24 06:00:00	MSFT	Stock	200.3	201.33	200.3	201.33	5189.0
2020-09-24 06:30:00	MSFT	Stock	201.32	201.88	201.32	201.88	2505.0
2020-09-24 07:00:00	MSFT	Stock	201.42	201.42	200.75	200.75	7493.0
2020-09-24 07:30:00	MSFT	Stock	200.89	201.32	200.13	200.17	17698.0
2020-09-24 08:00:00	MSFT	Stock	201.28	201.4	199.1	199.48	52326.0
2020-09-24 08:30:00	MSFT	Stock	199.4	199.548	198.04	198.8	111140.0
2020-09-24 09:00:00	MSFT	Stock	198.8	200.09	198.06	200.09	74675.0
2020-09-24 09:30:00	MSFT	Stock	200.09	203.21	199.2	202.44	3693590.0
2020-09-24 10:00:00	MSFT	Stock	202.42	204.47	202.42	202.9	2517084.0
2020-09-24 10:30:00	MSFT	Stock	202.9	204.09	201.63	203.99	2214174.0
2020-09-24 11:00:00	MSFT	Stock	203.97	204.568	202.67	204.131	1648035.0
2020-09-24 11:30:00	MSFT	Stock	204.12	205.09	204.03	204.836	1230193.0
2020-09-24 12:00:00	MSFT	Stock	204.86	205.57	204.531	204.769	1478881.0
2020-09-24 12:30:00	MSFT	Stock	204.8	205.0	203.99	204.94	992176.0

> showing 50 of 97,810 rows — these rows as CSV

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