PREVIEW / stock_30min / 2018-09-25

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-09-25.parquet
  size:    1.7 MB
  rows:    84,378
  symbols: 2,781

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-09-25 04:00:00	AAPL	Stock	55.375	55.3975	55.3	55.31	11284.0
2018-09-25 04:30:00	AAPL	Stock	55.3075	55.3075	55.3075	55.3075	420.0
2018-09-25 05:00:00	AAPL	Stock	55.245	55.3	55.245	55.2875	9968.0
2018-09-25 05:30:00	AAPL	Stock	55.2875	55.3	55.2875	55.3	7800.0
2018-09-25 06:00:00	AAPL	Stock	55.3	55.3075	55.275	55.275	7400.0
2018-09-25 06:30:00	AAPL	Stock	55.3225	55.335	55.2975	55.3	43692.0
2018-09-25 07:00:00	AAPL	Stock	55.32	55.3675	55.285	55.3475	162856.0
2018-09-25 07:30:00	AAPL	Stock	55.3475	55.35	55.2125	55.25	149484.0
2018-09-25 08:00:00	AAPL	Stock	55.3125	55.35	55.07	55.1375	237692.0
2018-09-25 08:30:00	AAPL	Stock	55.14	55.16	54.8375	55.0825	314268.0
2018-09-25 09:00:00	AAPL	Stock	55.0825	55.0975	54.8125	54.94	560220.0
2018-09-25 09:30:00	AAPL	Stock	54.9375	55.2975	54.925	55.2225	12902708.0
2018-09-25 10:00:00	AAPL	Stock	55.22	55.26	55.035	55.2075	5561992.0
2018-09-25 10:30:00	AAPL	Stock	55.205	55.3975	55.0975	55.12	5226288.0
2018-09-25 11:00:00	AAPL	Stock	55.1175	55.49	55.09	55.4825	4438456.0
2018-09-25 11:30:00	AAPL	Stock	55.4825	55.705	55.43	55.631	7095392.0
2018-09-25 12:00:00	AAPL	Stock	55.6325	55.6748	55.59	55.6075	3533048.0
2018-09-25 12:30:00	AAPL	Stock	55.6075	55.625	55.5025	55.525	2568608.0
2018-09-25 13:00:00	AAPL	Stock	55.525	55.635	55.4875	55.62	3139196.0
2018-09-25 13:30:00	AAPL	Stock	55.6175	55.618	55.445	55.5	3296236.0
2018-09-25 14:00:00	AAPL	Stock	55.4975	55.505	55.4525	55.485	2274548.0
2018-09-25 14:30:00	AAPL	Stock	55.485	55.49	55.4225	55.4348	2471144.0
2018-09-25 15:00:00	AAPL	Stock	55.4425	55.5875	55.4158	55.5838	3574076.0
2018-09-25 15:30:00	AAPL	Stock	55.585	55.6225	55.5	55.5475	7588820.0
2018-09-25 16:00:00	AAPL	Stock	55.5475	55.595	55.535	55.55	13957124.0
2018-09-25 16:30:00	AAPL	Stock	55.5475	55.56	55.515	55.5475	586368.0
2018-09-25 17:00:00	AAPL	Stock	55.526	55.5475	55.525	55.53	4836.0
2018-09-25 17:30:00	AAPL	Stock	55.5475	55.5525	55.52	55.5525	28516.0
2018-09-25 18:00:00	AAPL	Stock	55.5475	55.555	55.5	55.5075	40500.0
2018-09-25 18:30:00	AAPL	Stock	55.515	55.5375	55.5125	55.525	16488.0
2018-09-25 19:00:00	AAPL	Stock	55.5375	55.57	55.5375	55.5525	27492.0
2018-09-25 19:30:00	AAPL	Stock	55.5525	55.585	55.5525	55.565	54336.0
2018-09-25 05:30:00	MSFT	Stock	114.95	114.95	114.95	114.95	300.0
2018-09-25 06:30:00	MSFT	Stock	114.95	115.22	114.95	115.2	3117.0
2018-09-25 07:00:00	MSFT	Stock	115.0	115.12	115.0	115.09	3737.0
2018-09-25 07:30:00	MSFT	Stock	115.09	115.1	114.95	115.1	1612.0
2018-09-25 08:00:00	MSFT	Stock	114.95	115.13	114.95	114.98	3641.0
2018-09-25 08:30:00	MSFT	Stock	114.98	115.05	114.92	115.01	6032.0
2018-09-25 09:00:00	MSFT	Stock	114.95	115.01	114.78	114.84	22043.0
2018-09-25 09:30:00	MSFT	Stock	114.8	115.1	114.26	114.75	2569358.0
2018-09-25 10:00:00	MSFT	Stock	114.75	114.92	114.35	114.395	1317883.0
2018-09-25 10:30:00	MSFT	Stock	114.4	114.51	113.78	113.81	1224453.0
2018-09-25 11:00:00	MSFT	Stock	113.8	114.39	113.75	114.28	1098822.0
2018-09-25 11:30:00	MSFT	Stock	114.285	114.49	114.22	114.335	728843.0
2018-09-25 12:00:00	MSFT	Stock	114.335	114.37	114.2	114.215	439415.0
2018-09-25 12:30:00	MSFT	Stock	114.215	114.24	113.95	114.01	656729.0
2018-09-25 13:00:00	MSFT	Stock	114.01	114.22	113.945	114.19	651804.0
2018-09-25 13:30:00	MSFT	Stock	114.19	114.22	113.945	114.03	788628.0
2018-09-25 14:00:00	MSFT	Stock	114.025	114.06	113.92	113.985	689652.0
2018-09-25 14:30:00	MSFT	Stock	113.98	114.08	113.91	114.055	537069.0

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

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