PREVIEW / stock_30min / 2017-10-27

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-10-27.parquet
  size:    1.7 MB
  rows:    83,906
  symbols: 2,930

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-10-27 04:00:00	AAPL	Stock	39.5325	39.5325	39.53	39.53	1892.0
2017-10-27 04:30:00	AAPL	Stock	39.505	39.505	39.505	39.505	400.0
2017-10-27 05:00:00	AAPL	Stock	39.55	39.59	39.55	39.5875	36076.0
2017-10-27 05:30:00	AAPL	Stock	39.5975	39.6	39.5925	39.6	20632.0
2017-10-27 06:00:00	AAPL	Stock	39.6225	39.6775	39.6025	39.67	10564.0
2017-10-27 06:30:00	AAPL	Stock	39.64	39.7125	39.625	39.7125	93768.0
2017-10-27 07:00:00	AAPL	Stock	39.6875	39.725	39.6525	39.665	104312.0
2017-10-27 07:30:00	AAPL	Stock	39.67	39.8125	39.6475	39.7675	223692.0
2017-10-27 08:00:00	AAPL	Stock	39.75	39.985	39.535	39.985	555496.0
2017-10-27 08:30:00	AAPL	Stock	39.895	39.95	39.83	39.8775	379744.0
2017-10-27 09:00:00	AAPL	Stock	39.8775	40.0375	39.8075	39.82	1245280.0
2017-10-27 09:30:00	AAPL	Stock	39.825	39.9325	39.675	39.88	21865428.0
2017-10-27 10:00:00	AAPL	Stock	39.8875	40.1525	39.8625	40.065	15806628.0
2017-10-27 10:30:00	AAPL	Stock	40.0675	40.2475	40.055	40.2062	11122488.0
2017-10-27 11:00:00	AAPL	Stock	40.205	40.495	40.155	40.485	11554116.0
2017-10-27 11:30:00	AAPL	Stock	40.485	40.6125	40.4175	40.5975	10944448.0
2017-10-27 12:00:00	AAPL	Stock	40.595	40.6975	40.585	40.675	10043904.0
2017-10-27 12:30:00	AAPL	Stock	40.675	40.7375	40.515	40.5562	9349544.0
2017-10-27 13:00:00	AAPL	Stock	40.559	40.6675	40.5425	40.64	6084340.0
2017-10-27 13:30:00	AAPL	Stock	40.6412	40.787	40.62	40.7785	7654852.0
2017-10-27 14:00:00	AAPL	Stock	40.7775	40.9	40.6675	40.6812	10295140.0
2017-10-27 14:30:00	AAPL	Stock	40.6825	40.729	40.58	40.65	8197980.0
2017-10-27 15:00:00	AAPL	Stock	40.6475	40.77	40.6275	40.77	8127368.0
2017-10-27 15:30:00	AAPL	Stock	40.775	40.7875	40.7	40.7575	15906320.0
2017-10-27 16:00:00	AAPL	Stock	40.7575	40.805	40.75	40.75	12553548.0
2017-10-27 16:30:00	AAPL	Stock	40.7275	40.7812	40.725	40.7375	132076.0
2017-10-27 17:00:00	AAPL	Stock	40.725	40.7625	40.725	40.76	581532.0
2017-10-27 17:30:00	AAPL	Stock	40.75	40.755	40.7175	40.7175	69764.0
2017-10-27 18:00:00	AAPL	Stock	40.7475	40.7575	40.675	40.69	72180.0
2017-10-27 18:30:00	AAPL	Stock	40.7	40.7375	40.7	40.7375	27352.0
2017-10-27 19:00:00	AAPL	Stock	40.7375	40.7575	40.725	40.725	18160.0
2017-10-27 19:30:00	AAPL	Stock	40.7375	40.75	40.6925	40.6925	40744.0
2017-10-27 04:00:00	MSFT	Stock	82.01	82.4	82.0	82.1	7866.0
2017-10-27 04:30:00	MSFT	Stock	82.08	82.2	82.0	82.2	2848.0
2017-10-27 05:00:00	MSFT	Stock	82.05	82.4	82.05	82.4	11217.0
2017-10-27 05:30:00	MSFT	Stock	82.4	82.5	82.39	82.5	1396.0
2017-10-27 06:00:00	MSFT	Stock	82.51	82.59	82.5	82.58	1577.0
2017-10-27 06:30:00	MSFT	Stock	82.58	82.59	82.42	82.45	9205.0
2017-10-27 07:00:00	MSFT	Stock	82.3	82.38	82.05	82.1	22908.0
2017-10-27 07:30:00	MSFT	Stock	82.1	83.51	82.1	83.33	94043.0
2017-10-27 08:00:00	MSFT	Stock	82.5	84.1	82.05	84.02	349800.0
2017-10-27 08:30:00	MSFT	Stock	84.02	84.67	84.0	84.65	973803.0
2017-10-27 09:00:00	MSFT	Stock	84.67	84.71	83.8	84.32	1787135.0
2017-10-27 09:30:00	MSFT	Stock	84.37	86.2	83.61	85.64	18013930.0
2017-10-27 10:00:00	MSFT	Stock	85.63	85.85	85.08	85.08	6601158.0
2017-10-27 10:30:00	MSFT	Stock	85.1	85.18	84.42	84.44	4750325.0
2017-10-27 11:00:00	MSFT	Stock	84.434	84.79	84.11	84.365	4158182.0
2017-10-27 11:30:00	MSFT	Stock	84.365	84.47	83.91	84.07	3698132.0
2017-10-27 12:00:00	MSFT	Stock	84.07	84.6	84.01	84.451	3189618.0
2017-10-27 12:30:00	MSFT	Stock	84.445	84.55	84.23	84.43	2246450.0

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

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