PREVIEW / stock_30min / 2019-05-09

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-05-09.parquet
  size:    1.7 MB
  rows:    84,144
  symbols: 2,595

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-05-09 04:00:00	AAPL	Stock	50.3375	50.34	50.1275	50.2425	15760.0
2019-05-09 04:30:00	AAPL	Stock	50.2425	50.2975	50.2375	50.25	4080.0
2019-05-09 05:00:00	AAPL	Stock	50.2975	50.3425	50.2525	50.3425	9264.0
2019-05-09 05:30:00	AAPL	Stock	50.2775	50.3475	50.2625	50.3475	4660.0
2019-05-09 06:00:00	AAPL	Stock	50.2775	50.2925	50.2375	50.2925	4400.0
2019-05-09 06:30:00	AAPL	Stock	50.285	50.3625	50.285	50.3125	3316.0
2019-05-09 07:00:00	AAPL	Stock	50.35	50.4725	50.325	50.375	95516.0
2019-05-09 07:30:00	AAPL	Stock	50.3875	50.44	50.35	50.4025	81036.0
2019-05-09 08:00:00	AAPL	Stock	50.3775	50.4375	50.3275	50.3435	230812.0
2019-05-09 08:30:00	AAPL	Stock	50.35	50.395	50.2	50.2325	495120.0
2019-05-09 09:00:00	AAPL	Stock	50.2075	50.255	50.0625	50.1225	848664.0
2019-05-09 09:30:00	AAPL	Stock	50.115	50.2075	49.575	49.75	23394628.0
2019-05-09 10:00:00	AAPL	Stock	49.7625	49.7625	49.165	49.3275	15687448.0
2019-05-09 10:30:00	AAPL	Stock	49.3275	49.61	49.225	49.384	8589628.0
2019-05-09 11:00:00	AAPL	Stock	49.38	49.5375	49.2425	49.32	7223884.0
2019-05-09 11:30:00	AAPL	Stock	49.3212	49.6775	49.295	49.6575	6490148.0
2019-05-09 12:00:00	AAPL	Stock	49.6525	49.81	49.52	49.7375	6394484.0
2019-05-09 12:30:00	AAPL	Stock	49.7375	50.3525	49.7375	50.0325	11991364.0
2019-05-09 13:00:00	AAPL	Stock	50.04	50.21	50.02	50.1275	4843232.0
2019-05-09 13:30:00	AAPL	Stock	50.1225	50.42	50.1	50.2825	4962760.0
2019-05-09 14:00:00	AAPL	Stock	50.2778	50.3688	50.1625	50.2975	4207620.0
2019-05-09 14:30:00	AAPL	Stock	50.2975	50.3775	49.9012	49.9175	4806040.0
2019-05-09 15:00:00	AAPL	Stock	49.9135	50.0975	49.7625	50.0675	5823356.0
2019-05-09 15:30:00	AAPL	Stock	50.0675	50.225	49.9825	50.18	9757224.0
2019-05-09 16:00:00	AAPL	Stock	50.18	50.205	49.8035	50.1625	5882356.0
2019-05-09 16:30:00	AAPL	Stock	50.1625	50.1823	50.0775	50.0775	83624.0
2019-05-09 17:00:00	AAPL	Stock	50.125	50.135	50.075	50.11	42784.0
2019-05-09 17:30:00	AAPL	Stock	50.08	50.175	50.08	50.1705	7508.0
2019-05-09 18:00:00	AAPL	Stock	50.125	50.1625	50.1025	50.1025	19844.0
2019-05-09 18:30:00	AAPL	Stock	50.1	50.1	50.0775	50.0825	26680.0
2019-05-09 19:00:00	AAPL	Stock	50.075	50.175	50.075	50.105	43396.0
2019-05-09 19:30:00	AAPL	Stock	50.105	50.2125	50.105	50.18	22616.0
2019-05-09 04:30:00	MSFT	Stock	124.31	124.48	124.31	124.48	200.0
2019-05-09 05:00:00	MSFT	Stock	124.59	124.59	124.59	124.59	200.0
2019-05-09 06:00:00	MSFT	Stock	124.63	124.63	124.63	124.63	165.0
2019-05-09 07:00:00	MSFT	Stock	124.77	124.81	124.75	124.75	3190.0
2019-05-09 07:30:00	MSFT	Stock	124.74	124.74	124.62	124.62	1102.0
2019-05-09 08:00:00	MSFT	Stock	124.7	124.8	124.58	124.65	7860.0
2019-05-09 08:30:00	MSFT	Stock	124.7	124.7	124.24	124.35	27672.0
2019-05-09 09:00:00	MSFT	Stock	124.35	124.35	124.02	124.29	33935.0
2019-05-09 09:30:00	MSFT	Stock	124.29	124.72	123.69	124.25	3089994.0
2019-05-09 10:00:00	MSFT	Stock	124.26	124.3	123.575	123.84	1846015.0
2019-05-09 10:30:00	MSFT	Stock	123.84	124.27	123.597	123.645	1566518.0
2019-05-09 11:00:00	MSFT	Stock	123.62	124.31	123.57	123.855	1726268.0
2019-05-09 11:30:00	MSFT	Stock	123.85	124.43	123.85	124.34	1153490.0
2019-05-09 12:00:00	MSFT	Stock	124.34	124.77	124.045	124.62	1437816.0
2019-05-09 12:30:00	MSFT	Stock	124.63	125.79	124.63	124.95	2320710.0
2019-05-09 13:00:00	MSFT	Stock	124.95	125.26	124.68	124.95	1069498.0
2019-05-09 13:30:00	MSFT	Stock	124.93	125.52	124.83	125.108	890974.0
2019-05-09 14:00:00	MSFT	Stock	125.11	125.33	124.811	125.16	848248.0

> showing 50 of 84,144 rows — these rows as CSV

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