PREVIEW / stock_30min / 2018-08-16

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-08-16.parquet
  size:    1.7 MB
  rows:    82,543
  symbols: 2,789

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-08-16 04:00:00	AAPL	Stock	52.675	52.85	52.675	52.85	25944.0
2018-08-16 04:30:00	AAPL	Stock	52.8425	52.85	52.8425	52.85	5124.0
2018-08-16 05:00:00	AAPL	Stock	52.8375	52.85	52.8375	52.85	2928.0
2018-08-16 05:30:00	AAPL	Stock	52.85	52.875	52.8375	52.8375	4700.0
2018-08-16 06:00:00	AAPL	Stock	52.95	52.95	52.925	52.925	3200.0
2018-08-16 06:30:00	AAPL	Stock	52.92	52.96	52.895	52.9525	46308.0
2018-08-16 07:00:00	AAPL	Stock	52.9525	52.9875	52.915	52.96	151468.0
2018-08-16 07:30:00	AAPL	Stock	52.96	52.9625	52.9075	52.9175	90580.0
2018-08-16 08:00:00	AAPL	Stock	52.915	52.985	52.9025	52.925	251936.0
2018-08-16 08:30:00	AAPL	Stock	52.925	52.925	52.825	52.8625	226228.0
2018-08-16 09:00:00	AAPL	Stock	52.8575	52.9825	52.56	52.95	526356.0
2018-08-16 09:30:00	AAPL	Stock	52.925	53.115	52.8675	52.9825	15655324.0
2018-08-16 10:00:00	AAPL	Stock	52.9825	53.235	52.965	53.233	9284344.0
2018-08-16 10:30:00	AAPL	Stock	53.235	53.3138	53.145	53.22	7318596.0
2018-08-16 11:00:00	AAPL	Stock	53.219	53.3825	53.2128	53.3375	7347372.0
2018-08-16 11:30:00	AAPL	Stock	53.34	53.365	53.265	53.3075	4158732.0
2018-08-16 12:00:00	AAPL	Stock	53.305	53.415	53.305	53.3362	5212088.0
2018-08-16 12:30:00	AAPL	Stock	53.3375	53.345	53.235	53.2938	4268080.0
2018-08-16 13:00:00	AAPL	Stock	53.295	53.355	53.2725	53.3425	2465328.0
2018-08-16 13:30:00	AAPL	Stock	53.3438	53.3625	53.285	53.335	2727476.0
2018-08-16 14:00:00	AAPL	Stock	53.3362	53.45	53.3175	53.3175	5984816.0
2018-08-16 14:30:00	AAPL	Stock	53.3175	53.3975	53.2778	53.3875	3768004.0
2018-08-16 15:00:00	AAPL	Stock	53.39	53.453	53.3675	53.4475	4488176.0
2018-08-16 15:30:00	AAPL	Stock	53.45	53.4505	53.225	53.37	12209296.0
2018-08-16 16:00:00	AAPL	Stock	53.37	53.37	53.225	53.25	10112048.0
2018-08-16 16:30:00	AAPL	Stock	53.25	53.33	53.1875	53.24	520336.0
2018-08-16 17:00:00	AAPL	Stock	53.2375	53.2625	53.225	53.2625	107748.0
2018-08-16 17:30:00	AAPL	Stock	53.2625	53.2775	53.25	53.25	30892.0
2018-08-16 18:00:00	AAPL	Stock	53.275	53.28	53.245	53.245	19524.0
2018-08-16 18:30:00	AAPL	Stock	53.2325	53.25	53.2325	53.25	29832.0
2018-08-16 19:00:00	AAPL	Stock	53.25	53.2775	53.2475	53.2525	23592.0
2018-08-16 19:30:00	AAPL	Stock	53.2625	53.275	53.2475	53.2475	24704.0
2018-08-16 04:00:00	MSFT	Stock	108.0	108.0	108.0	108.0	100.0
2018-08-16 04:30:00	MSFT	Stock	108.26	108.26	108.26	108.26	2000.0
2018-08-16 05:00:00	MSFT	Stock	108.47	108.49	108.35	108.35	2580.0
2018-08-16 05:30:00	MSFT	Stock	108.55	108.55	108.55	108.55	500.0
2018-08-16 06:00:00	MSFT	Stock	108.65	108.65	108.65	108.65	100.0
2018-08-16 06:30:00	MSFT	Stock	108.46	108.67	108.46	108.51	1689.0
2018-08-16 07:00:00	MSFT	Stock	108.6	108.69	108.56	108.61	6572.0
2018-08-16 07:30:00	MSFT	Stock	108.56	108.66	108.43	108.45	5284.0
2018-08-16 08:00:00	MSFT	Stock	108.68	108.7	108.26	108.26	14077.0
2018-08-16 08:30:00	MSFT	Stock	108.3	108.42	107.66	108.24	15342.0
2018-08-16 09:00:00	MSFT	Stock	108.24	108.39	108.1	108.3	11007.0
2018-08-16 09:30:00	MSFT	Stock	108.3	108.86	107.95	108.03	2211061.0
2018-08-16 10:00:00	MSFT	Stock	108.03	108.31	108.02	108.31	1093129.0
2018-08-16 10:30:00	MSFT	Stock	108.305	108.43	107.96	108.06	1139592.0
2018-08-16 11:00:00	MSFT	Stock	108.06	108.45	108.058	108.42	717879.0
2018-08-16 11:30:00	MSFT	Stock	108.425	108.448	108.26	108.31	635745.0
2018-08-16 12:00:00	MSFT	Stock	108.305	108.52	108.25	108.335	631579.0
2018-08-16 12:30:00	MSFT	Stock	108.34	108.36	108.16	108.23	510617.0

> showing 50 of 82,543 rows — these rows as CSV

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