PREVIEW / stock_30min / 2016-01-13

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-01-13.parquet
  size:    1.6 MB
  rows:    83,787
  symbols: 3,397

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
2016-01-13 04:00:00	AAPL	Stock	25.2375	25.25	25.2225	25.225	9208.0
2016-01-13 04:30:00	AAPL	Stock	25.2025	25.2475	25.18	25.19	21820.0
2016-01-13 05:00:00	AAPL	Stock	25.2125	25.2175	25.135	25.165	8540.0
2016-01-13 05:30:00	AAPL	Stock	25.175	25.22	25.175	25.1875	29960.0
2016-01-13 06:00:00	AAPL	Stock	25.1925	25.225	25.1525	25.1725	61736.0
2016-01-13 06:30:00	AAPL	Stock	25.15	25.15	25.1	25.1225	28580.0
2016-01-13 07:00:00	AAPL	Stock	25.135	25.1725	25.0875	25.1625	59144.0
2016-01-13 07:30:00	AAPL	Stock	25.1625	25.1625	25.1	25.1	76552.0
2016-01-13 08:00:00	AAPL	Stock	25.1	25.205	25.075	25.1275	283452.0
2016-01-13 08:30:00	AAPL	Stock	25.135	25.1675	25.0725	25.085	267024.0
2016-01-13 09:00:00	AAPL	Stock	25.065	25.1825	24.99	25.09	1080432.0
2016-01-13 09:30:00	AAPL	Stock	25.08	25.205	24.97	25.1138	30629516.0
2016-01-13 10:00:00	AAPL	Stock	25.1125	25.1925	25.0	25.0525	16009464.0
2016-01-13 10:30:00	AAPL	Stock	25.0525	25.0815	24.9625	25.065	15295436.0
2016-01-13 11:00:00	AAPL	Stock	25.0638	25.2975	25.02	25.21	16632480.0
2016-01-13 11:30:00	AAPL	Stock	25.2125	25.2975	25.0775	25.1775	13137052.0
2016-01-13 12:00:00	AAPL	Stock	25.1775	25.1875	25.02	25.0492	11681360.0
2016-01-13 12:30:00	AAPL	Stock	25.05	25.0675	24.9775	25.03	10342120.0
2016-01-13 13:00:00	AAPL	Stock	25.03	25.045	24.8975	24.91	13126120.0
2016-01-13 13:30:00	AAPL	Stock	24.9075	24.9575	24.565	24.6	14714312.0
2016-01-13 14:00:00	AAPL	Stock	24.5952	24.7275	24.5725	24.6875	13516112.0
2016-01-13 14:30:00	AAPL	Stock	24.685	24.685	24.4625	24.5375	19048400.0
2016-01-13 15:00:00	AAPL	Stock	24.5375	24.6675	24.46	24.565	18624276.0
2016-01-13 15:30:00	AAPL	Stock	24.5625	24.6048	24.325	24.3525	29718024.0
2016-01-13 16:00:00	AAPL	Stock	24.3475	24.375	24.3275	24.3275	7412000.0
2016-01-13 16:30:00	AAPL	Stock	24.34	24.37	24.325	24.37	128912.0
2016-01-13 17:00:00	AAPL	Stock	24.3625	24.395	24.35	24.35	169620.0
2016-01-13 17:30:00	AAPL	Stock	24.3625	24.375	24.325	24.3375	261976.0
2016-01-13 18:00:00	AAPL	Stock	24.34	24.37	24.3375	24.37	30416.0
2016-01-13 18:30:00	AAPL	Stock	24.3625	24.3725	24.3525	24.355	34736.0
2016-01-13 19:00:00	AAPL	Stock	24.355	24.3625	24.325	24.325	64972.0
2016-01-13 19:30:00	AAPL	Stock	24.325	24.3475	24.3175	24.325	64388.0
2016-01-13 04:00:00	MSFT	Stock	53.61	53.66	53.54	53.59	15340.0
2016-01-13 04:30:00	MSFT	Stock	53.59	53.72	53.59	53.61	6670.0
2016-01-13 05:00:00	MSFT	Stock	53.66	53.72	53.61	53.63	10000.0
2016-01-13 05:30:00	MSFT	Stock	53.7	54.0	53.7	54.0	33284.0
2016-01-13 06:00:00	MSFT	Stock	53.94	54.03	53.85	54.0	14286.0
2016-01-13 06:30:00	MSFT	Stock	53.87	53.87	53.77	53.85	12230.0
2016-01-13 07:00:00	MSFT	Stock	53.85	53.85	53.5	53.77	47780.0
2016-01-13 07:30:00	MSFT	Stock	53.65	53.74	53.5	53.5	29995.0
2016-01-13 08:00:00	MSFT	Stock	53.75	53.75	53.5	53.75	174197.0
2016-01-13 08:30:00	MSFT	Stock	53.71	54.14	53.7	53.96	274882.0
2016-01-13 09:00:00	MSFT	Stock	53.95	54.1	53.8	53.97	209345.0
2016-01-13 09:30:00	MSFT	Stock	53.8	54.07	53.735	53.92	7059812.0
2016-01-13 10:00:00	MSFT	Stock	53.92	53.96	53.73	53.92	3719108.0
2016-01-13 10:30:00	MSFT	Stock	53.91	53.915	53.72	53.85	4555282.0
2016-01-13 11:00:00	MSFT	Stock	53.84	53.84	53.185	53.31	4718385.0
2016-01-13 11:30:00	MSFT	Stock	53.3	53.45	53.05	53.12	4397168.0
2016-01-13 12:00:00	MSFT	Stock	53.12	53.34	53.11	53.3	2431052.0
2016-01-13 12:30:00	MSFT	Stock	53.3	53.3	52.8	52.84	3284937.0

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

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