PREVIEW / stock_30min / 2019-11-29

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-11-29.parquet
  size:    1.1 MB
  rows:    50,683
  symbols: 2,458

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
2019-11-29 04:00:00	AAPL	Stock	66.675	66.75	66.675	66.75	3684.0
2019-11-29 04:30:00	AAPL	Stock	66.7	66.7	66.7	66.7	1464.0
2019-11-29 05:00:00	AAPL	Stock	66.735	66.7925	66.735	66.7925	10700.0
2019-11-29 05:30:00	AAPL	Stock	66.75	66.775	66.75	66.775	8324.0
2019-11-29 06:00:00	AAPL	Stock	66.7825	66.7825	66.7825	66.7825	9868.0
2019-11-29 06:30:00	AAPL	Stock	66.8375	66.8375	66.8375	66.8375	7200.0
2019-11-29 07:00:00	AAPL	Stock	66.775	66.8625	66.725	66.8	43668.0
2019-11-29 07:30:00	AAPL	Stock	66.8175	66.8175	66.7575	66.765	11776.0
2019-11-29 08:00:00	AAPL	Stock	66.78	66.85	66.725	66.75	124716.0
2019-11-29 08:30:00	AAPL	Stock	66.75	66.7875	66.75	66.7628	31384.0
2019-11-29 09:00:00	AAPL	Stock	66.7525	66.775	66.565	66.57	165980.0
2019-11-29 09:30:00	AAPL	Stock	66.65	66.9075	66.475	66.86	8422912.0
2019-11-29 10:00:00	AAPL	Stock	66.86	66.9788	66.755	66.8125	3919080.0
2019-11-29 10:30:00	AAPL	Stock	66.81	67.0	66.775	66.925	3312544.0
2019-11-29 11:00:00	AAPL	Stock	66.9325	66.96	66.835	66.945	2759248.0
2019-11-29 11:30:00	AAPL	Stock	66.945	66.995	66.84	66.9275	3709668.0
2019-11-29 12:00:00	AAPL	Stock	66.9275	66.955	66.8575	66.8675	2139804.0
2019-11-29 12:30:00	AAPL	Stock	66.8675	66.97	66.7375	66.795	6703228.0
2019-11-29 13:00:00	AAPL	Stock	66.795	66.9525	66.795	66.8625	6703680.0
2019-11-29 13:30:00	AAPL	Stock	66.8725	66.875	66.8125	66.8625	191140.0
2019-11-29 14:00:00	AAPL	Stock	66.85	66.864	66.83	66.8625	21116.0
2019-11-29 14:30:00	AAPL	Stock	66.855	66.895	66.8125	66.895	45220.0
2019-11-29 15:00:00	AAPL	Stock	66.8925	66.8925	66.8625	66.87	7972.0
2019-11-29 15:30:00	AAPL	Stock	66.8675	66.8675	66.85	66.85	6568.0
2019-11-29 16:00:00	AAPL	Stock	66.8725	66.8725	66.8725	66.8725	400.0
2019-11-29 16:30:00	AAPL	Stock	66.8625	66.9	66.85	66.85	5928.0
2019-11-29 04:00:00	MSFT	Stock	151.65	152.14	151.65	152.05	1012.0
2019-11-29 04:30:00	MSFT	Stock	152.1	152.1	152.0	152.0	1100.0
2019-11-29 05:00:00	MSFT	Stock	152.1	152.12	152.1	152.12	413.0
2019-11-29 05:30:00	MSFT	Stock	152.23	152.23	152.1	152.1	1230.0
2019-11-29 06:00:00	MSFT	Stock	152.2	152.2	152.2	152.2	150.0
2019-11-29 06:30:00	MSFT	Stock	152.2	152.2	152.2	152.2	3314.0
2019-11-29 07:00:00	MSFT	Stock	152.1	152.25	152.1	152.24	5724.0
2019-11-29 07:30:00	MSFT	Stock	152.2	152.2	152.11	152.2	4179.0
2019-11-29 08:00:00	MSFT	Stock	152.1	152.17	152.1	152.14	3362.0
2019-11-29 08:30:00	MSFT	Stock	152.13	152.15	152.054	152.1	4069.0
2019-11-29 09:00:00	MSFT	Stock	152.11	152.14	152.021	152.05	10122.0
2019-11-29 09:30:00	MSFT	Stock	152.1	152.14	151.43	152.13	1588013.0
2019-11-29 10:00:00	MSFT	Stock	152.12	152.3	151.85	151.858	725161.0
2019-11-29 10:30:00	MSFT	Stock	151.86	152.01	151.6	151.7	725438.0
2019-11-29 11:00:00	MSFT	Stock	151.69	151.8	151.55	151.58	580767.0
2019-11-29 11:30:00	MSFT	Stock	151.57	151.81	151.48	151.795	743706.0
2019-11-29 12:00:00	MSFT	Stock	151.79	151.81	151.39	151.39	621278.0
2019-11-29 12:30:00	MSFT	Stock	151.39	151.75	151.28	151.38	2106028.0
2019-11-29 13:00:00	MSFT	Stock	151.38	151.73	151.38	151.587	3090443.0
2019-11-29 13:30:00	MSFT	Stock	151.58	151.6	151.38	151.6	50831.0
2019-11-29 14:00:00	MSFT	Stock	151.65	151.75	151.5	151.592	4820.0
2019-11-29 14:30:00	MSFT	Stock	151.514	151.76	151.38	151.76	10154.0
2019-11-29 15:00:00	MSFT	Stock	151.6	151.6	151.6	151.6	200.0
2019-11-29 15:30:00	MSFT	Stock	151.57	151.69	151.57	151.69	400.0

> showing 50 of 50,683 rows — these rows as CSV

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