PREVIEW / stock_30min / 2019-06-06

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-06-06.parquet
  size:    1.7 MB
  rows:    83,641
  symbols: 2,606

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-06-06 04:00:00	AAPL	Stock	45.7575	45.785	45.7575	45.785	2392.0
2019-06-06 04:30:00	AAPL	Stock	45.85	45.85	45.83	45.85	9960.0
2019-06-06 05:00:00	AAPL	Stock	45.8025	45.8375	45.79	45.8375	4536.0
2019-06-06 05:30:00	AAPL	Stock	45.825	45.8775	45.825	45.865	4256.0
2019-06-06 06:00:00	AAPL	Stock	45.845	45.85	45.84	45.84	6736.0
2019-06-06 06:30:00	AAPL	Stock	45.8675	45.87	45.825	45.85	7724.0
2019-06-06 07:00:00	AAPL	Stock	45.85	45.895	45.825	45.8575	40348.0
2019-06-06 07:30:00	AAPL	Stock	45.9	45.9	45.7875	45.88	53436.0
2019-06-06 08:00:00	AAPL	Stock	45.865	45.9175	45.8	45.885	138200.0
2019-06-06 08:30:00	AAPL	Stock	45.8675	45.895	45.58	45.6875	201424.0
2019-06-06 09:00:00	AAPL	Stock	45.6975	45.85	45.675	45.78	157844.0
2019-06-06 09:30:00	AAPL	Stock	45.7725	45.975	45.55	45.5675	9941108.0
2019-06-06 10:00:00	AAPL	Stock	45.5675	45.7425	45.5525	45.6	4476876.0
2019-06-06 10:30:00	AAPL	Stock	45.6025	45.8575	45.5372	45.725	5193540.0
2019-06-06 11:00:00	AAPL	Stock	45.7225	45.945	45.6775	45.9392	4234540.0
2019-06-06 11:30:00	AAPL	Stock	45.9425	45.9675	45.75	45.825	5965164.0
2019-06-06 12:00:00	AAPL	Stock	45.825	45.855	45.755	45.7875	2481500.0
2019-06-06 12:30:00	AAPL	Stock	45.785	45.88	45.77	45.845	1859708.0
2019-06-06 13:00:00	AAPL	Stock	45.8475	45.88	45.7925	45.8675	1831136.0
2019-06-06 13:30:00	AAPL	Stock	45.865	45.9122	45.845	45.845	1438108.0
2019-06-06 14:00:00	AAPL	Stock	45.8462	45.8775	45.8	45.8225	2132844.0
2019-06-06 14:30:00	AAPL	Stock	45.8225	46.11	45.7875	46.005	6065356.0
2019-06-06 15:00:00	AAPL	Stock	46.015	46.2375	45.9912	46.2175	5307072.0
2019-06-06 15:30:00	AAPL	Stock	46.2175	46.3675	46.1975	46.3075	12038704.0
2019-06-06 16:00:00	AAPL	Stock	46.3325	46.3325	46.2675	46.305	5515588.0
2019-06-06 16:30:00	AAPL	Stock	46.3	46.3125	46.11	46.14	98400.0
2019-06-06 17:00:00	AAPL	Stock	46.1875	46.2075	46.155	46.2	15532.0
2019-06-06 17:30:00	AAPL	Stock	46.175	46.25	46.175	46.1875	24172.0
2019-06-06 18:00:00	AAPL	Stock	46.19	46.2375	46.175	46.175	6108.0
2019-06-06 18:30:00	AAPL	Stock	46.2	46.235	46.1825	46.1875	16236.0
2019-06-06 19:00:00	AAPL	Stock	46.2425	46.325	46.195	46.27	18968.0
2019-06-06 19:30:00	AAPL	Stock	46.2875	46.3325	46.2725	46.3325	37600.0
2019-06-06 04:00:00	MSFT	Stock	125.98	126.19	125.98	126.19	750.0
2019-06-06 04:30:00	MSFT	Stock	126.22	126.4	126.22	126.4	302.0
2019-06-06 05:00:00	MSFT	Stock	126.22	126.22	126.2	126.2	300.0
2019-06-06 06:30:00	MSFT	Stock	126.45	126.5	126.45	126.5	2400.0
2019-06-06 07:00:00	MSFT	Stock	126.31	126.45	126.23	126.45	9273.0
2019-06-06 07:30:00	MSFT	Stock	126.45	126.45	126.2	126.27	7335.0
2019-06-06 08:00:00	MSFT	Stock	126.38	126.5	126.02	126.22	7292.0
2019-06-06 08:30:00	MSFT	Stock	126.22	126.22	125.7	125.877	18412.0
2019-06-06 09:00:00	MSFT	Stock	125.65	126.65	125.65	126.38	14085.0
2019-06-06 09:30:00	MSFT	Stock	126.32	126.49	125.6	125.927	2323242.0
2019-06-06 10:00:00	MSFT	Stock	125.92	126.27	125.91	125.92	1086049.0
2019-06-06 10:30:00	MSFT	Stock	125.93	126.15	125.82	126.005	1149010.0
2019-06-06 11:00:00	MSFT	Stock	126.0	126.605	125.835	126.554	1006892.0
2019-06-06 11:30:00	MSFT	Stock	126.56	126.695	126.2	126.345	1178155.0
2019-06-06 12:00:00	MSFT	Stock	126.35	126.47	126.2	126.392	706601.0
2019-06-06 12:30:00	MSFT	Stock	126.37	126.64	126.34	126.525	565673.0
2019-06-06 13:00:00	MSFT	Stock	126.525	126.675	126.49	126.6	521459.0
2019-06-06 13:30:00	MSFT	Stock	126.6	126.68	126.53	126.59	528090.0

> showing 50 of 83,641 rows — these rows as CSV

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