PREVIEW / stock_30min / 2016-06-15

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-06-15.parquet
  size:    1.6 MB
  rows:    82,111
  symbols: 3,291

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-06-15 04:00:00	AAPL	Stock	24.415	24.415	24.415	24.415	1072.0
2016-06-15 04:30:00	AAPL	Stock	24.4325	24.45	24.4325	24.4325	1300.0
2016-06-15 05:00:00	AAPL	Stock	24.45	24.4725	24.45	24.4725	4104.0
2016-06-15 05:30:00	AAPL	Stock	24.475	24.475	24.475	24.475	640.0
2016-06-15 06:00:00	AAPL	Stock	24.475	24.475	24.475	24.475	400.0
2016-06-15 07:00:00	AAPL	Stock	24.475	24.4825	24.45	24.475	25796.0
2016-06-15 07:30:00	AAPL	Stock	24.4775	24.4775	24.455	24.455	6632.0
2016-06-15 08:00:00	AAPL	Stock	24.4375	24.475	24.41	24.4525	133424.0
2016-06-15 08:30:00	AAPL	Stock	24.43	24.445	24.4025	24.445	98276.0
2016-06-15 09:00:00	AAPL	Stock	24.4425	24.455	24.43	24.45	81384.0
2016-06-15 09:30:00	AAPL	Stock	24.455	24.6025	24.45	24.495	16590664.0
2016-06-15 10:00:00	AAPL	Stock	24.495	24.5725	24.4775	24.4965	7796316.0
2016-06-15 10:30:00	AAPL	Stock	24.4975	24.5725	24.485	24.5525	6807696.0
2016-06-15 11:00:00	AAPL	Stock	24.5512	24.6025	24.5325	24.5375	6217796.0
2016-06-15 11:30:00	AAPL	Stock	24.535	24.56	24.5175	24.56	4528064.0
2016-06-15 12:00:00	AAPL	Stock	24.5575	24.5575	24.5	24.515	4167544.0
2016-06-15 12:30:00	AAPL	Stock	24.5138	24.5275	24.4425	24.445	4884460.0
2016-06-15 13:00:00	AAPL	Stock	24.445	24.47	24.415	24.46	3874844.0
2016-06-15 13:30:00	AAPL	Stock	24.4575	24.515	24.455	24.4725	3842428.0
2016-06-15 14:00:00	AAPL	Stock	24.4775	24.5525	24.465	24.4675	8222152.0
2016-06-15 14:30:00	AAPL	Stock	24.465	24.495	24.4375	24.455	5726704.0
2016-06-15 15:00:00	AAPL	Stock	24.4525	24.4625	24.3952	24.435	5945532.0
2016-06-15 15:30:00	AAPL	Stock	24.4325	24.4375	24.2575	24.285	16907612.0
2016-06-15 16:00:00	AAPL	Stock	24.285	24.295	24.245	24.255	13223616.0
2016-06-15 16:30:00	AAPL	Stock	24.255	24.285	24.25	24.2625	229860.0
2016-06-15 17:00:00	AAPL	Stock	24.2625	24.285	24.2525	24.255	148100.0
2016-06-15 17:30:00	AAPL	Stock	24.2725	24.2725	24.25	24.25	171484.0
2016-06-15 18:00:00	AAPL	Stock	24.25	24.2675	24.25	24.2525	11688.0
2016-06-15 18:30:00	AAPL	Stock	24.2525	24.2525	24.2475	24.2475	5952.0
2016-06-15 19:00:00	AAPL	Stock	24.2475	24.2625	24.2475	24.26	15480.0
2016-06-15 19:30:00	AAPL	Stock	24.26	24.265	24.2575	24.2625	22864.0
2016-06-15 05:30:00	MSFT	Stock	50.06	50.23	50.06	50.23	300.0
2016-06-15 06:00:00	MSFT	Stock	50.07	50.15	50.07	50.15	200.0
2016-06-15 06:30:00	MSFT	Stock	50.06	50.06	50.06	50.06	100.0
2016-06-15 07:00:00	MSFT	Stock	50.06	50.12	50.06	50.06	1000.0
2016-06-15 07:30:00	MSFT	Stock	50.06	50.06	50.06	50.06	300.0
2016-06-15 08:00:00	MSFT	Stock	50.12	50.12	49.97	49.97	2880.0
2016-06-15 08:30:00	MSFT	Stock	50.06	50.06	50.0	50.03	2381.0
2016-06-15 09:00:00	MSFT	Stock	50.05	50.05	49.72	49.84	5798.0
2016-06-15 09:30:00	MSFT	Stock	49.83	50.0	49.75	49.86	3325685.0
2016-06-15 10:00:00	MSFT	Stock	49.87	50.07	49.87	49.983	2160522.0
2016-06-15 10:30:00	MSFT	Stock	49.99	50.12	49.955	50.045	2119495.0
2016-06-15 11:00:00	MSFT	Stock	50.05	50.12	49.755	49.76	1531420.0
2016-06-15 11:30:00	MSFT	Stock	49.75	49.995	49.75	49.93	1286310.0
2016-06-15 12:00:00	MSFT	Stock	49.925	49.95	49.78	49.78	1470886.0
2016-06-15 12:30:00	MSFT	Stock	49.78	49.86	49.77	49.77	1586669.0
2016-06-15 13:00:00	MSFT	Stock	49.77	49.79	49.69	49.785	1622603.0
2016-06-15 13:30:00	MSFT	Stock	49.78	49.99	49.78	49.93	1251795.0
2016-06-15 14:00:00	MSFT	Stock	49.95	50.06	49.85	49.89	2330556.0
2016-06-15 14:30:00	MSFT	Stock	49.88	50.04	49.82	49.95	1810817.0

> showing 50 of 82,111 rows — these rows as CSV

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