PREVIEW / stock_30min / 2017-12-15

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-15.parquet
  size:    1.7 MB
  rows:    86,880
  symbols: 2,943

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
2017-12-15 04:00:00	AAPL	Stock	43.125	43.125	43.125	43.125	400.0
2017-12-15 05:00:00	AAPL	Stock	43.05	43.05	43.05	43.05	3600.0
2017-12-15 06:00:00	AAPL	Stock	43.0275	43.1125	43.0275	43.11	3584.0
2017-12-15 06:30:00	AAPL	Stock	43.1125	43.125	43.1125	43.125	8180.0
2017-12-15 07:00:00	AAPL	Stock	43.1025	43.1075	43.1025	43.1075	13072.0
2017-12-15 07:30:00	AAPL	Stock	43.1175	43.15	43.1125	43.15	59572.0
2017-12-15 08:00:00	AAPL	Stock	43.1375	43.1575	43.075	43.1375	159456.0
2017-12-15 08:30:00	AAPL	Stock	43.155	43.155	43.055	43.1375	48320.0
2017-12-15 09:00:00	AAPL	Stock	43.1375	43.4475	43.055	43.28	3025300.0
2017-12-15 09:30:00	AAPL	Stock	43.2025	43.42	43.115	43.2125	41944212.0
2017-12-15 10:00:00	AAPL	Stock	43.215	43.26	43.16	43.235	6147928.0
2017-12-15 10:30:00	AAPL	Stock	43.235	43.2675	43.16	43.1775	5044480.0
2017-12-15 11:00:00	AAPL	Stock	43.18	43.255	43.1675	43.205	4338188.0
2017-12-15 11:30:00	AAPL	Stock	43.205	43.255	43.1905	43.2502	3386624.0
2017-12-15 12:00:00	AAPL	Stock	43.25	43.4125	43.245	43.3825	5567232.0
2017-12-15 12:30:00	AAPL	Stock	43.3825	43.4012	43.3322	43.365	4145508.0
2017-12-15 13:00:00	AAPL	Stock	43.365	43.3925	43.3175	43.3262	2842968.0
2017-12-15 13:30:00	AAPL	Stock	43.3275	43.4075	43.315	43.3925	2973944.0
2017-12-15 14:00:00	AAPL	Stock	43.39	43.42	43.33	43.3625	4117480.0
2017-12-15 14:30:00	AAPL	Stock	43.365	43.415	43.35	43.411	3372516.0
2017-12-15 15:00:00	AAPL	Stock	43.4132	43.5375	43.39	43.5258	7287812.0
2017-12-15 15:30:00	AAPL	Stock	43.527	43.5425	43.3875	43.47	15603300.0
2017-12-15 16:00:00	AAPL	Stock	43.475	43.5225	43.4225	43.52	32440148.0
2017-12-15 16:30:00	AAPL	Stock	43.5175	43.52	43.485	43.5	433788.0
2017-12-15 17:00:00	AAPL	Stock	43.505	43.5125	43.5	43.5125	183572.0
2017-12-15 17:30:00	AAPL	Stock	43.51	43.5125	43.5	43.5	65860.0
2017-12-15 18:00:00	AAPL	Stock	43.5075	43.5075	43.5	43.5075	37432.0
2017-12-15 18:30:00	AAPL	Stock	43.5	43.51	43.5	43.51	20516.0
2017-12-15 19:00:00	AAPL	Stock	43.51	43.53	43.5075	43.525	23504.0
2017-12-15 19:30:00	AAPL	Stock	43.5125	43.53	43.5025	43.53	10268.0
2017-12-15 08:00:00	MSFT	Stock	85.0	85.0	85.0	85.0	100.0
2017-12-15 08:30:00	MSFT	Stock	84.69	85.03	84.69	85.03	3585.0
2017-12-15 09:00:00	MSFT	Stock	85.05	85.59	84.69	85.16	669993.0
2017-12-15 09:30:00	MSFT	Stock	85.16	85.48	84.88	85.395	13477068.0
2017-12-15 10:00:00	MSFT	Stock	85.39	85.83	85.385	85.71	1675107.0
2017-12-15 10:30:00	MSFT	Stock	85.71	86.034	85.635	86.015	1837111.0
2017-12-15 11:00:00	MSFT	Stock	86.01	86.36	86.01	86.32	1703475.0
2017-12-15 11:30:00	MSFT	Stock	86.32	86.67	86.3	86.66	1697113.0
2017-12-15 12:00:00	MSFT	Stock	86.66	87.09	86.62	86.995	1570460.0
2017-12-15 12:30:00	MSFT	Stock	86.995	87.0	86.715	86.785	1729899.0
2017-12-15 13:00:00	MSFT	Stock	86.78	86.88	86.58	86.6	1343452.0
2017-12-15 13:30:00	MSFT	Stock	86.61	86.755	86.53	86.72	811979.0
2017-12-15 14:00:00	MSFT	Stock	86.715	86.755	86.55	86.595	1046000.0
2017-12-15 14:30:00	MSFT	Stock	86.595	86.63	86.45	86.51	925681.0
2017-12-15 15:00:00	MSFT	Stock	86.52	86.95	86.49	86.945	1579523.0
2017-12-15 15:30:00	MSFT	Stock	86.95	86.975	86.65	86.82	4490584.0
2017-12-15 16:00:00	MSFT	Stock	86.85	86.98	86.76	86.85	14006234.0
2017-12-15 16:30:00	MSFT	Stock	86.87	86.96	86.85	86.9	136165.0
2017-12-15 17:00:00	MSFT	Stock	86.9	86.96	86.9	86.96	500.0
2017-12-15 17:30:00	MSFT	Stock	86.96	86.97	86.9	86.97	5057.0

> showing 50 of 86,880 rows — these rows as CSV

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