PREVIEW / stock_30min / 2016-08-11

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-11.parquet
  size:    1.6 MB
  rows:    81,289
  symbols: 3,263

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-08-11 06:30:00	AAPL	Stock	27.055	27.0725	27.035	27.035	25392.0
2016-08-11 07:00:00	AAPL	Stock	27.05	27.0625	27.0275	27.05	77364.0
2016-08-11 07:30:00	AAPL	Stock	27.0575	27.0975	27.05	27.0975	40260.0
2016-08-11 08:00:00	AAPL	Stock	27.0725	27.1	27.05	27.075	139600.0
2016-08-11 08:30:00	AAPL	Stock	27.085	27.1	27.0825	27.095	99924.0
2016-08-11 09:00:00	AAPL	Stock	27.0875	27.155	27.075	27.1325	98404.0
2016-08-11 09:30:00	AAPL	Stock	27.1375	27.2325	27.1275	27.14	16487476.0
2016-08-11 10:00:00	AAPL	Stock	27.14	27.16	27.0275	27.11	10404428.0
2016-08-11 10:30:00	AAPL	Stock	27.11	27.16	27.08	27.0938	6128040.0
2016-08-11 11:00:00	AAPL	Stock	27.095	27.133	27.0775	27.125	4527996.0
2016-08-11 11:30:00	AAPL	Stock	27.125	27.1762	27.121	27.1588	4066156.0
2016-08-11 12:00:00	AAPL	Stock	27.1588	27.1625	27.1075	27.125	3121772.0
2016-08-11 12:30:00	AAPL	Stock	27.1272	27.1375	27.1075	27.1288	2588248.0
2016-08-11 13:00:00	AAPL	Stock	27.13	27.1375	27.1088	27.1175	2841700.0
2016-08-11 13:30:00	AAPL	Stock	27.115	27.1275	27.0925	27.095	2663060.0
2016-08-11 14:00:00	AAPL	Stock	27.095	27.1475	27.095	27.1225	3243204.0
2016-08-11 14:30:00	AAPL	Stock	27.125	27.1275	27.0325	27.0412	5161292.0
2016-08-11 15:00:00	AAPL	Stock	27.04	27.0825	27.0375	27.0762	5220868.0
2016-08-11 15:30:00	AAPL	Stock	27.075	27.09	26.9625	26.9825	10735772.0
2016-08-11 16:00:00	AAPL	Stock	26.9825	27.0	26.98	26.9975	10632884.0
2016-08-11 16:30:00	AAPL	Stock	26.995	27.0125	26.9925	27.0075	87668.0
2016-08-11 17:00:00	AAPL	Stock	27.01	27.03	26.99	27.03	14024.0
2016-08-11 17:30:00	AAPL	Stock	27.01	27.01	27.01	27.01	2000.0
2016-08-11 18:00:00	AAPL	Stock	27.0125	27.03	27.0125	27.025	19772.0
2016-08-11 18:30:00	AAPL	Stock	27.005	27.025	27.005	27.0225	11160.0
2016-08-11 19:00:00	AAPL	Stock	27.0125	27.0225	27.0125	27.0225	11468.0
2016-08-11 19:30:00	AAPL	Stock	27.0225	27.0225	27.005	27.0075	21516.0
2016-08-11 06:00:00	MSFT	Stock	58.08	58.08	58.08	58.08	2363.0
2016-08-11 06:30:00	MSFT	Stock	58.08	58.09	58.08	58.09	1233.0
2016-08-11 07:30:00	MSFT	Stock	58.08	58.08	58.08	58.08	200.0
2016-08-11 08:00:00	MSFT	Stock	58.1	58.1	57.96	58.08	2031.0
2016-08-11 08:30:00	MSFT	Stock	58.05	58.15	58.05	58.15	23750.0
2016-08-11 09:00:00	MSFT	Stock	58.27	58.27	58.04	58.04	3795.0
2016-08-11 09:30:00	MSFT	Stock	58.03	58.45	58.03	58.37	2289590.0
2016-08-11 10:00:00	MSFT	Stock	58.37	58.41	58.19	58.27	1334950.0
2016-08-11 10:30:00	MSFT	Stock	58.275	58.31	58.18	58.21	1004949.0
2016-08-11 11:00:00	MSFT	Stock	58.21	58.27	58.14	58.27	717677.0
2016-08-11 11:30:00	MSFT	Stock	58.26	58.34	58.24	58.28	611004.0
2016-08-11 12:00:00	MSFT	Stock	58.29	58.29	58.17	58.195	964041.0
2016-08-11 12:30:00	MSFT	Stock	58.2	58.23	58.16	58.229	718693.0
2016-08-11 13:00:00	MSFT	Stock	58.23	58.24	58.17	58.215	793535.0
2016-08-11 13:30:00	MSFT	Stock	58.21	58.28	58.21	58.26	620339.0
2016-08-11 14:00:00	MSFT	Stock	58.26	58.305	58.2	58.249	733908.0
2016-08-11 14:30:00	MSFT	Stock	58.24	58.28	58.21	58.226	1003969.0
2016-08-11 15:00:00	MSFT	Stock	58.22	58.3	58.21	58.27	803669.0
2016-08-11 15:30:00	MSFT	Stock	58.27	58.36	58.26	58.3	2373101.0
2016-08-11 16:00:00	MSFT	Stock	58.3	58.32	58.3	58.32	2389888.0
2016-08-11 17:00:00	MSFT	Stock	58.3	58.3	58.3	58.3	100.0
2016-08-11 19:30:00	MSFT	Stock	58.3	58.3	58.25	58.25	999.0
2016-08-11 06:00:00	NVDA	Stock	1.4628	1.4628	1.4628	1.4628	4000.0

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

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