PREVIEW / stock_30min / 2018-01-12

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-01-12.parquet
  size:    1.7 MB
  rows:    85,007
  symbols: 2,902

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-12 04:00:00	AAPL	Stock	43.925	43.925	43.925	43.925	3720.0
2018-01-12 04:30:00	AAPL	Stock	43.8675	43.8675	43.85	43.85	7200.0
2018-01-12 05:00:00	AAPL	Stock	43.85	43.85	43.85	43.85	800.0
2018-01-12 06:30:00	AAPL	Stock	43.935	43.935	43.9125	43.9125	3844.0
2018-01-12 07:00:00	AAPL	Stock	43.8875	43.95	43.86	43.9275	71320.0
2018-01-12 07:30:00	AAPL	Stock	43.9425	43.985	43.9225	43.9775	53616.0
2018-01-12 08:00:00	AAPL	Stock	43.875	44.1275	43.875	44.1225	340112.0
2018-01-12 08:30:00	AAPL	Stock	44.1225	44.15	43.9025	43.9125	599100.0
2018-01-12 09:00:00	AAPL	Stock	43.92	44.0125	43.905	44.0025	236824.0
2018-01-12 09:30:00	AAPL	Stock	44.045	44.0825	43.9125	43.9925	12640636.0
2018-01-12 10:00:00	AAPL	Stock	43.9925	44.0988	43.986	44.0975	5600760.0
2018-01-12 10:30:00	AAPL	Stock	44.0975	44.265	44.09	44.2025	8342640.0
2018-01-12 11:00:00	AAPL	Stock	44.205	44.205	44.07	44.1755	5651628.0
2018-01-12 11:30:00	AAPL	Stock	44.18	44.24	44.1625	44.1975	4038824.0
2018-01-12 12:00:00	AAPL	Stock	44.2025	44.2125	44.155	44.1975	2660492.0
2018-01-12 12:30:00	AAPL	Stock	44.1945	44.245	44.18	44.24	2939564.0
2018-01-12 13:00:00	AAPL	Stock	44.24	44.2575	44.195	44.195	2824412.0
2018-01-12 13:30:00	AAPL	Stock	44.195	44.275	44.1925	44.2525	2736220.0
2018-01-12 14:00:00	AAPL	Stock	44.251	44.3325	44.2338	44.3262	3986600.0
2018-01-12 14:30:00	AAPL	Stock	44.33	44.3375	44.2375	44.2555	4203320.0
2018-01-12 15:00:00	AAPL	Stock	44.2575	44.295	44.205	44.215	4276772.0
2018-01-12 15:30:00	AAPL	Stock	44.2175	44.34	44.1975	44.25	11923740.0
2018-01-12 16:00:00	AAPL	Stock	44.2725	44.345	44.23	44.3425	7954980.0
2018-01-12 16:30:00	AAPL	Stock	44.325	44.345	44.2725	44.3225	96000.0
2018-01-12 17:00:00	AAPL	Stock	44.31	44.3375	44.2775	44.325	122152.0
2018-01-12 17:30:00	AAPL	Stock	44.325	44.325	44.2725	44.32	369300.0
2018-01-12 18:00:00	AAPL	Stock	44.3025	44.325	44.2875	44.325	25144.0
2018-01-12 18:30:00	AAPL	Stock	44.3	44.32	44.2875	44.2925	12488.0
2018-01-12 19:00:00	AAPL	Stock	44.305	44.3225	44.3	44.3	24440.0
2018-01-12 19:30:00	AAPL	Stock	44.3	44.3375	44.3	44.3375	21536.0
2018-01-12 04:00:00	MSFT	Stock	88.52	88.52	88.52	88.52	204.0
2018-01-12 06:00:00	MSFT	Stock	88.65	88.84	88.65	88.84	200.0
2018-01-12 06:30:00	MSFT	Stock	88.6	88.6	88.52	88.52	400.0
2018-01-12 07:00:00	MSFT	Stock	88.52	88.6	88.5	88.55	8416.0
2018-01-12 07:30:00	MSFT	Stock	88.55	88.78	88.55	88.78	12352.0
2018-01-12 08:00:00	MSFT	Stock	88.5	88.8	88.47	88.78	22569.0
2018-01-12 08:30:00	MSFT	Stock	88.72	88.74	88.31	88.41	16271.0
2018-01-12 09:00:00	MSFT	Stock	88.33	88.68	88.3	88.6	24724.0
2018-01-12 09:30:00	MSFT	Stock	88.67	89.026	88.45	88.94	2688602.0
2018-01-12 10:00:00	MSFT	Stock	88.935	89.08	88.75	89.065	1317147.0
2018-01-12 10:30:00	MSFT	Stock	89.07	89.39	89.01	89.29	1659353.0
2018-01-12 11:00:00	MSFT	Stock	89.28	89.415	89.19	89.205	1129927.0
2018-01-12 11:30:00	MSFT	Stock	89.205	89.21	89.01	89.07	940055.0
2018-01-12 12:00:00	MSFT	Stock	89.07	89.09	88.89	88.975	941587.0
2018-01-12 12:30:00	MSFT	Stock	88.975	89.43	88.94	89.425	1004288.0
2018-01-12 13:00:00	MSFT	Stock	89.43	89.49	89.34	89.379	902883.0
2018-01-12 13:30:00	MSFT	Stock	89.37	89.5	89.355	89.47	925432.0
2018-01-12 14:00:00	MSFT	Stock	89.476	89.6	89.41	89.581	1124472.0
2018-01-12 14:30:00	MSFT	Stock	89.59	89.62	89.375	89.44	1051614.0
2018-01-12 15:00:00	MSFT	Stock	89.433	89.55	89.23	89.51	1312914.0

> showing 50 of 85,007 rows — these rows as CSV

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