PREVIEW / stock_30min / 2017-08-10

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-10.parquet
  size:    1.6 MB
  rows:    82,684
  symbols: 2,986

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-08-10 04:00:00	AAPL	Stock	40.065	40.065	40.065	40.065	400.0
2017-08-10 04:30:00	AAPL	Stock	40.0375	40.0375	39.9975	39.9975	8340.0
2017-08-10 05:00:00	AAPL	Stock	40.0	40.0	39.9825	39.9825	3852.0
2017-08-10 05:30:00	AAPL	Stock	39.9825	39.9825	39.975	39.975	8636.0
2017-08-10 06:00:00	AAPL	Stock	39.9875	40.0	39.98	40.0	10340.0
2017-08-10 06:30:00	AAPL	Stock	40.015	40.015	39.9525	39.955	48776.0
2017-08-10 07:00:00	AAPL	Stock	39.9625	39.9875	39.9375	39.9825	43896.0
2017-08-10 07:30:00	AAPL	Stock	39.9825	40.025	39.9725	40.025	48248.0
2017-08-10 08:00:00	AAPL	Stock	40.005	40.0875	39.9375	40.075	257040.0
2017-08-10 08:30:00	AAPL	Stock	40.0825	40.1	40.0125	40.03	259268.0
2017-08-10 09:00:00	AAPL	Stock	40.05	40.0625	39.93	39.9975	293548.0
2017-08-10 09:30:00	AAPL	Stock	40.0	40.0025	39.7025	39.7442	16976456.0
2017-08-10 10:00:00	AAPL	Stock	39.7475	39.7875	39.5125	39.7475	12739044.0
2017-08-10 10:30:00	AAPL	Stock	39.7475	39.825	39.6625	39.7775	6061236.0
2017-08-10 11:00:00	AAPL	Stock	39.7785	39.7785	39.54	39.5942	6190740.0
2017-08-10 11:30:00	AAPL	Stock	39.5925	39.6325	39.3225	39.3725	10933816.0
2017-08-10 12:00:00	AAPL	Stock	39.3713	39.4775	39.27	39.3025	8926612.0
2017-08-10 12:30:00	AAPL	Stock	39.3008	39.32	39.105	39.2175	10530548.0
2017-08-10 13:00:00	AAPL	Stock	39.2175	39.3475	39.1625	39.34	7753228.0
2017-08-10 13:30:00	AAPL	Stock	39.34	39.3675	39.1475	39.2025	5929464.0
2017-08-10 14:00:00	AAPL	Stock	39.205	39.3225	39.1675	39.2875	5309732.0
2017-08-10 14:30:00	AAPL	Stock	39.2875	39.3625	39.195	39.2375	5405120.0
2017-08-10 15:00:00	AAPL	Stock	39.2375	39.2775	38.9225	39.0175	11594848.0
2017-08-10 15:30:00	AAPL	Stock	39.015	39.0525	38.6575	38.83	22026280.0
2017-08-10 16:00:00	AAPL	Stock	38.8275	39.08	38.815	38.8275	6441224.0
2017-08-10 16:30:00	AAPL	Stock	38.835	38.85	38.7675	38.7875	245400.0
2017-08-10 17:00:00	AAPL	Stock	38.7875	38.7875	38.75	38.765	84600.0
2017-08-10 17:30:00	AAPL	Stock	38.75	38.83	38.625	38.745	2076932.0
2017-08-10 18:00:00	AAPL	Stock	38.7375	38.83	38.6875	38.7225	2234104.0
2017-08-10 18:30:00	AAPL	Stock	38.72	38.785	38.71	38.785	100748.0
2017-08-10 19:00:00	AAPL	Stock	38.7875	38.805	38.74	38.74	56256.0
2017-08-10 19:30:00	AAPL	Stock	38.74	38.75	38.5925	38.6625	99668.0
2017-08-10 08:00:00	MSFT	Stock	72.25	72.25	72.07	72.08	11226.0
2017-08-10 08:30:00	MSFT	Stock	72.15	72.16	72.15	72.15	2022.0
2017-08-10 09:00:00	MSFT	Stock	72.1	72.15	71.95	71.99	30217.0
2017-08-10 09:30:00	MSFT	Stock	71.95	72.14	71.76	71.815	2316940.0
2017-08-10 10:00:00	MSFT	Stock	71.82	71.94	71.56	71.93	1699402.0
2017-08-10 10:30:00	MSFT	Stock	71.935	72.1	71.84	72.05	1088109.0
2017-08-10 11:00:00	MSFT	Stock	72.05	72.16	71.98	72.046	779621.0
2017-08-10 11:30:00	MSFT	Stock	72.045	72.115	71.73	71.8	1050003.0
2017-08-10 12:00:00	MSFT	Stock	71.795	71.93	71.7	71.77	1092651.0
2017-08-10 12:30:00	MSFT	Stock	71.77	71.9	71.605	71.855	1072439.0
2017-08-10 13:00:00	MSFT	Stock	71.85	72.0	71.84	71.95	800074.0
2017-08-10 13:30:00	MSFT	Stock	71.955	72.005	71.81	71.905	841991.0
2017-08-10 14:00:00	MSFT	Stock	71.91	72.07	71.82	72.04	947737.0
2017-08-10 14:30:00	MSFT	Stock	72.04	72.19	71.92	71.97	1079237.0
2017-08-10 15:00:00	MSFT	Stock	71.97	72.04	71.62	71.705	1686094.0
2017-08-10 15:30:00	MSFT	Stock	71.71	71.74	71.35	71.42	4387206.0
2017-08-10 16:00:00	MSFT	Stock	71.41	71.48	71.37	71.37	2724804.0
2017-08-10 16:30:00	MSFT	Stock	71.35	71.35	71.2	71.27	24797.0

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

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