PREVIEW / stock_30min / 2016-02-10

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-02-10.parquet
  size:    1.5 MB
  rows:    81,584
  symbols: 3,350

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-02-10 04:00:00	AAPL	Stock	23.93	23.9875	23.785	23.925	1900.0
2016-02-10 04:30:00	AAPL	Stock	23.93	23.9625	23.9125	23.9625	4000.0
2016-02-10 05:00:00	AAPL	Stock	23.9625	24.0575	23.955	24.0575	10572.0
2016-02-10 05:30:00	AAPL	Stock	24.0125	24.05	23.9525	23.9525	9200.0
2016-02-10 06:00:00	AAPL	Stock	23.95	23.995	23.95	23.985	1400.0
2016-02-10 06:30:00	AAPL	Stock	23.9925	24.05	23.9925	24.0	10680.0
2016-02-10 07:00:00	AAPL	Stock	24.0225	24.0375	24.0	24.0	18640.0
2016-02-10 07:30:00	AAPL	Stock	23.995	24.035	23.97	24.03	39440.0
2016-02-10 08:00:00	AAPL	Stock	24.0175	24.1675	24.005	24.16	689604.0
2016-02-10 08:30:00	AAPL	Stock	24.15	24.1575	24.025	24.0325	393676.0
2016-02-10 09:00:00	AAPL	Stock	24.045	24.05	23.9425	23.98	285240.0
2016-02-10 09:30:00	AAPL	Stock	23.98	24.0538	23.8398	24.04	17565880.0
2016-02-10 10:00:00	AAPL	Stock	24.04	24.0625	23.9425	23.995	12296012.0
2016-02-10 10:30:00	AAPL	Stock	23.9975	24.0875	23.805	23.8375	15221584.0
2016-02-10 11:00:00	AAPL	Stock	23.84	23.9075	23.7925	23.815	10239568.0
2016-02-10 11:30:00	AAPL	Stock	23.815	23.87	23.745	23.815	9676920.0
2016-02-10 12:00:00	AAPL	Stock	23.815	23.8798	23.7875	23.8775	7686100.0
2016-02-10 12:30:00	AAPL	Stock	23.875	23.9075	23.8375	23.8975	8317660.0
2016-02-10 13:00:00	AAPL	Stock	23.9	23.95	23.8175	23.8325	6564000.0
2016-02-10 13:30:00	AAPL	Stock	23.8305	23.8375	23.78	23.79	7276500.0
2016-02-10 14:00:00	AAPL	Stock	23.79	23.85	23.7675	23.7987	11716920.0
2016-02-10 14:30:00	AAPL	Stock	23.8	23.86	23.6925	23.7125	11807048.0
2016-02-10 15:00:00	AAPL	Stock	23.7125	23.8075	23.5825	23.605	11937628.0
2016-02-10 15:30:00	AAPL	Stock	23.6035	23.638	23.525	23.5675	18638876.0
2016-02-10 16:00:00	AAPL	Stock	23.5675	23.7398	23.535	23.5675	8131144.0
2016-02-10 16:30:00	AAPL	Stock	23.57	23.5875	23.5475	23.5475	81936.0
2016-02-10 17:00:00	AAPL	Stock	23.5375	23.555	23.5375	23.5525	69940.0
2016-02-10 17:30:00	AAPL	Stock	23.56	23.585	23.55	23.5625	15500.0
2016-02-10 18:00:00	AAPL	Stock	23.58	23.58	23.555	23.555	16104.0
2016-02-10 18:30:00	AAPL	Stock	23.5625	23.5625	23.525	23.53	22480.0
2016-02-10 19:00:00	AAPL	Stock	23.5475	23.5475	23.53	23.5425	11628.0
2016-02-10 19:30:00	AAPL	Stock	23.5475	23.5475	23.5	23.5	71796.0
2016-02-10 04:30:00	MSFT	Stock	49.8	49.8	49.8	49.8	600.0
2016-02-10 05:00:00	MSFT	Stock	49.99	50.0	49.99	50.0	1000.0
2016-02-10 05:30:00	MSFT	Stock	50.0	50.0	50.0	50.0	100.0
2016-02-10 06:30:00	MSFT	Stock	49.99	49.99	49.99	49.99	100.0
2016-02-10 07:00:00	MSFT	Stock	49.93	49.98	49.74	49.74	1950.0
2016-02-10 07:30:00	MSFT	Stock	49.9	50.04	49.9	50.04	12541.0
2016-02-10 08:00:00	MSFT	Stock	49.99	50.1	49.93	50.04	4091.0
2016-02-10 08:30:00	MSFT	Stock	49.95	49.98	49.75	49.88	12342.0
2016-02-10 09:00:00	MSFT	Stock	49.88	49.93	49.65	49.93	14965.0
2016-02-10 09:30:00	MSFT	Stock	49.89	50.34	49.83	50.305	6326758.0
2016-02-10 10:00:00	MSFT	Stock	50.3	50.39	50.03	50.13	3255905.0
2016-02-10 10:30:00	MSFT	Stock	50.13	50.38	49.72	49.83	3622426.0
2016-02-10 11:00:00	MSFT	Stock	49.84	50.04	49.72	49.88	2371543.0
2016-02-10 11:30:00	MSFT	Stock	49.88	50.03	49.78	49.94	1886916.0
2016-02-10 12:00:00	MSFT	Stock	49.95	50.16	49.79	50.007	1816331.0
2016-02-10 12:30:00	MSFT	Stock	50.01	50.23	49.96	50.2	1845274.0
2016-02-10 13:00:00	MSFT	Stock	50.21	50.34	50.05	50.095	1691653.0
2016-02-10 13:30:00	MSFT	Stock	50.1	50.3	50.02	50.215	1362767.0

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

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