PREVIEW / stock_30min / 2018-01-22

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-22.parquet
  size:    1.7 MB
  rows:    84,849
  symbols: 2,881

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-01-22 04:00:00	AAPL	Stock	44.4725	44.48	44.25	44.25	17140.0
2018-01-22 04:30:00	AAPL	Stock	44.27	44.27	44.25	44.25	9984.0
2018-01-22 05:00:00	AAPL	Stock	44.235	44.235	44.235	44.235	400.0
2018-01-22 05:30:00	AAPL	Stock	44.2375	44.25	44.225	44.225	9652.0
2018-01-22 06:00:00	AAPL	Stock	44.225	44.32	44.225	44.25	34828.0
2018-01-22 06:30:00	AAPL	Stock	44.25	44.2875	44.245	44.25	9480.0
2018-01-22 07:00:00	AAPL	Stock	44.2425	44.3	44.2125	44.2775	102916.0
2018-01-22 07:30:00	AAPL	Stock	44.275	44.285	44.2375	44.285	53748.0
2018-01-22 08:00:00	AAPL	Stock	44.2775	44.375	44.225	44.355	276076.0
2018-01-22 08:30:00	AAPL	Stock	44.375	44.4	44.33	44.3525	255964.0
2018-01-22 09:00:00	AAPL	Stock	44.3525	44.405	44.315	44.3275	158900.0
2018-01-22 09:30:00	AAPL	Stock	44.325	44.445	44.1505	44.34	14790692.0
2018-01-22 10:00:00	AAPL	Stock	44.3375	44.3525	44.22	44.2912	7916664.0
2018-01-22 10:30:00	AAPL	Stock	44.295	44.36	44.245	44.25	5467136.0
2018-01-22 11:00:00	AAPL	Stock	44.2512	44.31	44.21	44.245	5425388.0
2018-01-22 11:30:00	AAPL	Stock	44.245	44.2925	44.2125	44.284	4054116.0
2018-01-22 12:00:00	AAPL	Stock	44.2825	44.37	44.2725	44.3125	5222556.0
2018-01-22 12:30:00	AAPL	Stock	44.3125	44.37	44.2875	44.335	3727784.0
2018-01-22 13:00:00	AAPL	Stock	44.3345	44.405	44.33	44.3485	3422544.0
2018-01-22 13:30:00	AAPL	Stock	44.3475	44.4175	44.3375	44.3612	3220968.0
2018-01-22 14:00:00	AAPL	Stock	44.362	44.3725	44.22	44.2288	4906456.0
2018-01-22 14:30:00	AAPL	Stock	44.2275	44.295	44.205	44.25	4043444.0
2018-01-22 15:00:00	AAPL	Stock	44.25	44.275	44.215	44.2382	4146948.0
2018-01-22 15:30:00	AAPL	Stock	44.2382	44.265	44.175	44.2525	12884684.0
2018-01-22 16:00:00	AAPL	Stock	44.25	44.2775	44.2025	44.2625	14538156.0
2018-01-22 16:30:00	AAPL	Stock	44.265	44.3075	44.25	44.2875	1346144.0
2018-01-22 17:00:00	AAPL	Stock	44.2875	44.3125	44.2775	44.31	143436.0
2018-01-22 17:30:00	AAPL	Stock	44.31	44.325	44.305	44.315	86672.0
2018-01-22 18:00:00	AAPL	Stock	44.315	44.3375	44.315	44.3325	36000.0
2018-01-22 18:30:00	AAPL	Stock	44.325	44.3375	44.325	44.335	31520.0
2018-01-22 19:00:00	AAPL	Stock	44.325	44.3375	44.325	44.3375	14596.0
2018-01-22 19:30:00	AAPL	Stock	44.3375	44.35	44.3375	44.3375	22084.0
2018-01-22 04:00:00	MSFT	Stock	89.91	89.91	89.76	89.76	200.0
2018-01-22 06:00:00	MSFT	Stock	89.94	89.94	89.94	89.94	408.0
2018-01-22 07:00:00	MSFT	Stock	89.9	89.9	89.79	89.9	769.0
2018-01-22 07:30:00	MSFT	Stock	89.9	89.97	89.85	89.85	1416.0
2018-01-22 08:00:00	MSFT	Stock	89.9	89.96	89.85	89.96	1680.0
2018-01-22 08:30:00	MSFT	Stock	89.85	89.96	89.85	89.96	1702.0
2018-01-22 09:00:00	MSFT	Stock	89.85	90.0	89.85	89.95	5597.0
2018-01-22 09:30:00	MSFT	Stock	89.92	90.44	89.74	90.422	1900197.0
2018-01-22 10:00:00	MSFT	Stock	90.42	91.16	90.37	91.126	1765053.0
2018-01-22 10:30:00	MSFT	Stock	91.14	91.23	90.85	90.85	1198676.0
2018-01-22 11:00:00	MSFT	Stock	90.855	91.06	90.82	90.934	997033.0
2018-01-22 11:30:00	MSFT	Stock	90.934	91.23	90.911	91.2	735021.0
2018-01-22 12:00:00	MSFT	Stock	91.2	91.23	91.01	91.1	1264080.0
2018-01-22 12:30:00	MSFT	Stock	91.095	91.21	91.074	91.095	936311.0
2018-01-22 13:00:00	MSFT	Stock	91.1	91.12	90.97	91.015	1086657.0
2018-01-22 13:30:00	MSFT	Stock	91.02	91.06	90.99	91.04	828257.0
2018-01-22 14:00:00	MSFT	Stock	91.047	91.09	90.98	91.01	782442.0
2018-01-22 14:30:00	MSFT	Stock	91.01	91.165	91.01	91.02	725275.0

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

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