PREVIEW / stock_30min / 2018-12-26

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-12-26.parquet
  size:    1.7 MB
  rows:    86,340
  symbols: 2,728

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
2018-12-26 04:00:00	AAPL	Stock	36.65	36.65	36.605	36.65	6424.0
2018-12-26 04:30:00	AAPL	Stock	36.65	36.775	36.6475	36.775	25812.0
2018-12-26 05:00:00	AAPL	Stock	36.74	36.775	36.74	36.755	3328.0
2018-12-26 05:30:00	AAPL	Stock	36.755	36.755	36.68	36.7075	15400.0
2018-12-26 06:00:00	AAPL	Stock	36.77	36.84	36.77	36.84	138748.0
2018-12-26 06:30:00	AAPL	Stock	36.87	36.87	36.75	36.8	8392.0
2018-12-26 07:00:00	AAPL	Stock	36.7625	37.0675	36.7525	36.9925	153744.0
2018-12-26 07:30:00	AAPL	Stock	37.0	37.0	36.875	36.98	129368.0
2018-12-26 08:00:00	AAPL	Stock	36.8125	37.06	36.75	37.0125	327284.0
2018-12-26 08:30:00	AAPL	Stock	37.025	37.0625	36.9075	37.035	250380.0
2018-12-26 09:00:00	AAPL	Stock	37.025	37.2775	36.975	37.0775	414024.0
2018-12-26 09:30:00	AAPL	Stock	37.075	37.48	36.9625	37.0375	25713044.0
2018-12-26 10:00:00	AAPL	Stock	37.0375	37.1425	36.725	36.834	18203648.0
2018-12-26 10:30:00	AAPL	Stock	36.83	37.025	36.695	36.7225	12653196.0
2018-12-26 11:00:00	AAPL	Stock	36.73	37.27	36.68	37.2403	13640156.0
2018-12-26 11:30:00	AAPL	Stock	37.2375	37.7	37.1325	37.685	12589912.0
2018-12-26 12:00:00	AAPL	Stock	37.6825	37.975	37.6275	37.7965	15409860.0
2018-12-26 12:30:00	AAPL	Stock	37.8025	38.115	37.7	38.0865	10668916.0
2018-12-26 13:00:00	AAPL	Stock	38.0875	38.1175	37.67	37.8722	8703416.0
2018-12-26 13:30:00	AAPL	Stock	37.8675	38.295	37.865	38.2675	8536544.0
2018-12-26 14:00:00	AAPL	Stock	38.27	38.43	38.15	38.2435	10927180.0
2018-12-26 14:30:00	AAPL	Stock	38.24	38.49	38.24	38.4765	8009036.0
2018-12-26 15:00:00	AAPL	Stock	38.4675	38.535	38.3575	38.511	9823324.0
2018-12-26 15:30:00	AAPL	Stock	38.5112	39.3075	38.51	39.2925	25810200.0
2018-12-26 16:00:00	AAPL	Stock	39.2925	39.2925	39.1	39.135	22253524.0
2018-12-26 16:30:00	AAPL	Stock	39.135	39.2925	39.0375	39.125	303108.0
2018-12-26 17:00:00	AAPL	Stock	39.125	39.2	39.0825	39.185	110364.0
2018-12-26 17:30:00	AAPL	Stock	39.185	39.3125	39.185	39.3125	142732.0
2018-12-26 18:00:00	AAPL	Stock	39.2925	39.3125	39.22	39.2925	1024480.0
2018-12-26 18:30:00	AAPL	Stock	39.2775	39.325	39.2125	39.2775	272444.0
2018-12-26 19:00:00	AAPL	Stock	39.2775	39.325	39.2125	39.225	94488.0
2018-12-26 19:30:00	AAPL	Stock	39.25	39.25	39.075	39.1	76168.0
2018-12-26 04:00:00	MSFT	Stock	93.8	93.8	93.8	93.8	752.0
2018-12-26 05:00:00	MSFT	Stock	94.36	94.36	94.36	94.36	100.0
2018-12-26 05:30:00	MSFT	Stock	94.01	94.68	93.91	94.39	3135.0
2018-12-26 06:00:00	MSFT	Stock	94.47	94.5	94.45	94.45	700.0
2018-12-26 06:30:00	MSFT	Stock	94.35	94.5	94.35	94.5	1077.0
2018-12-26 07:00:00	MSFT	Stock	94.5	94.73	94.45	94.73	14924.0
2018-12-26 07:30:00	MSFT	Stock	94.97	95.15	94.82	95.0	16362.0
2018-12-26 08:00:00	MSFT	Stock	94.5	95.25	94.4	94.9	37143.0
2018-12-26 08:30:00	MSFT	Stock	94.8	95.0	94.45	94.84	16143.0
2018-12-26 09:00:00	MSFT	Stock	94.9	95.49	94.65	95.19	42807.0
2018-12-26 09:30:00	MSFT	Stock	95.23	97.206	93.96	95.656	5379172.0
2018-12-26 10:00:00	MSFT	Stock	95.66	95.84	94.84	95.29	3392928.0
2018-12-26 10:30:00	MSFT	Stock	95.29	95.55	94.67	94.825	2395188.0
2018-12-26 11:00:00	MSFT	Stock	94.83	96.02	94.76	95.94	2397964.0
2018-12-26 11:30:00	MSFT	Stock	95.94	97.13	95.92	97.1	3294302.0
2018-12-26 12:00:00	MSFT	Stock	97.09	97.95	96.96	97.45	3270774.0
2018-12-26 12:30:00	MSFT	Stock	97.449	98.16	97.31	98.0	2135385.0
2018-12-26 13:00:00	MSFT	Stock	98.0	98.13	97.065	97.74	2242174.0

> showing 50 of 86,340 rows — these rows as CSV

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