PREVIEW / stock_30min / 2017-05-19

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-05-19.parquet
  size:    1.6 MB
  rows:    81,108
  symbols: 3,025

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
2017-05-19 04:00:00	AAPL	Stock	38.1625	38.1625	38.1625	38.1625	620.0
2017-05-19 05:00:00	AAPL	Stock	38.3	38.4375	38.3	38.4	24520.0
2017-05-19 05:30:00	AAPL	Stock	38.3725	38.3875	38.3725	38.38	4800.0
2017-05-19 06:00:00	AAPL	Stock	38.35	38.425	38.35	38.425	24664.0
2017-05-19 06:30:00	AAPL	Stock	38.4025	38.4025	38.325	38.3425	22312.0
2017-05-19 07:00:00	AAPL	Stock	38.36	38.3725	38.3525	38.3625	19664.0
2017-05-19 07:30:00	AAPL	Stock	38.3625	38.385	38.35	38.3525	125816.0
2017-05-19 08:00:00	AAPL	Stock	38.37	38.4875	38.36	38.455	419976.0
2017-05-19 08:30:00	AAPL	Stock	38.455	38.4725	38.4375	38.4575	144480.0
2017-05-19 09:00:00	AAPL	Stock	38.455	38.4575	38.31	38.3575	641760.0
2017-05-19 09:30:00	AAPL	Stock	38.3575	38.435	38.2525	38.315	23287044.0
2017-05-19 10:00:00	AAPL	Stock	38.3205	38.44	38.26	38.4225	8943392.0
2017-05-19 10:30:00	AAPL	Stock	38.425	38.4568	38.38	38.455	5773572.0
2017-05-19 11:00:00	AAPL	Stock	38.4538	38.495	38.3325	38.3425	6768884.0
2017-05-19 11:30:00	AAPL	Stock	38.3425	38.385	38.3025	38.385	3577312.0
2017-05-19 12:00:00	AAPL	Stock	38.3875	38.4125	38.34	38.375	3088564.0
2017-05-19 12:30:00	AAPL	Stock	38.3775	38.435	38.3625	38.41	3077832.0
2017-05-19 13:00:00	AAPL	Stock	38.41	38.425	38.3725	38.3875	3057860.0
2017-05-19 13:30:00	AAPL	Stock	38.3875	38.4125	38.3725	38.3925	2184344.0
2017-05-19 14:00:00	AAPL	Stock	38.3925	38.4125	38.315	38.33	4898588.0
2017-05-19 14:30:00	AAPL	Stock	38.329	38.39	38.32	38.3525	3908256.0
2017-05-19 15:00:00	AAPL	Stock	38.35	38.36	38.1775	38.2175	7767600.0
2017-05-19 15:30:00	AAPL	Stock	38.22	38.265	38.1575	38.2625	12900108.0
2017-05-19 16:00:00	AAPL	Stock	38.2425	38.265	38.2025	38.2475	8462768.0
2017-05-19 16:30:00	AAPL	Stock	38.265	38.265	38.2	38.235	147156.0
2017-05-19 17:00:00	AAPL	Stock	38.2475	38.25	38.235	38.2425	19856.0
2017-05-19 17:30:00	AAPL	Stock	38.25	38.265	38.25	38.265	23356.0
2017-05-19 18:00:00	AAPL	Stock	38.25	38.275	38.25	38.25	9804.0
2017-05-19 18:30:00	AAPL	Stock	38.2625	38.2625	38.2375	38.2375	21168.0
2017-05-19 19:00:00	AAPL	Stock	38.2375	38.2475	38.2375	38.2475	10532.0
2017-05-19 19:30:00	AAPL	Stock	38.2425	38.2575	38.215	38.215	26032.0
2017-05-19 06:00:00	MSFT	Stock	67.99	67.99	67.99	67.99	107.0
2017-05-19 06:30:00	MSFT	Stock	67.99	67.99	67.93	67.93	200.0
2017-05-19 07:00:00	MSFT	Stock	67.8	67.8	67.75	67.78	8805.0
2017-05-19 08:00:00	MSFT	Stock	67.73	67.86	67.73	67.86	10666.0
2017-05-19 08:30:00	MSFT	Stock	67.89	67.89	67.76	67.84	12326.0
2017-05-19 09:00:00	MSFT	Stock	67.8	67.84	67.47	67.52	77488.0
2017-05-19 09:30:00	MSFT	Stock	67.52	68.0	67.43	67.94	6266792.0
2017-05-19 10:00:00	MSFT	Stock	67.935	68.01	67.88	67.99	1198044.0
2017-05-19 10:30:00	MSFT	Stock	67.99	68.095	67.95	67.974	1409890.0
2017-05-19 11:00:00	MSFT	Stock	67.97	68.0	67.86	67.895	1182139.0
2017-05-19 11:30:00	MSFT	Stock	67.9	67.905	67.83	67.905	745804.0
2017-05-19 12:00:00	MSFT	Stock	67.9	67.98	67.9	67.916	665101.0
2017-05-19 12:30:00	MSFT	Stock	67.915	67.93	67.88	67.915	785252.0
2017-05-19 13:00:00	MSFT	Stock	67.91	67.92	67.76	67.76	718454.0
2017-05-19 13:30:00	MSFT	Stock	67.76	67.8	67.72	67.75	800224.0
2017-05-19 14:00:00	MSFT	Stock	67.75	67.8	67.69	67.76	1015357.0
2017-05-19 14:30:00	MSFT	Stock	67.76	67.92	67.755	67.87	705930.0
2017-05-19 15:00:00	MSFT	Stock	67.87	67.905	67.67	67.7	1277363.0
2017-05-19 15:30:00	MSFT	Stock	67.7	67.72	67.58	67.69	3871236.0

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

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