PREVIEW / stock_30min / 2016-11-11

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-11-11.parquet
  size:    1.6 MB
  rows:    83,932
  symbols: 3,186

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-11-11 04:00:00	AAPL	Stock	26.875	26.875	26.75	26.75	2000.0
2016-11-11 04:30:00	AAPL	Stock	26.7875	26.7875	26.625	26.625	2160.0
2016-11-11 05:00:00	AAPL	Stock	26.6625	26.6875	26.625	26.66	6396.0
2016-11-11 05:30:00	AAPL	Stock	26.625	26.6425	26.625	26.6425	4400.0
2016-11-11 06:00:00	AAPL	Stock	26.65	26.68	26.635	26.635	49552.0
2016-11-11 06:30:00	AAPL	Stock	26.65	26.7075	26.65	26.7075	9792.0
2016-11-11 07:00:00	AAPL	Stock	26.7075	26.7425	26.68	26.73	39272.0
2016-11-11 07:30:00	AAPL	Stock	26.69	26.74	26.6825	26.74	18728.0
2016-11-11 08:00:00	AAPL	Stock	26.7425	26.8175	26.6825	26.7875	194956.0
2016-11-11 08:30:00	AAPL	Stock	26.7875	26.8	26.7525	26.8	64312.0
2016-11-11 09:00:00	AAPL	Stock	26.8	26.835	26.7425	26.7725	187144.0
2016-11-11 09:30:00	AAPL	Stock	26.7575	27.0775	26.6375	26.8775	25699828.0
2016-11-11 10:00:00	AAPL	Stock	26.87	27.12	26.835	26.945	15920148.0
2016-11-11 10:30:00	AAPL	Stock	26.945	27.0952	26.9125	27.08	10057088.0
2016-11-11 11:00:00	AAPL	Stock	27.0775	27.1	26.975	27.0538	7231640.0
2016-11-11 11:30:00	AAPL	Stock	27.0538	27.1175	26.9575	27.0425	7102264.0
2016-11-11 12:00:00	AAPL	Stock	27.0425	27.17	27.0162	27.1535	8024520.0
2016-11-11 12:30:00	AAPL	Stock	27.155	27.2175	27.1125	27.1375	6619656.0
2016-11-11 13:00:00	AAPL	Stock	27.1375	27.2025	27.1225	27.1625	5393272.0
2016-11-11 13:30:00	AAPL	Stock	27.1618	27.1675	27.045	27.07	5107620.0
2016-11-11 14:00:00	AAPL	Stock	27.0675	27.115	27.0125	27.06	5910888.0
2016-11-11 14:30:00	AAPL	Stock	27.06	27.065	26.99	27.0025	4908828.0
2016-11-11 15:00:00	AAPL	Stock	27.001	27.085	27.001	27.0475	4665540.0
2016-11-11 15:30:00	AAPL	Stock	27.0475	27.155	27.03	27.105	11829392.0
2016-11-11 16:00:00	AAPL	Stock	27.105	27.145	27.095	27.11	8632248.0
2016-11-11 16:30:00	AAPL	Stock	27.11	27.12	27.1075	27.12	45632.0
2016-11-11 17:00:00	AAPL	Stock	27.115	27.1225	27.115	27.1225	40300.0
2016-11-11 17:30:00	AAPL	Stock	27.115	27.1225	27.1125	27.12	35964.0
2016-11-11 18:00:00	AAPL	Stock	27.125	27.125	27.12	27.125	9168.0
2016-11-11 18:30:00	AAPL	Stock	27.125	27.1475	27.1225	27.145	5856.0
2016-11-11 19:00:00	AAPL	Stock	27.145	27.145	27.1275	27.13	2388.0
2016-11-11 19:30:00	AAPL	Stock	27.1275	27.145	27.1275	27.13	25904.0
2016-11-11 04:00:00	MSFT	Stock	58.71	58.71	58.24	58.24	200.0
2016-11-11 05:00:00	MSFT	Stock	58.16	58.16	58.16	58.16	400.0
2016-11-11 06:00:00	MSFT	Stock	58.12	58.12	58.12	58.12	1355.0
2016-11-11 06:30:00	MSFT	Stock	58.16	58.16	58.16	58.16	400.0
2016-11-11 07:00:00	MSFT	Stock	58.12	58.13	58.1	58.13	12350.0
2016-11-11 07:30:00	MSFT	Stock	58.22	58.38	58.22	58.3	8820.0
2016-11-11 08:00:00	MSFT	Stock	58.05	58.45	58.05	58.2	21918.0
2016-11-11 08:30:00	MSFT	Stock	58.27	58.37	58.17	58.37	7271.0
2016-11-11 09:00:00	MSFT	Stock	58.36	58.4	58.2	58.26	15727.0
2016-11-11 09:30:00	MSFT	Stock	58.27	58.61	58.05	58.06	5739810.0
2016-11-11 10:00:00	MSFT	Stock	58.06	59.116	58.01	58.543	5266766.0
2016-11-11 10:30:00	MSFT	Stock	58.55	58.92	58.51	58.88	2605120.0
2016-11-11 11:00:00	MSFT	Stock	58.88	58.88	58.57	58.73	2082051.0
2016-11-11 11:30:00	MSFT	Stock	58.73	58.865	58.5	58.79	2067870.0
2016-11-11 12:00:00	MSFT	Stock	58.78	59.02	58.75	58.94	1692107.0
2016-11-11 12:30:00	MSFT	Stock	58.95	59.06	58.8	58.82	1688568.0
2016-11-11 13:00:00	MSFT	Stock	58.825	59.0	58.82	58.905	1026567.0
2016-11-11 13:30:00	MSFT	Stock	58.92	58.93	58.725	58.73	1303819.0

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

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