PREVIEW / stock_30min / 2015-10-01

all stock 30-min files

  file:    by_date/stock_30min/2015/2015-10-01.parquet
  size:    1.6 MB
  rows:    81,475
  symbols: 3,414

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
2015-10-01 04:00:00	AAPL	Stock	27.5625	27.97	27.5625	27.75	41120.0
2015-10-01 04:30:00	AAPL	Stock	27.7175	27.775	27.7175	27.775	6400.0
2015-10-01 05:00:00	AAPL	Stock	27.77	27.7975	27.7625	27.7775	13940.0
2015-10-01 05:30:00	AAPL	Stock	27.7375	27.7475	27.7125	27.7475	24876.0
2015-10-01 06:00:00	AAPL	Stock	27.7475	27.7475	27.68	27.68	59864.0
2015-10-01 06:30:00	AAPL	Stock	27.6525	27.6725	27.6125	27.625	30072.0
2015-10-01 07:00:00	AAPL	Stock	27.625	27.6375	27.2575	27.2575	371552.0
2015-10-01 07:30:00	AAPL	Stock	27.2525	27.4125	27.2175	27.2875	665600.0
2015-10-01 08:00:00	AAPL	Stock	27.25	27.7425	27.165	27.18	1388424.0
2015-10-01 08:30:00	AAPL	Stock	27.18	27.2975	27.1125	27.125	1135020.0
2015-10-01 09:00:00	AAPL	Stock	27.125	27.575	27.1	27.2725	1271628.0
2015-10-01 09:30:00	AAPL	Stock	27.27	27.305	26.925	26.9862	45064368.0
2015-10-01 10:00:00	AAPL	Stock	26.99	27.125	26.9175	26.995	25588076.0
2015-10-01 10:30:00	AAPL	Stock	26.9972	27.0225	26.8275	26.8775	20461048.0
2015-10-01 11:00:00	AAPL	Stock	26.88	26.9975	26.85	26.935	17745844.0
2015-10-01 11:30:00	AAPL	Stock	26.9375	27.1575	26.9175	27.06	17973796.0
2015-10-01 12:00:00	AAPL	Stock	27.0575	27.21	26.9625	27.17	14645280.0
2015-10-01 12:30:00	AAPL	Stock	27.17	27.26	27.14	27.1465	11741880.0
2015-10-01 13:00:00	AAPL	Stock	27.145	27.15	26.975	27.0075	10947936.0
2015-10-01 13:30:00	AAPL	Stock	27.01	27.125	26.9875	27.115	8305192.0
2015-10-01 14:00:00	AAPL	Stock	27.1175	27.2075	27.085	27.1275	9882104.0
2015-10-01 14:30:00	AAPL	Stock	27.13	27.3	27.13	27.2878	9546256.0
2015-10-01 15:00:00	AAPL	Stock	27.2885	27.3925	27.2375	27.3242	14934036.0
2015-10-01 15:30:00	AAPL	Stock	27.3225	27.405	27.185	27.3925	19018100.0
2015-10-01 16:00:00	AAPL	Stock	27.3925	27.4	27.34	27.3775	6042028.0
2015-10-01 16:30:00	AAPL	Stock	27.3775	27.4025	27.375	27.4	132588.0
2015-10-01 17:00:00	AAPL	Stock	27.4	27.41	27.39	27.4075	41140.0
2015-10-01 17:30:00	AAPL	Stock	27.4	27.4125	27.3975	27.3975	31440.0
2015-10-01 18:00:00	AAPL	Stock	27.3975	27.405	27.39	27.4	18640.0
2015-10-01 18:30:00	AAPL	Stock	27.3975	27.3975	27.39	27.39	15244.0
2015-10-01 19:00:00	AAPL	Stock	27.395	27.4	27.3825	27.39	49120.0
2015-10-01 19:30:00	AAPL	Stock	27.39	27.4125	27.39	27.41	37300.0
2015-10-01 04:00:00	MSFT	Stock	44.79	44.87	44.79	44.87	800.0
2015-10-01 05:00:00	MSFT	Stock	44.7	44.7	44.7	44.7	100.0
2015-10-01 05:30:00	MSFT	Stock	44.69	44.72	44.69	44.72	200.0
2015-10-01 06:00:00	MSFT	Stock	44.65	44.85	44.65	44.77	30523.0
2015-10-01 06:30:00	MSFT	Stock	44.8	44.83	44.71	44.71	7339.0
2015-10-01 07:00:00	MSFT	Stock	44.75	44.75	44.64	44.64	6517.0
2015-10-01 07:30:00	MSFT	Stock	44.63	44.7	44.51	44.6	17407.0
2015-10-01 08:00:00	MSFT	Stock	44.57	44.69	44.41	44.69	19592.0
2015-10-01 08:30:00	MSFT	Stock	44.61	44.7	44.57	44.6	16855.0
2015-10-01 09:00:00	MSFT	Stock	44.56	44.75	44.26	44.75	31597.0
2015-10-01 09:30:00	MSFT	Stock	44.75	44.76	43.84	43.87	4110865.0
2015-10-01 10:00:00	MSFT	Stock	43.88	44.349	43.87	44.31	2550551.0
2015-10-01 10:30:00	MSFT	Stock	44.32	44.36	43.95	43.97	2216528.0
2015-10-01 11:00:00	MSFT	Stock	43.97	44.16	43.93	44.095	1268105.0
2015-10-01 11:30:00	MSFT	Stock	44.1	44.18	43.87	43.955	1776936.0
2015-10-01 12:00:00	MSFT	Stock	43.95	43.95	43.75	43.88	1198876.0
2015-10-01 12:30:00	MSFT	Stock	43.89	43.93	43.82	43.875	737191.0
2015-10-01 13:00:00	MSFT	Stock	43.87	43.96	43.77	43.9	917955.0

> showing 50 of 81,475 rows — these rows as CSV

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