PREVIEW / stock_30min / 2019-08-15

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-15.parquet
  size:    1.7 MB
  rows:    85,677
  symbols: 2,556

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-08-15 04:00:00	AAPL	Stock	50.9175	50.95	50.825	50.95	14196.0
2019-08-15 04:30:00	AAPL	Stock	51.025	51.05	50.9	50.9	12836.0
2019-08-15 05:00:00	AAPL	Stock	50.9	50.9	50.535	50.54	24740.0
2019-08-15 05:30:00	AAPL	Stock	50.465	50.465	50.13	50.2	5364.0
2019-08-15 06:00:00	AAPL	Stock	50.1925	50.25	50.0	50.0	23908.0
2019-08-15 06:30:00	AAPL	Stock	49.9675	50.005	49.7825	50.005	51916.0
2019-08-15 07:00:00	AAPL	Stock	50.05	50.685	49.9075	50.5575	368636.0
2019-08-15 07:30:00	AAPL	Stock	50.5575	50.9625	50.425	50.875	412096.0
2019-08-15 08:00:00	AAPL	Stock	50.0202	51.2025	49.9625	50.7	486660.0
2019-08-15 08:30:00	AAPL	Stock	50.7	51.075	50.7	51.075	238452.0
2019-08-15 09:00:00	AAPL	Stock	51.07	51.105	50.8125	50.855	393452.0
2019-08-15 09:30:00	AAPL	Stock	50.865	51.285	50.51	50.8875	17104620.0
2019-08-15 10:00:00	AAPL	Stock	50.8775	50.9375	50.63	50.64	8131832.0
2019-08-15 10:30:00	AAPL	Stock	50.635	50.635	50.4175	50.52	6527948.0
2019-08-15 11:00:00	AAPL	Stock	50.5175	50.5475	50.1325	50.3175	7406784.0
2019-08-15 11:30:00	AAPL	Stock	50.3225	50.5502	50.2725	50.54	4976900.0
2019-08-15 12:00:00	AAPL	Stock	50.545	50.675	50.4775	50.4775	5232204.0
2019-08-15 12:30:00	AAPL	Stock	50.48	50.6	50.4575	50.5425	3070132.0
2019-08-15 13:00:00	AAPL	Stock	50.54	50.6575	50.47	50.525	2629852.0
2019-08-15 13:30:00	AAPL	Stock	50.5175	50.565	49.9175	50.0525	6416448.0
2019-08-15 14:00:00	AAPL	Stock	50.0525	50.2725	49.97	50.1775	5363164.0
2019-08-15 14:30:00	AAPL	Stock	50.175	50.285	50.0348	50.1775	3682808.0
2019-08-15 15:00:00	AAPL	Stock	50.1875	50.535	50.1875	50.3725	4873960.0
2019-08-15 15:30:00	AAPL	Stock	50.3675	50.625	50.34	50.435	7882568.0
2019-08-15 16:00:00	AAPL	Stock	50.435	50.523	50.4125	50.4155	7816452.0
2019-08-15 16:30:00	AAPL	Stock	50.43	50.5	50.4275	50.475	97588.0
2019-08-15 17:00:00	AAPL	Stock	50.435	50.5625	50.435	50.5625	2327488.0
2019-08-15 17:30:00	AAPL	Stock	50.575	50.575	50.5	50.525	20648.0
2019-08-15 18:00:00	AAPL	Stock	50.5375	50.6125	50.435	50.6125	10596.0
2019-08-15 18:30:00	AAPL	Stock	50.6	50.65	50.575	50.625	29776.0
2019-08-15 19:00:00	AAPL	Stock	50.58	50.65	50.58	50.62	14356.0
2019-08-15 19:30:00	AAPL	Stock	50.65	50.67	50.6	50.6275	38736.0
2019-08-15 04:00:00	MSFT	Stock	134.52	134.65	134.38	134.65	1615.0
2019-08-15 04:30:00	MSFT	Stock	134.7	134.7	134.7	134.7	150.0
2019-08-15 05:00:00	MSFT	Stock	134.7	134.7	134.0	134.0	1817.0
2019-08-15 05:30:00	MSFT	Stock	133.0	133.07	132.34	133.07	1787.0
2019-08-15 06:00:00	MSFT	Stock	133.0	133.0	132.62	132.91	24214.0
2019-08-15 06:30:00	MSFT	Stock	132.68	132.94	132.31	132.74	17767.0
2019-08-15 07:00:00	MSFT	Stock	132.69	134.31	132.56	134.31	13262.0
2019-08-15 07:30:00	MSFT	Stock	134.31	134.55	133.22	134.54	22113.0
2019-08-15 08:00:00	MSFT	Stock	132.8	135.11	132.57	134.3	56578.0
2019-08-15 08:30:00	MSFT	Stock	134.39	135.0	134.25	134.96	29303.0
2019-08-15 09:00:00	MSFT	Stock	134.79	135.09	133.99	134.15	82207.0
2019-08-15 09:30:00	MSFT	Stock	134.13	134.58	132.25	133.77	3763129.0
2019-08-15 10:00:00	MSFT	Stock	133.76	134.06	133.39	133.395	1775471.0
2019-08-15 10:30:00	MSFT	Stock	133.39	133.66	133.04	133.13	1314902.0
2019-08-15 11:00:00	MSFT	Stock	133.13	133.35	132.6	133.293	1670444.0
2019-08-15 11:30:00	MSFT	Stock	133.3	133.725	133.178	133.67	1283671.0
2019-08-15 12:00:00	MSFT	Stock	133.68	134.1	133.55	133.58	1035877.0
2019-08-15 12:30:00	MSFT	Stock	133.59	133.71	133.38	133.55	841429.0

> showing 50 of 85,677 rows — these rows as CSV

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