PREVIEW / stock_30min / 2019-07-09

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-07-09.parquet
  size:    1.7 MB
  rows:    83,961
  symbols: 2,599

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
2019-07-09 04:00:00	AAPL	Stock	49.4	49.6	49.4	49.5275	45648.0
2019-07-09 04:30:00	AAPL	Stock	49.575	49.575	49.4825	49.5125	19204.0
2019-07-09 05:00:00	AAPL	Stock	49.555	49.695	49.555	49.695	41120.0
2019-07-09 05:30:00	AAPL	Stock	49.65	49.85	49.65	49.85	19716.0
2019-07-09 06:00:00	AAPL	Stock	49.8375	49.8525	49.7775	49.79	20840.0
2019-07-09 06:30:00	AAPL	Stock	49.7925	49.84	49.7625	49.795	44620.0
2019-07-09 07:00:00	AAPL	Stock	49.8125	49.98	49.7625	49.9725	44240.0
2019-07-09 07:30:00	AAPL	Stock	49.975	50.1025	49.9625	50.075	128860.0
2019-07-09 08:00:00	AAPL	Stock	49.7625	50.13	49.7625	50.0	174544.0
2019-07-09 08:30:00	AAPL	Stock	50.0325	50.0475	49.9375	50.0	201128.0
2019-07-09 09:00:00	AAPL	Stock	49.975	49.98	49.765	49.8025	291664.0
2019-07-09 09:30:00	AAPL	Stock	49.8	50.0895	49.7025	50.0625	14102680.0
2019-07-09 10:00:00	AAPL	Stock	50.065	50.19	49.9875	50.0625	6847808.0
2019-07-09 10:30:00	AAPL	Stock	50.06	50.1475	49.9862	50.015	4136884.0
2019-07-09 11:00:00	AAPL	Stock	50.015	50.09	49.9475	50.035	3875756.0
2019-07-09 11:30:00	AAPL	Stock	50.0325	50.2075	50.02	50.195	4027140.0
2019-07-09 12:00:00	AAPL	Stock	50.195	50.28	50.16	50.2575	2998364.0
2019-07-09 12:30:00	AAPL	Stock	50.255	50.31	50.23	50.236	2971204.0
2019-07-09 13:00:00	AAPL	Stock	50.237	50.2725	50.1882	50.255	1948164.0
2019-07-09 13:30:00	AAPL	Stock	50.255	50.345	50.2475	50.3445	2176896.0
2019-07-09 14:00:00	AAPL	Stock	50.3438	50.3713	50.27	50.2875	2281900.0
2019-07-09 14:30:00	AAPL	Stock	50.2875	50.3075	50.2525	50.2725	2025548.0
2019-07-09 15:00:00	AAPL	Stock	50.27	50.283	50.155	50.2062	3238944.0
2019-07-09 15:30:00	AAPL	Stock	50.2075	50.3775	50.1862	50.305	7480320.0
2019-07-09 16:00:00	AAPL	Stock	50.31	50.3325	50.265	50.2975	4789004.0
2019-07-09 16:30:00	AAPL	Stock	50.2958	50.31	50.2925	50.31	25860.0
2019-07-09 17:00:00	AAPL	Stock	50.3125	50.32	50.295	50.31	734168.0
2019-07-09 17:30:00	AAPL	Stock	50.3125	50.32	50.3	50.315	78440.0
2019-07-09 18:00:00	AAPL	Stock	50.3125	50.3375	50.295	50.3375	8096.0
2019-07-09 18:30:00	AAPL	Stock	50.3125	50.3125	50.285	50.285	5568.0
2019-07-09 19:00:00	AAPL	Stock	50.285	50.3	50.2025	50.25	28232.0
2019-07-09 19:30:00	AAPL	Stock	50.2125	50.25	50.2025	50.2175	16816.0
2019-07-09 04:00:00	MSFT	Stock	136.0	136.0	136.0	136.0	100.0
2019-07-09 04:30:00	MSFT	Stock	136.0	136.25	136.0	136.06	450.0
2019-07-09 05:00:00	MSFT	Stock	136.03	136.03	136.03	136.03	200.0
2019-07-09 05:30:00	MSFT	Stock	136.02	136.1	136.01	136.1	1699.0
2019-07-09 06:00:00	MSFT	Stock	136.07	136.27	136.07	136.19	458.0
2019-07-09 07:00:00	MSFT	Stock	136.15	136.2	136.11	136.12	2734.0
2019-07-09 07:30:00	MSFT	Stock	136.2	136.35	136.1	136.15	4992.0
2019-07-09 08:00:00	MSFT	Stock	136.1	136.35	136.08	136.1	6326.0
2019-07-09 08:30:00	MSFT	Stock	136.25	136.3	135.97	136.3	9646.0
2019-07-09 09:00:00	MSFT	Stock	136.2	136.2	136.01	136.05	8601.0
2019-07-09 09:30:00	MSFT	Stock	136.04	136.27	135.8	136.07	2601919.0
2019-07-09 10:00:00	MSFT	Stock	136.07	136.408	136.07	136.28	1400878.0
2019-07-09 10:30:00	MSFT	Stock	136.27	136.64	136.2	136.46	960468.0
2019-07-09 11:00:00	MSFT	Stock	136.45	136.77	136.405	136.44	1046242.0
2019-07-09 11:30:00	MSFT	Stock	136.445	136.59	136.28	136.54	678363.0
2019-07-09 12:00:00	MSFT	Stock	136.54	136.79	136.5	136.66	642867.0
2019-07-09 12:30:00	MSFT	Stock	136.65	136.97	136.61	136.863	796410.0
2019-07-09 13:00:00	MSFT	Stock	136.87	136.914	136.75	136.855	588366.0

> showing 50 of 83,961 rows — these rows as CSV

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